EBS database post upgrade - Implementing Autoconfig failed in RAC
Locked
 
|
Dear Erman,
Environment 2 node RAC We have upgraded GRID andn database to 19c. Facing error while implementing autoconfig. Please guide. 8.1 Implement AutoConfig on the Pluggable Database on the first Oracle RAC Node of the Cluster 2. Run the following script to implement the AutoConfig. Provide the APPS user password and SYSTEM user password of the CDB when prompted. [orauat@erpuatdb1 u02]$ export ORACLE_HOME=/u02/UAT19CBASE/19chome [orauat@erpuatdb1 u02]$ #export PATH=$PATH:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin [orauat@erpuatdb1 u02]$ export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_HOME/perl/bin:$PATH [orauat@erpuatdb1 u02]$ export ORACLE_BASE=/u02/UAT19CBASE [orauat@erpuatdb1 u02]$ export ORACLE_SID=uatcdb1 [orauat@erpuatdb1 u02]$ srvctl stop instance -d uatcdb -instance uatcdb2 [orauat@erpuatdb1 u02]$ /u02/UAT19CBASE/19chome -bash: /u02/UAT19CBASE/19chome: Is a directory [orauat@erpuatdb1 u02]$ cd /u02/UAT19CBASE/19chome/appsutil/ [orauat@erpuatdb1 appsutil]$ . ./txkSetCfgCDB.env dboraclehome=/u02/UAT19CBASE/19chome Oracle Home being passed: /u02/UAT19CBASE/19chome [orauat@erpuatdb1 appsutil]$ export ORACLE_SID=uatcdb1 [orauat@erpuatdb1 appsutil]$ perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/u02/UAT19CBASE/19chome \ > -outdir=/u02/UAT19CBASE/19chome/appsutil/log -cdbname=uatcdb -dbuniquename=uatcdb \ > -cdbsid=uatcdb1 -pdbsid=UATDB -appsuser=apps -israc=yes \ > -virtualhostname=erpuatdb1-vip -dbport=1522 -scanhostname=erpuat-scan \ > -scanport=1528 -servicetype=onpremise Enter the APPS Password: Enter the CDB SYSTEM Password: Script Name : txkPostPDBCreationTasks.pl Script Version : 120.0.12020000.50 Started : Wed Jan 25 21:08:20 IST 2023 Log File : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/txkPostPDBCreationTasks.log ----------- Values used ----------- Database Oracle Home : /u02/UAT19CBASE/19chome CDB NAME : uatcdb CDB SID : uatcdb1 DB Unique Name : uatcdb PDB SID : UATDB Database port : 1522 OUT Directory : /u02/UAT19CBASE/19chome/appsutil/log APPS Schema Username : apps Service Type : onpremise Is RAC? : yes Virtual Hostname : erpuatdb1-vip Logical Hostname : Scan Hostname : erpuat-scan Scan Port : 1528 Ignore scan details : No Generate UTL_FILE_DIR : No ========================= Validating oracle home... ========================= Oracle Home: /u02/UAT19CBASE/19chome exists. =========================== Validating out directory... =========================== Out directory: /u02/UAT19CBASE/19chome/appsutil/log exists. ============================= Validating DB service type... ============================= Service Type: onpremise Service type is valid. ============================ Inside getDBHostDetails()... ============================ DB Hostname : erpuatdb1 DB Domain : ttd.com Logical hostname is not passed, hence using physical hostname details. Logical Hostname : erpuatdb1 Logical Domain : ttd.com ========================== Inside setContextName()... ========================== CONTEXT_NAME: UATDB_erpuatdb1 ===================== Inside getDBPort()... ===================== DB Port passed as an argument, using the same. DB Port: 1522 ============================ Inside setFileLocations()... ============================ SYSTEM_PWD_REUSE_FILE: /u02/UAT19CBASE/19chome/dbs/uatcdb1_pwd_reuse_prf.txt ======================== Inside getDBVersion()... ======================== DB_VERSION = db190 ================================= Inside getVirtualHostDetails()... ================================= RAC configuration, virtual hostname is read from script arguments. Virtual Hostname : erpuatdb1-vip ============================ Inside checkScanDetails()... ============================ Scan Hostname : erpuat-scan Scan Port : 1528 **** Setting ORACLE_UNQNAME to uatcdb **** Setting ORACLE_SID to uatcdb1 **** Setting TNS_ADMIN to /u02/UAT19CBASE/19chome/network/admin =========================== Inside setListenerFlag()... =========================== Before: START_STOP_LISTENER_FLAG: 0 After: START_STOP_LISTENER_FLAG: 1 =========================== Inside stopPDBListener()... =========================== Executing SYSTEM command: lsnrctl stop UATDB > /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_PDB_stop.txt ============================= Inside checkGridListener()... ============================= log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_PDB_stop.txt pattern: TNS-01190 ========================================================== Grid listener not used. START/STOP of listener failed because of some other issue. Check the logs for details. ========================================================== ============================ Inside checkListenerLog()... ============================ log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_PDB_stop.txt Pattern TNS-01101 is found, error will be ignored. PDB listener stopped. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_PDB_stop.txt. =========================== Inside stopCDBListener()... =========================== Executing SYSTEM command: lsnrctl stop uatcdb > /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_CDB_stop.txt CDB listener stopped successfully. ================================ Inside generateCDBSqlNetOra()... ================================ Creating the directory: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_cdb_bkp Creating the directory: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_cdb_temp File already exists. Skipping instantiation of sqlnet.ora. Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/sqlnet.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_cdb_bkp/sqlnet.ora ============================== Inside updateCDBSqlNetOra()... ============================== Updating the IFILE entry... ====================================== Inside generatePDBTNSAdminContent()... ====================================== Creating the directory: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp Creating the directory: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_temp Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/appsutil/template/adlsnr10RAC.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_temp/listener.ora =================================== Inside replaceContextVariables()... =================================== Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/listener.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp/listener.ora Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_temp/listener.ora TARGET : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/listener.ora Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/appsutil/template/ad8itns.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_temp/tnsnames.ora =================================== Inside replaceContextVariables()... =================================== Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/tnsnames.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp/tnsnames.ora Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_temp/tnsnames.ora TARGET : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/tnsnames.ora ================================ Inside generatePDBSqlNetOra()... ================================ Directory /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp already exists. Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/sqlnet.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp/sqlnet.ora Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/sqlnet.ora TARGET : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/sqlnet.ora Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1/sqlnet_ifile.ora TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/tns_admin_pdb_bkp/sqlnet_ifile.ora File /u02/UAT19CBASE/19chome/network/admin/sqlnet_ifile.ora does not exist. ============================== Inside updatePDBSqlNetOra()... ============================== Updating the IFILE entry... ============================ Inside startCDBListener()... ============================ Executing SYSTEM command: lsnrctl start uatcdb > /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/lsnrctl_CDB_start.txt CDB listener started successfully. ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out. ======================== Starting the database... ======================== Startup mode : NONE Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out. ================================ Inside setDbDomainParameter()... ================================ Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Updating DB_DOMAIN parameter. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.out. ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.out pattern: NOT-EMPTY ================ Pattern found... ================ DB_DOMAIN parameter set. Checking for the parameter file. ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_db_domain.out pattern: SPFILE ================ Pattern found... ================ SPFILE is being used. Executing ALTER command. =============================== Inside setDbDomainInSPFILE()... =============================== File /u02/UAT19CBASE/19chome/dbs/spfileuatcdb1.ora does not exist. File /u02/UAT19CBASE/19chome/dbs/spfileuatcdb1.ora does not exist. Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/alter_db_domain.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/alter_db_domain.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/alter_db_domain.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/alter_db_domain.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 DB_DOMAIN set successfully in SPFILE. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/alter_db_domain.out. ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/shutdown_IMMEDIATE.out. ======================== Starting the database... ======================== Startup mode : NONE Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/startup_NONE.out. ======================== Inside copyNLSFiles()... ======================== Executing SYSTEM command: perl /u02/UAT19CBASE/19chome/nls/data/old/cr9idata.pl Directory /u02/UAT19CBASE/19chome/nls/data/9idata already exist. Overwriting... Copying files to /u02/UAT19CBASE/19chome/nls/data/9idata... Copy finished. Please reset environment variable ORA_NLS10 to /u02/UAT19CBASE/19chome/nls/data/9idata! Script cr9idata.pl executed successfully. ================================== Inside compileEBSLOGONTrigger()... ================================== Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/compile_ebs_logon_trigger.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/compile_ebs_logon_trigger.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/compile_ebs_logon_trigger.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/compile_ebs_logon_trigger.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 EBS_LOGON trigger compiled successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/compile_ebs_logon_trigger.out. ================================= Inside createOPatchDBObjects()... ================================= Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_opatch_db_objects.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_opatch_db_objects.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_opatch_db_objects.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_opatch_db_objects.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 OPATCH directories created successfully. LOG FILE: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_opatch_db_objects.out. **** Setting TNS_ADMIN to /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1 for PDB Connectivity. =========================== Inside waitForListener()... =========================== cmd: lsnrctl status uatcdb | tr '[:lower:]' '[:upper:]' | awk '/\"UATDB\"/{print;getline;print;}' | grep UATCDB1 | grep -i READY INSTANCE "UATCDB1", STATUS READY, HAS 1 HANDLER(S) FOR THIS SERVICE... ============================= Inside checkDBConnection()... ============================= Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/check_db_connection.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/check_db_connection.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/check_db_connection.sql Removing the file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/check_db_connection.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/check_db_connection.log pattern: ORA-12514 ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Connection successful. ===================================== Validating APPS schema credentials... ===================================== Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_apps_password.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_apps_password.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_apps_password.sql Removing the file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_apps_password.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_apps_password.log pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Validated APPS credentials. ======================================= Validating SYSTEM schema credentials... ======================================= ====================================== Inside checkSecCaseSensitiveLogon()... ====================================== Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_sec_case_sensitive_logon.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_sec_case_sensitive_logon.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_sec_case_sensitive_logon.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_sec_case_sensitive_logon.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Getting the parameter SEC_CASE_SENSITIVE_LOGON. Parameter SEC_CASE_SENSITIVE_LOGON is set to FALSE. sec_case_sensitive_logon_flag: FALSE Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_system_password.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_system_password.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_system_password.sql Removing the file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_system_password.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/validate_system_password.log pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Validated SYSTEM credentials. ============================== Inside getEBSCustomTables()... ============================== Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_user_table.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_user_table.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_user_table.sql Removing the file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_user_table.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/get_user_table.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Getting the user tables. Creating EBS custom views... ================================ Inside createEBSCustomViews()... ================================ Generating SQL file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_utl_file_views.sql SQL output file : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_utl_file_views.out ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param Table exists. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param_bk Table does not exist. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param Table exists. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param_bk Table exists. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param2 Table exists. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param2_bk Table does not exist. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param2 Table exists. ============================ Inside checkTableExists()... ============================ check_table_name = ebs_utlfile_param2_bk Table exists. ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus /nolog @/u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_utl_file_views.sql Removing the file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_utl_file_views.sql ============================== Inside searchFileContents()... ============================== log_file: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/create_utl_file_views.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Table and view created succussfully. ============================= Inside generateDBCtxFile()... ============================= Creating the directory: /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/ctx_bkp Copying the file ---------------- SOURCE : /u02/UAT19CBASE/19chome/appsutil/UATDB_erpuatdb1.xml TARGET : /u02/UAT19CBASE/19chome/appsutil/log/TXK_POST_PDB_Wed_Jan_25_21_08_09_2023/ctx_bkp/UATDB_erpuatdb1.xml Removing the file: /u02/UAT19CBASE/19chome/appsutil/UATDB_erpuatdb1.xml ========================== Inside setADBldXMLEnv()... ========================== Environment set ORACLE_HOME : /u02/UAT19CBASE/19chome TNS_ADMIN : /u02/UAT19CBASE/19chome/network/admin/UATDB_erpuatdb1 ORACLE_SID : UATDB PATH : /u02/UAT19CBASE/19chome/perl/bin:/u02/UAT19CBASE/19chome/bin:/usr/bin:/usr/sbin:/u02/UAT19CBASE/19chome/appsutil/jre/bin:/usr/ccs/bin:/bin:/usr/bin/X11:/usr/local/bin:/u02/UAT19CBASE/19chome/bin:/u02/UAT19CBASE/19chome/OPatch:/u02/UAT19CBASE/19chome/perl/bin:/usr/lib64/qt-3.3/bin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin LD_LIBRARY_PATH : /u02/UAT19CBASE/19chome/lib:/usr/X11R6/lib:/usr/openwin/lib:/usr/dt/lib:/u02/UAT19CBASE/19chome/ctx/lib DB_LISTENER : uatcdb DISPLAY : localhost:10.0 Executing SYSTEM command: perl /u02/UAT19CBASE/19chome/appsutil/bin/adbldxml.pl appsuser=apps servername=erpuatdb1.ttd.com virtualhost=erpuatdb1-vip enablescan=Y scanname=erpuat-scan scanport=1528 Starting context file generation for db tier.. Using JVM from /u02/UAT19CBASE/19chome/appsutil/jre/bin/java to execute java programs.. APPS Password: APPS Password: The log file for this adbldxml session is located at: /u02/UAT19CBASE/19chome/appsutil/log/adbldxml_01252112.log Exception in thread "main" java.lang.ExceptionInInitializerError at javax.crypto.JceSecurityManager.<clinit>(JceSecurityManager.java:65) at javax.crypto.Cipher.getConfiguredPermission(Cipher.java:2590) at javax.crypto.Cipher.getMaxAllowedKeyLength(Cipher.java:2614) at oracle.jdbc.driver.T4CConnection.<clinit>(T4CConnection.java:484) at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:75) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:816) at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:620) at java.sql.DriverManager.getConnection(DriverManager.java:664) at java.sql.DriverManager.getConnection(DriverManager.java:247) at oracle.apps.ad.context.GenerateContext.getDBConnection(GenerateContext.java:858) at oracle.apps.ad.context.GenerateContext.testDBCon(GenerateContext.java:792) at oracle.apps.ad.context.GenerateContext.getConParameters(GenerateContext.java:582) at oracle.apps.ad.context.GenerateContext.main(GenerateContext.java:2745) Caused by: java.lang.SecurityException: Can not initialize cryptographic mechanism at javax.crypto.JceSecurity.<clinit>(JceSecurity.java:93) ... 13 more Caused by: java.lang.SecurityException: The jurisdiction policy files are not signed by the expected signer! (Policy files are specific per major JDK release.Ensure the correct version is installed.) at javax.crypto.JarVerifier.verifyPolicySigned(JarVerifier.java:336) at javax.crypto.JceSecurity.loadPolicies(JceSecurity.java:378) at javax.crypto.JceSecurity.setupJurisdictionPolicies(JceSecurity.java:323) at javax.crypto.JceSecurity.access$000(JceSecurity.java:50) at javax.crypto.JceSecurity$1.run(JceSecurity.java:85) at java.security.AccessController.doPrivileged(Native Method) at javax.crypto.JceSecurity.<clinit>(JceSecurity.java:82) ... 13 more *******FATAL ERROR******* PROGRAM : (/u02/UAT19CBASE/19chome/appsutil/bin/txkPostPDBCreationTasks.pl) TIME : Wed Jan 25 21:12:27 2023 FUNCTION: main::generateDBCtxFile [ Level 1 ] ERRORMSG: Failed to execute /u02/UAT19CBASE/19chome/appsutil/bin/adbldxml.pl. *******FATAL ERROR******* PROGRAM : (/u02/UAT19CBASE/19chome/appsutil/bin/txkPostPDBCreationTasks.pl) TIME : Wed Jan 25 21:12:27 2023 FUNCTION: main::generateDBCtxFile [ Level 1 ] ERRORMSG: Failed to compile /u02/UAT19CBASE/19chome/appsutil/bin/adbldxml.pl. [orauat@erpuatdb1 appsutil]$ Thank you, Satish |
Re: EBS database post upgrade - Implementing Autoconfig failed in RAC
Administrator
|
Interesting issue.. DB level.. Probably due to java files in Oracle home.
This seems like a database-java related. Seems like there is a problem with Java Cryptography Extension (JCE) Unlimited Strength Jurisdiction Policy Files in the Oracle Home. Ref: Using Crypto Libraries in 12.2 DataBase For Java Calls Failing With ORA-29532 Java.Lang.NoClassDefFoundError (Doc ID 2701566.1) Check $ORACLE_HOME/javavm/lib/security.. Especially the files US_export_policy.jar and local_policy.jar. Compare it with another instance where you can successfully run adbldxml.pl.. Thay may be due to some patch.. A bug introduced with a patch .. Maybe due to OVJM patch.. Or maybe some missing post-patch actions.. Review how you got here, especially your OJVM related activities (if you did any). |
|
|
This post was updated on .
Dear erman,
Thanks for the update. No such files on both the nodes. [orauat@erpuatdb1 security]$ pwd /u02/UAT19CBASE/19chome/javavm/lib/security [orauat@erpuatdb1 security]$ ls cacerts java.security README.txt [orauat@erpuatdb1 security]$ and which java retruns [orauat@erpuatdb2 ~]$ which java /usr/bin/java [orauat@erpuatdb2 ~]$ [orasupp@erpsupportdb javavm]$ pwd /u01/SUPPDB/19.3.0 [orasupp@erpsupportdb 19.3.0]$ find . -name US_export_policy.jar ./OPatch123/jre/lib/security/policy/limited/US_export_policy.jar ./OPatch123/jre/lib/security/policy/unlimited/US_export_policy.jar ./OPatch/jre/lib/security/policy/limited/US_export_policy.jar ./OPatch/jre/lib/security/policy/unlimited/US_export_policy.jar ./appsutil/jre/lib/security/policy/limited/US_export_policy.jar ./appsutil/jre/lib/security/policy/unlimited/US_export_policy.jar ./javavm/jdk/jdk8/lib/security/US_export_policy.jar ./jdk/jre/lib/security/policy/limited/US_export_policy.jar ./jdk/jre/lib/security/policy/unlimited/US_export_policy.jar [orasupp@erpsupportdb 19.3.0]$ find . -name local_policy.jar ./OPatch123/jre/lib/security/policy/limited/local_policy.jar ./OPatch123/jre/lib/security/policy/unlimited/local_policy.jar ./OPatch/jre/lib/security/policy/limited/local_policy.jar ./OPatch/jre/lib/security/policy/unlimited/local_policy.jar ./appsutil/jre/lib/security/policy/limited/local_policy.jar ./appsutil/jre/lib/security/policy/unlimited/local_policy.jar ./javavm/jdk/jdk8/lib/security/local_policy.jar ./jdk/jre/lib/security/policy/limited/local_policy.jar ./jdk/jre/lib/security/policy/unlimited/local_policy.jar [orasupp@erpsupportdb 19.3.0]$ thank you |
Re: EBS database post upgrade - Implementing Autoconfig failed in RAC
|
Administrator
|
This post was updated on .
Looks okay. I just checked my 19C instance, and the directory structure is similar.
However; in my instance adbldxml.pl uses the following java: /u01/dbebs/product/19.0.0/jdk/jre/bin/java And the version is; [oracle@ebsclone bin]$ /u01/dbebs/product/19.0.0/jdk/jre/bin/java -version java version "1.8.0_261" Java(TM) SE Runtime Environment (build 1.8.0_261-b12) Java HotSpot(TM) 64-Bit Server VM (build 25.261-b12, mixed mode) Sp please check your java versions both the one in appsutil/jre and the one in ORACLE_HOME/jdk/jre/bin.. Also check from a proper instance and see if those 2 files that I mentioned in my last update are different than the ones in the problematic instance.. (you already find the files and know their directories) So, you can backup those 2 jar files and replace them from a proper instance(which can succesfully execute adbldxml.pl= and see if it will solve the issue or not. (normally we don't expect such an issue on 19C..So that's why it is weird but you can try Bytheway, can you run the adbldxml.pl manually? Do you get any error when you do that? --perl /u02/UAT19CBASE/19chome/appsutil/bin/adbldxml.pl appsuser=apps servername=erpuatdb1.ttd.com virtualhost=erpuatdb1-vip enablescan=Y scanname=erpuat-scan scanport=1528 I m aksing this because if you can succesully run adbldxml, then this fault is due to txkPostPDBCreationTasks.pl and if it is like that, we will concantrate on that part. |
|
|
Dear Erman,
You are so helpful. Thanks for the fix. We copied the jre folder from test instance to UAT to $ORACLE_HOME/appsutil/ It then worked. Thanks, Satish |
Re: EBS database post upgrade - Implementing Autoconfig failed in RAC
|
Administrator
|
Good :)
|
«
Return to EBS 12.2
|
1 view|%1 views
| Free forum by Nabble | Edit this page |