Hi Experts,
I'm trying to upgrade EBS from 12.1.3 to 12.2 in 19c DB, I've completed R12.2 rapid install to lay down the file system and technology stack (After laying down the File System using the Rapid Install). And then applied the latest application tier technology stack patches (using checkMTpatch.sh in R12.2).
1) But I am confused with the readme of patch 10117518 (Apply the AD Upgrade Patch 10117518 by merging it with the latest Consolidated Upgrade Patch (CUP) for AD (Patch 28853096:R12.AD.C)) and the Preparation Tasks is run adgrants.sql, does it mean there is using the adgrants.sql that from merged directory, not from patch 10117518 directory?I tried to run the "@adgrants.sql apps" that from merged directory ($PATCH_TOP/10117518_CUP10/admin/adgrants.sql), but it shown errors as below (Can I ignored it?):
###############
--- adgrants.sql started at 2020-05-18 21:10:32 ---
Creating PL/SQL profiler objects.
........
Start of PURGE DBA_RECYCLEBIN.
PL/SQL procedure successfully completed.
declare
*
ERROR at line 1:
ORA-00942: table or view does not exist
ORA-06512: at line 20
The following ERRORS and WARNINGS have been encountered during this adgrants session:
ERROR:
ORA-24338: statement handle not executed
SP2-0625: Error printing variable "result_set"
Grants given by this script have been written to the ad_zd_logs table.
You can run $AD_TOP/sql/ADZDSHOWLOG.sql to produce a report showing these grants.
Commit complete.
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.5.0.0.0
#################
2) And then I tried to apply the merged patch driver u_10117518_cup10.drv, but seem the patch is hanging on "completed file afsys.sql". Worker 3-8 is running with no progress for more than 48 hours while the other workers 1-2 are in wait state. (I'm using 8 workers to run it, can I increase the no. of workers to apply patches in 4 cpu cores AIX server?)
- adpatch log:
#################
......
There are now 79 jobs remaining (current phase=A2):
0 running, 1 ready to run and 78 waiting.
Assigned: file ADZDCTXB.pls on worker 1 for product ad username APPLSYS.
Completed: file ADZDCTXB.pls on worker 1 for product ad username APPLSYS.
Starting phase 3 (A3): con
There are now 78 jobs remaining (current phase=A3):
0 running, 9 ready to run and 69 waiting.
Assigned: file ADZDTABC.sql on worker 1 for product ad username APPLSYS.
Assigned: file addpapuu.sql on worker 2 for product ad username APPLSYS.
Assigned: file ad_objects.xdf on worker 3 for product ad username APPS.
Assigned: file ad_patched_tables.xdf on worker 4 for product ad username APPS.
Assigned: file ad_zd_ddl_handler.xdf on worker 5 for product ad username APPS.
Assigned: file ad_zd_ddl_handler_ddl_s.xdf on worker 6 for product ad username APPS.
Assigned: file ad_zd_logs.xdf on worker 7 for product ad username APPS.
Assigned: file ad_zd_logs_s.xdf on worker 8 for product ad username APPS.
Completed: file ADZDTABC.sql on worker 1 for product ad username APPLSYS.
Assigned: file afsys.sql on worker 1 for product fnd username APPLSYS.
Completed: file addpapuu.sql on worker 2 for product ad username APPLSYS.
Completed: file afsys.sql on worker 1 for product fnd username APPLSYS.
#################
- The status of Adworkers:
1 Run AutoPatch R120 Wait
2 Run AutoPatch R120 Wait
3 Run AutoPatch R120 ad_objects.xdf Running
4 Run AutoPatch R120 ad_patched_tables.xdf Running
5 Run AutoPatch R120 ad_zd_ddl_handler.xdf Running
6 Run AutoPatch R120 ad_zd_ddl_handler_ddl_s.xd Running
7 Run AutoPatch R120 ad_zd_logs.xdf Running
8 Run AutoPatch R120 ad_zd_logs_s.xdf Running
- I checked workers3-8 logs and I found ORA- errors. See the error below:
- adwork003 to adwork008 logs
###############
.....
NOTE: You may not use this utility for custom development
unless you have written permission from Oracle Corporation.
Reading product information from file...
Reading language and territory information from file...
Reading language information from applUS.txt ...
Temporarily resetting CLASSPATH to:
"/R12.2/oracle/SID/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/R12.2/oracle/SID/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/R12.2/oracle/SID/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/R12.2/oracle/SID/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/R12.2/oracle/SID/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/R12.2/oracle/SID/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/R12.2/oracle/SID/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/R12.2/oracle/SID/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/R12.2/oracle/SID/fs1/EBSapps/comn/java/classes:/R12.2/oracle/SID/fs1/EBSapps/10.1.2/forms/java:/R12.2/oracle/SID/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/R12.2/oracle/SID/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/R12.2/oracle/SID/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar"
Calling /R12.2/oracle/SID/fs1/EBSapps/comn/util/jdk32/jre/bin/java ...
Exception in thread "main" java.sql.SQLRecoverableException: ORA-01034: ORACLE not available
ORA-27101: shared memory realm does not exist
IBM AIX RISC System/6000 Error: 2: No such file or directory
Additional information: 2820
Additional information: -1500894085
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:397)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:389)
at oracle.jdbc.driver.T4CTTIoauthenticate.processError(T4CTTIoauthenticate.java:451)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4CTTIoauthenticate.doOSESSKEY(T4CTTIoauthenticate.java:412)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:403)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:678)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:235)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567)
at java.sql.DriverManager.getConnection(DriverManager.java:583)
at java.sql.DriverManager.getConnection(DriverManager.java:227)
at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1041)
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:276)
##################
Many thanks for your advice.