This content has been marked as final. Show 4 replies
Ensure you have no invalid objects and if any exist, then compile them and restart the failed worker. Please also make sure the number of workers you are using to run this upgrade is not more than (1-1.5 * CPUs).
ORA-600/ORA-7445/ORA-700 Error Look-up Tool [ID 153788.1]
ORA-7445 [memcpy] [ID 310531.1]
Full Database Export Fails With ORA-03113 and ORA-01041 After Migrated To 64bit [ID 1497414.1]
Please confirm that you have the patches in the following docs applied.
Database Preparation Guidelines for an E-Business Suite Release 12.1 Upgrade [ID 761570.1]
Interoperability Notes EBS 12.0 and 12.1 with Database 11gR2 [ID 1058763.1]
If you still have the same issue, then please log a SR and upload the database log/trace files generated to Oracle support.
As promised am here to update you on how we solved the issue through Oracle Support.
EPB AW's Cannot Be Attached Or Do Not Exist [ID 795247.1].
Now this applies only for the AW's belonging to EPB as for the rest i deleted them manually.
Restarting the failed worker brought about this error:-
sqlplus -s APPS/***** @/apps/apps/apps_st/appl/msd/12.0.0/patch/115/sql/MSDODPCODE.sql
ERROR at line 1:
ORA-33292: Insufficient permissions to access analytic workspace APPS.ODPCODE
using the specified access mode.
ORA-06512: at "SYS.DBMS_AW", line 67
ORA-06512: at "SYS.DBMS_AW", line 131
ORA-06512: at "SYS.DBMS_AW", line 977
ORA-06512: at "SYS.DBMS_AW", line 930
ORA-33262: Analytic workspace APPS.ODPCODE does not exist.
ORA-06512: at "SYS.DBMS_AW", line 901
ORA-06512: at "APPS.MSD_AW_LOADER", line 10
ORA-06512: at line 3
So i followed the below doc and all is well now. The actual problem is 32bit AW's in a 64bit Database.
Thanks alot and good evening.
ORA-33292 Insufficient permissions to access analytic workspace APPS.ODPCODE Error When Applying Patch 9058835 [ID 977196.1]