ADOP patch apply failure

[karthikmca.bhc]

Hi Erman,

Getting below error while applying ad txk patch using adop. Please provide fix.


[applmgr@qpupg ~]$ echo $FILE_EDITION
run
[applmgr@qpupg ~]$ adop phase=apply patches=25820806,26720905 merge=yes hotpatch=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

 Please wait. Validating credentials...


Enter the RUN file system context file name [/u01/applmgr/fs1/inst/apps/qpupg_qpupg/appl/admin/qpupg_qpupg.xml]: /u01/applmgr/fs1/inst/apps/qpupg_qpupg/appl/admin/qpupg_qpupg.xml

[STATEMENT] [END   2018/05/28 12:51:52] Performing verification of parameters
[STATEMENT] [START 2018/05/28 12:51:53] Checking for the required ENV setup
[STATEMENT] [END   2018/05/28 12:51:53] Checking for the required ENV setup

************* Start of  session *************
 version: 12.2.0
 started at: Mon May 28 2018 12:51:53

APPL_TOP is set to /u01/applmgr/fs1/EBSapps/appl
[STATEMENT] [START 2018/05/28 12:51:53] Determining admin node
[STATEMENT] [END   2018/05/28 12:51:56] Determining admin node
[STATEMENT]  Recommended Worker Count:  4 Max Allowed Workers: 72
[STATEMENT] [START 2018/05/28 12:52:01] Acquiring lock on sessions table
[STATEMENT] [END   2018/05/28 12:52:02] Acquiring lock on sessions table
[STATEMENT] [START 2018/05/28 12:52:02] Checking for any pending sessions
[STATEMENT] There is already a session which is incomplete. Details are:
[STATEMENT] Session Id: 3
[STATEMENT] Prepare phase status: Y
[STATEMENT] Apply phase status: N
[STATEMENT] Cutover  phase status: N
[STATEMENT] Abort phase status: N
[STATEMENT] Session status: F
[STATEMENT] [Note: Y denotes that the phase is done
[STATEMENT]        N denotes that the phase has not been completed
[STATEMENT]        X denotes that the phase is not applicable
[STATEMENT]        R denotes that the phase is running (in progress) or ran
[STATEMENT]        F denotes that the phase has failed
[STATEMENT]        P (is applicable only to APPLY phase) denotes atleast
[STATEMENT]           one patch is already applied for the session id
[ERROR]     Cannot apply hotpatch as another online patching cycle is going on
[ERROR]     Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2018/05/28 12:52:35] Unlocking sessions table
[STATEMENT] [END   2018/05/28 12:52:36] Unlocking sessions table
[STATEMENT] Log file: /adop_20180528_125041.log
[STATEMENT] [START 2018/05/28 12:52:40] Unlocking sessions table
[STATEMENT] [END   2018/05/28 12:52:41] Unlocking sessions table
Can't call method "close" on an undefined value at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 239.

adop exiting with status = 255 (Fail)
[applmgr@qpupg ~]$
[applmgr@qpupg ~]$
[applmgr@qpupg ~]$
[applmgr@qpupg ~]$ adop -status

Enter the APPS username: apps
Enter the APPS password:


Current Patching Session ID: 3

Node Name Node Type Phase    Status    Started   Finished  Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
qpupg master PREPARE     COMPLETED    21-MAY-18 05:58:42 +04:00   21-MAY-18 06:00:19 +04:00  0:01:37
                                APPLY    NOT STARTED
                                CUTOVER     NOT STARTED
                                CLEANUP     NOT STARTED




File System Synchronization Used in this Patching Cycle: Light

For more information, see the full ADOP Status Report.
Generating full ADOP Status Report at location: /u01/applmgr/fs_ne/EBSapps/log/status_20180528_125319/adzdshowstatus.out
Please wait...
Done...!

adop exiting with status = 0 (Success)

[ErmanArslansOracleBlog]

Did you create a new patching cycle before this move?
Does the document you are following instruct to do so?

Anyways;

abort the patching cycle ->

adop phase=abort
adop phase=cleanup cleanup_mode=full

Then, retry failing operation

Follow the document! In your case, it is probably -> Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)

[karthikmca.bhc]

Hi Erman,

Yes the issue solved after performing below as u recommended,
adop phase=abort
adop phase=cleanup cleanup_mode=full

The patch completed successfully and when i apply another patch im getting the below,

[applmgr@qpupg applmgr]$ adop phase=apply patches=24591000,26482811,22889868,27405878,27423814,27595967,26708775 merge=yes

