ORA-20010: ERROR: Unable to acquire lock on ad_adop_sessions table. AD_ADOP_SESSIONS table seems to
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>