Skip to main content

CLEARING an ADOP patching session

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
[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)












Comments

  1. This comment has been removed by a blog administrator.

    ReplyDelete
  2. Thanks 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.

    ReplyDelete
  3. Some truly wonderful work on behalf of the owner of this internet site , perfectly great articles . Entrümpelung Berlin

    ReplyDelete

Post a Comment

Popular posts from this blog

How to install Apache using Ansible

How to install Apache using Ansible Use the powerful ansible tool to install Apache on your local machine or you can install on any remote server as well. 1. Install Ansible Modules [root@dev02 ~]# yum install ansible* Oracle Linux 8 EPEL Packages for Development (x86_64)                                                                                                             1.5 kB/s | 2.5 kB     00:01 Oracle Linux 8 Gluster Appstream (x86_64)                                                                        ...

RW-50010: Error: - script has returned an error: 2 (Executing cr9idata.pl) During R12.2 Installation on Oracle Linux 8

Problem Faced below error while Installing 12.2 on Linux 8. Unable to execute cr9idata.pl Executing cr9idata.pl Executing: perl /u01/oracle/DEV/12.1.0/nls/data/old/cr9idata.pl Unable to execute cr9idata.pl RW-50010: Error: - script has returned an error:   2 RW-50004: Error code received when running external process.  Check log file for details. Running Database Install Driver for DEV instance Solution: I have installed the following rpms: Install the following rpm  [root@dev02 DEV_dev2]# yum list perl-File-CheckTree* Available Packages perl-File-CheckTree.noarch                                                                         4.42-303.el8                                        ...