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