In some case adop prepare phase fails due to some issues and if you wish to apply any patch in hotpatch mode, it will fail with below errors
[STATEMENT] There is already a session which is incomplete. Details are:
[STATEMENT] Session Id: 2
[STATEMENT] Prepare phase status: R
[STATEMENT] Apply phase status: N
[STATEMENT] Cutover phase status: N
[STATEMENT] Abort phase status: N
[STATEMENT] Session status: F
[STATEMENT] There is already a session which is incomplete. Details are:
[STATEMENT] Session Id: 2
[STATEMENT] Prepare phase status: R
[STATEMENT] Apply phase status: N
[STATEMENT] Cutover phase status: N
[STATEMENT] Abort phase status: N
[STATEMENT] Session status: F
[ERROR] Cannot apply hotpatch as another online patching cycle is going on
[ERROR] Unrecoverable error occured. Exiting the current session.
[STATEMENT] [START 2019/10/22 16:13:00] Unlocking sessions table
[STATEMENT] [END 2019/10/22 16:13:00] Unlocking sessions table
[STATEMENT] Log file: /adop_20191022_161221.log
[STATEMENT] [START 2019/10/22 16:13:02] Unlocking sessions table
[STATEMENT] [END 2019/10/22 16:13:03] Unlocking sessions table
Can't call method "close" on an undefined value at /u01/apps/TEST/fs1/EBSapps/appl/au/12.0.0/perl/ADOP/Phase.pm line 239.
Now, if you try to cleanup the previous session using below
$ adop phase=cleanup
[ERROR] Error: Pending session of prepare/apply/cutover exists
[ERROR] Hint: Before trying cleanup complete the pending session
[STATEMENT] [START 2019/10/22 16:18:36] Unlocking sessions table
[STATEMENT] [END 2019/10/22 16:18:36] Unlocking sessions table
[STATEMENT] Log file: /u01/apps/TEST/fs_ne/EBSapps/log/adop/2/adop_20191022_161746.log
adop exiting with status = 2 (Fail)
The solution is to abort the patching cycle as shown below:
Type Y when prompted
$ adop phase=abort
...
[STATEMENT] one patch is already applied for the session id
The above session would be aborted/rolled back. Do you want to continue [Y/N]? Y
[STATEMENT] adop phase=abort - Completed Successfully
$ adop -status
Node Name Node Type Phase Status Started Finished Elapsed
--------------- --------------- ----------- --------------- ------------------------------ ------------------------------ ------------
oel7 master PREPARE SESSION ABORTED 22-OCT-19 02:33:06 +03:00 22-OCT-19 02:54:06 +03:00 0:20:00
APPLY SESSION ABORTED
CUTOVER SESSION ABORTED
CLEANUP SESSION ABORTED
File System Synchronization Used in this Patching Cycle: None
For more information, see the full ADOP Status Report.
Generating full ADOP Status Report at location: /u01/apps/TEST/fs_ne/EBSapps/log/status_20191022_162759/adzdshowstatus.out
Please wait...
Done...!
adop exiting with status = 0 (Success)
I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here.Same as your blog i found another one Oracle Project Portfolio Management Cloud Training.Actually I was looking for the same information on internet for Oracle PPM and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details.
ReplyDeleteThanks for sharing this blog. The content is beneficial and useful. Very informative post. Visit here to learn more about Data Warehousing companies and Data analytics Companies. I am impressed by the information that you have on this blog. Thanks once more for all the details.Visit here for Top Big Data Companies.
ReplyDeleteSome truly wonderful work on behalf of the owner of this internet site , perfectly great articles . Entrümpelung Berlin
ReplyDeleteThanks
ReplyDelete