Problem:
When rerunning patch 9239090, the following error appears:
ATTENTION: All workers either have failed or are waiting: FAILED: file mth_pre_upgrade.sql on worker 1. ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Checked worker log file:
C:oracleTEST1appsapps_stappladminTEST1logadwork001.log
The following errors appeared:
Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06 Time when worker started job: Mon Jan 30 2012 09:42:06 Start time for file is: Mon Jan 30 2012 09:42:06 sqlplus -s MTH/***** @C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql Error: Program exited with status 1 Cause: The program terminated, returning status code 1. Action: Check your installation manual for the meaning of this code on this operating system.DECLARE * ERROR at line 1: ORA-00955: name is already used by an existing object ORA-06512: at line 59 Time when worker failed: Mon Jan 30 2012 09:42:06
Solution:
1. Edit C:oracleTEST1appsapps_stapplmth12.0.0patch115sqlmth_pre_upgrade.sql and uncomment SQL code for Exception. Then restart worker (did not try this solution).
2. Use adctrl (option 8) to skip and restart this step (tried this solution).
Reference:
https://forums.oracle.com/forums/thread.jspa?messageID=9224027
[amazon asin=0070077290&template=iframe image&chan=default] [amazon asin=1453742735&template=iframe image&chan=default] [amazon asin=0615238440&template=iframe image&chan=default]
0 Comments.