11.5.10.2 upgade fails on adworker for paxdty03.sql with ORA-00955 name is already used by an existing object
(Doc ID 2944217.1)
Last updated on APRIL 25, 2023
Applies to:
Oracle Applications DBA - Version 11.5.10.2 and laterOracle Project Foundation - Version 11.5.10.2 and later
Information in this document applies to any platform.
Symptoms
Upgrading EBS Application from 11.5.9 to 11.5.10.2 upgrade. For future 12.2 upgrade.
Patch 3480000 application upgrade driver fails
ATTENTION: All workers either have failed or are waiting:
FAILED: file paxdty03.sql on worker #.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Error in worker
sqlplus -s APPS/***** @/u01/oracle/product/app/pa/11.5.0/patch/115/sql/paxdty03.sql SYSTEM &systempwd &un_apps
Connected.
PL/SQL procedure successfully completed.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at "APPS_MRC.APPS_DDL", line 14
ORA-06512: at line 1
Changes
Applying patch 3480000 - ORACLE APPLICATIONS RELEASE 11.5.10.2 MAINTENANCE PACK
adpatch patchtop=$PATCH_TOP/3480000 driver=u3480000.drv
The paxdty03.sql script is checking to see if MRC is enabled and if so create these PA_VC_1000_%.TYPEs in the APPS_MRC schema.
As this object already exists in the APPS it is error.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Changes |
| Cause |
| Solution |
| Solutions |
| References |