This content has been marked as final. Show 10 replies
Let me walk you through briefly regarding the upgrade process:
Initially the existing instance was 220.127.116.11 with 18.104.22.168 database.Last year the database was upgraded to 22.214.171.124 and configured with 126.96.36.199
However the 11g database upgrade steps specifically for EBS 11i(interoperatibility notes for 11i with 11g database) was not followed properly.
And one of the major key issue identified was the 11g Example CD was not installed on top of 11g software during database upgrade.Which is the pre-req for 11g upgrade in EBS
And as per my experience it creates issues during R12 upgrade (patch u6678700) and giving errors pertaining to oracle text error.
SR was raised for the same and was suggested, since there is no other option kindly install the Oracle 11g software and on top of that 11g Example CD and map the 11g database and go ahead with the R12 upgrade.
Now coming back to the core issue being faced, Pre-req followed properly.No errors in alert logs.
Can missing the Example CD installtion be the issue?
ERROR at line 1:What is the status of FND_CP_GSM_OPP_AQ?
ORA-20000: Oracle Error Mkr1= -24018 - ORA-24018: STOP_QUEUE on
APPLSYS.FND_CP_GSM_OPP_AQ failed, outstanding transactions found
ORA-06512: at line 15
I even tried restarting the worker,bounced the database and even tried running u03/oracle/CRP1PROD/apps/apps_st/appl/fnd/12.0.0/patch/115/sql/afopp002.sql manually which hangs for indefinitely.Are you running the script as applsys user? -- FND_CP_GSM_OPP_AQ Queue is Invalidated After Patching [ID 311851.1]
The issue was resolved.
It was just the performance issue,resulting in adworkers to get hanged or error out.
I somehow noticed the below two parameters were not set in the init file to the proper value.
which according to my instance parallel_min_servers should be equal to cpu_count(SHow parameter cpu_count)=6
therefore after changing the values
and bouncing the database and starting the patch from the stage where it got error out resolved the issue.
Only apprehension is that it took almost 1hr 15mins to execute the afopp002.sql script.
Additionally, Quite relieved to know that examples CD installation even after 11g upgrade should not be the problem.