steaking adop

[latifa]

Hi Erman,

Once again I need your help for an issue concerning adop apply.
When applying a translated  patch, we faced an issue with error message:

[ERROR]     Failed to execute SQL statement:
   begin
    AD_ZD_ADOP.LOCK_SESSIONS_TABLE('hostname',60,6);
  end;

[ERROR]     Error Message:
[ERROR]     ORA-20010: ERROR: Unable to acquire lock on ad_adop_sessions table. LOCK row seems to have been inserted by another session
[ERROR]     ORA-06512: at "APPS.AD_ZD_ADOP", line 660
[ERROR]     ORA-06512: at line 2 (DBD ERROR: OCIStmtExecute)
[UNEXPECTED]Unable to acquire lock on sessions table.


--> there is no log file generated.

Even doing an abort failed with the same error message.

Thanks in advance for your help.

Regards,
Latifa DRIF

[ErmanArslansOracleBlog]

Hi Latifa,

Please check the following note ->

12.2 E-Business Suite Applications DBA Online Patching ADOP Utilities Fail With Error 'ORA-20010 Unable to acquire lock on ad_adop_sessions Table' (Doc ID 1903316.1)

[latifa]

I applied this note, it doesn't solve the issue.

Even I did :

create table ad_adop_sessions_bkp as select * from ad_adop_sessions;

delete from ad_adop_sessions where adop_session_id=0 and EDITION_NAME='LOCK';
commit;

again:
adop phase=abort allnodes=yes

--> The issue is still occuring.

[ErmanArslansOracleBlog]

Please follow the document line by line.
Don't delete anything.. Use the API documented in the document. (API may remove other records in other related tables) ->

 begin
   AD_ZD_ADOP.UNLOCK_SESSIONS_TABLE('<hostname>',60,6);
   end;
   /

--the numbers should be 60 and 6 for your case..

And the hostname should be appropriate! you should replace it properly with your hostname registered in EBS adop tables.

Also ensure there are no running adzop or adop session "ps -ef | grep adzop", "ps -ef|grep adop"

[latifa]

Hi Erman,

we have done what you said exactly and it doesn't work. we didn't know exaclty which hostname to use because we couldn't get the information from the select we run.

Oracle support said that is a "research" object. They asked us to check ETCC.

Actually, customer decided to restaure environnement before patches and we will see hopefully we will not have the issue again.

Regards
Latifa

[ErmanArslansOracleBlog]

You should use the hostname stored in fnd_nodes table..
Anyways, you already started restoring..

[Einnie]

I am facing issue with the new adop session since cloned from Production during adop cycle active. As per adop table cycle completed till finalize. We cloned two Development from the same backup.

Issue on Dev1 Please share the steps to start a new cycle since I am facing error with Prod node name.

Issue on another Dev: I have dropped ad_adop_session table by mistake but before I have took backup as create table ad_adop_sessions_,bkp as select*from ad_adop_sessions. Another option I have is export from Dev1.  Please share steps to recover since few adop packages got invalid when I created the table from _bkp
Please help

[ErmanArslansOracleBlog]

Hi Einnie,

You are requesting action plans for 2 different problems. Please create seperate issue for each of them, so I can support you efficiently. Don't forget to add some screenshots of a part of the error log , so I can see the problem in a little more details.