Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

ORA-20010: ERROR: Unable to acquire lock on ad_adop_sessions table. AD_ADOP_SESSIONS table seems to

edited Aug 31, 2016 11:59PM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered ✓

Hi ,

adop phase=prepare fail with below errors and tried with below solutions but no luck.

select * from ad_adop_sessions where edition_name='LOCK' ;

   If it exists, issue below sql to unlock the table:

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

Before that Task which I have done is below:

As Part of EBSR12.2.5 ISG setup I have run below commands:

<span class="style1">ant -f $JAVA_TOP/oracle/apps/fnd/txk/util/txkSoaConfigUtility.xml ( Edits Context file & runs Autoconfig).<br/></span>

a<span class="style1">nt -f $JAVA_TOP/oracle/apps/fnd/bpel/util/txk_integration_packager.xml -DIntegration=isg  -DFMWNodeName=<soahostname.domain> -DFMWIpAddress=<SOA Suite IP address></span>

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center