Issue# 27:
While applying main upgrade merged patch
ATTENTION: All workers either have failed or are waiting:
FAILED: file jtfescmig.sql on worker 1.
FAILED: file jtfescmig.sql on worker 2.
FAILED: file jtfescmig.sql on worker 3.
FAILED: file jtfescmig.sql on worker 4.
FAILED: file jtfescmig.sql on worker 5.
FAILED: file jtfescmig.sql on worker 6.
FAILED: file wfdspifx.sql on worker 7.
FAILED: file jtfescmig.sql on worker 8.
FAILED: file jtfescmig.sql on worker 9.
FAILED: file jtfescmig.sql on worker 10.
FAILED: file jtfescmig.sql on worker 11.
FAILED: file jtfescmig.sql on worker 12.
FAILED: file jtfescmig.sql on worker 13.
FAILED: file jtfescmig.sql on worker 14.
FAILED: file jtfescmig.sql on worker 15.
FAILED: file jtfescmig.sql on worker 16.
FAILED: file jtfescmig.sql on worker 17.
FAILED: file jtfescmig.sql on worker 18.
FAILED: file jtfescmig.sql on worker 19.
FAILED: file jtfescmig.sql on worker 20.
FAILED: file jtfescmig.sql on worker 21.
FAILED: file jtfescmig.sql on worker 22.
FAILED: file jtfescmig.sql on worker 23.
FAILED: file jtfescmig.sql on worker 24.
FAILED: file jtfescmig.sql on worker 25.
FAILED: file jtfescmig.sql on worker 26.
FAILED: file jtfescmig.sql on worker 27.
FAILED: file jtfescmig.sql on worker 28.
FAILED: file jtfescmig.sql on worker 29.
FAILED: file jtfescmig.sql on worker 30.
FAILED: file jtfescmig.sql on worker 31.
FAILED: file jtfescmig.sql on worker 32.
FAILED: file jtfescmig.sql on worker 33.
FAILED: file jtfescmig.sql on worker 34.
FAILED: file jtfescmig.sql on worker 35.
FAILED: file jtfescmig.sql on worker 36.
FAILED: file jtfescmig.sql on worker 37.
FAILED: file jtfescmig.sql on worker 38.
FAILED: file jtfescmig.sql on worker 39.
FAILED: file jtfescmig.sql on worker 40.
ATTENTION: Please fix the above failed worker(s) so the manager can continue.
Worker log:
sqlplus -s APPS/***** @/oracle/12.2/DPRO/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/adsqlwrapper.sql '/oracle/12.2/DPRO/fs1/EBSapps/appl/jtf/12.0.0/patch/115/sql/jtfescmig.sql &un_jtf &batchsize 26 40'
Connected.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-04080: trigger 'JTF_TERRITORIES_BIUD' does not exist
ORA-06512: at line 50
Solution:
[apdpro@r12upgdb log]$ ls -l $JTF_TOP/patch/115/sql/jtfterbidn.sql
-rwxr-xr-x 1 apdpro dba 6140 Nov 24 2012 /oracle/12.2/DPRO/fs1/EBSapps/appl/jtf/12.0.0/patch/115/sql/jtfterbidn.sql
[apdpro@r12upgdb log]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Sun Apr 23 13:38:26 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> @$JTF_TOP/patch/115/sql/jtfterbidn.sql
PL/SQL procedure successfully completed.
Commit complete.
Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
[apdpro@r12upgdb log]$
- Restart failed workers.
No comments:
Post a Comment