Enter the APPS password:
Enter the SYSTEM password:
Enter the WLSADMIN password:

Validating credentials.

Initializing.
    Run Edition context  : /u01/applmgr/fs1/inst/apps/qpupg_qpupg/appl/admin/qpupg_qpupg.xml
    Patch edition context: /u01/applmgr/fs2/inst/apps/qpupg_qpupg/appl/admin/qpupg_qpupg.xml
    Patch file system free space: 358.29 GB

Validating system setup.
    Node registry is valid.
    [WARNING]   SYS.DUAL table has incorrect privileges
                Shut down the application tier services and then run the following commands in the order shown
                   sqlplus apps/<APPS_Password> @ $AD_TOP/patch/115/sql/ADFIXUSER.sql
                   sqlplus apps/<APPS_Password> @ $AD_TOP/sql/adutlrcmp.sql
    [WARNING]   MTCC has not been run. Apply Patch 17537119 and run checkMTpatch.sh.

Checking for existing adop sessions.
    No pending session exists.
    Starting new adop session.
   

    [UNEXPECTED]Can only run the apply phase after the prepare phase of a patching cycle.


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 2 (Fail)

[ErmanArslansOracleBlog]

This one is only a warning -> [WARNING]   SYS.DUAL table has incorrect privileges

This one is the error ->     [UNEXPECTED]Can only run the apply phase after the prepare phase of a patching cycle.

First run prepare phase , then run apply phase.!

[karthikmca.bhc]

Ok. But why I am getting below when i try to see the adop status? Im not able to see which status the phases are.

[applmgr@qpupg applmgr]$ adop -status

Enter the  password:*******FATAL ERROR*******
PROGRAM : (/u01/applmgr/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl)
TIME    : Mon May 28 15:14:16 2018
FUNCTION: TXK::SQLPLUS::setConnectInfo [ Level 2 ]
MESSAGES:
Argument <user> must be a scalar

STACK TRACE
 at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Error.pm line 168
        TXK::Error::abort('TXK::Error', 'HASH(0x517e438)') called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/Util.pm line 291
        TXK::Util::getScalarArg('TXK::Util', 'user', undef) called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/TXK/SQLPLUS.pm line 259
        TXK::SQLPLUS::setConnectInfo('TXK::SQLPLUS=HASH(0x465c940)', 'HASH(0x517fb60)') called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 388
        ADOP::GlobalVars::_validateUsrCredentials() called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 458
        ADOP::GlobalVars::_getADOPStatus(undef, undef) called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 2265
        ADOP::GlobalVars::_ValidateArgs() called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/GlobalVars.pm line 3111
        ADOP::GlobalVars::ValidateArgs('ADOP::GlobalVars') called at /u01/applmgr/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/AdopMain.pm line 1842
        ADOP::AdopMain::adopMain('ADOP::AdopMain') called at /u01/applmgr/fs1/EBSapps/appl/ad/12.0.0/bin/adzdoptl.pl line 148


[STATEMENT] Please run adopscanlog utility, using the command

"adopscanlog -latest=yes"

to get the list of the log files along with snippet of the error message corresponding to each log file.


adop exiting with status = 255 (Fail)

[ErmanArslansOracleBlog]

What is your current EBS version? "current" (for ex: 12.2.0? 12.2.4? 12.2.5?)

[karthikmca.bhc]

Im upgrading from EBS 12.1.3 to 12.2.7.

I completed the upgrade process by referring https://docs.oracle.com/cd/E26401_01/doc.122/e73540.pdf


now im in the stage of applying latest ad and txk 10 patches. I applied the AD patches as below and got successfully applied,
$ adop phase=apply patches=25820806,26720905 merge=yes hotpatch=yes

after applying the above i checked the status by running adop -status and I got that error posted in the previous post.

[ErmanArslansOracleBlog]

Did you do everything documented in -> "Applying the Latest AD and TXK Release Update Packs to Oracle E-Business Suite Release 12.2 (Doc ID 1617461.1)" ?
"3.1 Path A — Upgrade and New Installation Customers" --"everything"

[karthikmca.bhc]

Yes Erman did all steps given in that note ID. The mistake i did in applying critical AD patches is i forgot to apply those in hotpatch mode and thats the result i got the error saying that prepare is not run.

Now the critical patches apply is going on. I will update you if there any difficulties occur.

Thanks for the guidance and support. Your points are very useful.

[karthikmca.bhc]

Hi Erman,


Is it a mandatory that we must run fs_clone if we abort adop patching?

[ErmanArslansOracleBlog]

This is another question. Please create a seperate issue for this one.