Tuesday, January 19, 2016

To abort forcefully running or failed ADOP session manually in R12.2.4


This error i faced recently , one of the older patch session was failed and was not getting aborted.
I tried
adop phase=abort
adop phase=apply abandon=yes patches=123456

nothing worked. Then i tried following workaround ,and guess what i came out of failing  adop_session_id and my patch cycle again started working normally.

------------------------------------------------------------------------------------------
1) Take a backup copy of the table ad_adop_sessions.

2) Connect to sqlplus as user apps and run
SQL> update ad_adop_sessions 
set abort_status = 'Y', 
status = 'C' 
where adop_session_id = 36; 

3) Then try to start a new adop session with
$ adop phase = prepare
---------------------------------------------------------------------------------------------


Note: Try above only after trying all possiblities. 

No comments:

Post a Comment

Oracle Database Administrator