[oracle4@devsrv appsutil]$ perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/p05/orajvj/app/tech_st/19.3.0/dbhome -outdir=/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log -cdbsid=TEST -pdbsid=JVJ -appsuser=apps -dbport=1581 -servicetype=onpremise Enter the APPS Password: Enter the CDB SYSTEM Password: Script Name : txkPostPDBCreationTasks.pl Script Version : 120.0.12020000.52 Started : Tue Feb 9 11:32:05 +03 2021 Log File : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/txkPostPDBCreationTasks.log ----------- Values used ----------- Database Oracle Home : /p05/orajvj/app/tech_st/19.3.0/dbhome CDB NAME : CDB SID : TEST DB Unique Name : PDB SID : JVJ Database port : 1581 OUT Directory : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log APPS Schema Username : apps Service Type : onpremise Is RAC? : No Virtual Hostname : Logical Hostname : Scan Hostname : Scan Port : Ignore scan details : No Generate UTL_FILE_DIR : No ========================= Validating oracle home... ========================= Oracle Home: /p05/orajvj/app/tech_st/19.3.0/dbhome exists. =========================== Validating out directory... =========================== Out directory: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log exists. ============================= Validating DB service type... ============================= Service Type: onpremise Service type is valid. ============================ Inside getDBHostDetails()... ============================ DB Hostname : devsrv DB Domain : hydev.com.sa Logical hostname is not passed, hence using physical hostname details. Logical Hostname : devsrv Logical Domain : hydev.com.sa ========================== Inside setContextName()... ========================== CONTEXT_NAME: JVJ_devsrv ===================== Inside getDBPort()... ===================== DB Port passed as an argument, using the same. DB Port: 1581 ============================ Inside setFileLocations()... ============================ SYSTEM_PWD_REUSE_FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/dbs/TEST_pwd_reuse_prf.txt ======================== Inside getDBVersion()... ======================== DB_VERSION = db190 ================================= Inside getVirtualHostDetails()... ================================= Non-RAC configuration, defaulting virtual hostname. Virtual Hostname : devsrv **** Setting ORACLE_UNQNAME to TEST **** Setting ORACLE_SID to TEST **** Setting TNS_ADMIN to /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin =========================== Inside setListenerFlag()... =========================== Before: START_STOP_LISTENER_FLAG: 0 After: START_STOP_LISTENER_FLAG: 1 =========================== Inside stopPDBListener()... =========================== Executing SYSTEM command: lsnrctl stop JVJ > /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_PDB_stop.txt PDB listener stopped successfully. =========================== Inside stopCDBListener()... =========================== Executing SYSTEM command: lsnrctl stop TEST > /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_CDB_stop.txt ============================= Inside checkGridListener()... ============================= log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_CDB_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: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_CDB_stop.txt Pattern NO LISTENER is found, error will be ignored. CDB listener stopped. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_CDB_stop.txt. ================================ Inside generateCDBSqlNetOra()... ================================ Creating the directory: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_cdb_bkp Creating the directory: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_cdb_temp File already exists. Skipping instantiation of sqlnet.ora. Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/sqlnet.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_cdb_bkp/sqlnet.ora ============================== Inside updateCDBSqlNetOra()... ============================== Updating the IFILE entry... ====================================== Inside generatePDBTNSAdminContent()... ====================================== Creating the directory: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_bkp Creating the directory: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_temp Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/template/ad8ilsnr.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_temp/listener.ora =================================== Inside replaceContextVariables()... =================================== File /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/listener.ora does not exist. Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_temp/listener.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/listener.ora Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/template/ad8itns.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_temp/tnsnames.ora =================================== Inside replaceContextVariables()... =================================== File /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/tnsnames.ora does not exist. Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_temp/tnsnames.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/tnsnames.ora ================================ Inside generatePDBSqlNetOra()... ================================ Directory /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/tns_admin_pdb_bkp already exists. File /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/sqlnet.ora does not exist. Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/sqlnet.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/sqlnet.ora File /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/sqlnet_ifile.ora does not exist. Copying the file ---------------- SOURCE : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/sqlnet_ifile.ora TARGET : /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv/sqlnet_ifile.ora ============================== Inside updatePDBSqlNetOra()... ============================== Updating the IFILE entry... ============================ Inside startCDBListener()... ============================ Executing SYSTEM command: lsnrctl start TEST > /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/lsnrctl_CDB_start.txt CDB listener started successfully. ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out. ======================== Starting the database... ======================== Startup mode : NONE Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out. ================================ Inside setDbDomainParameter()... ================================ Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Updating DB_DOMAIN parameter. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.out. ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/get_db_domain.out pattern: NOT-EMPTY ============================= Could not find the pattern... ============================= DB_DOMAIN parameter not set. Do nothing. ============================= Shutting down the database... ============================= Shutdown mode : IMMEDIATE Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/shutdown_IMMEDIATE.out. ======================== Starting the database... ======================== Startup mode : NONE Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 SQL execution went through successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/startup_NONE.out. ======================== Inside copyNLSFiles()... ======================== Executing SYSTEM command: perl /p05/orajvj/app/tech_st/19.3.0/dbhome/nls/data/old/cr9idata.pl Directory /p05/orajvj/app/tech_st/19.3.0/dbhome/nls/data/9idata already exist. Overwriting... Copying files to /p05/orajvj/app/tech_st/19.3.0/dbhome/nls/data/9idata... Copy finished. Please reset environment variable ORA_NLS10 to /p05/orajvj/app/tech_st/19.3.0/dbhome/nls/data/9idata! Script cr9idata.pl executed successfully. ================================== Inside compileEBSLOGONTrigger()... ================================== Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/compile_ebs_logon_trigger.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/compile_ebs_logon_trigger.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/compile_ebs_logon_trigger.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/compile_ebs_logon_trigger.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 EBS_LOGON trigger compiled successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/compile_ebs_logon_trigger.out. ================================= Inside createOPatchDBObjects()... ================================= Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/create_opatch_db_objects.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/create_opatch_db_objects.out ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/create_opatch_db_objects.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/create_opatch_db_objects.out pattern: ERROR ============================= Could not find the pattern... ============================= EXIT STATUS: 0 OPATCH directories created successfully. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/create_opatch_db_objects.out. **** Setting TNS_ADMIN to /p05/orajvj/app/tech_st/19.3.0/dbhome/network/admin/JVJ_devsrv for PDB Connectivity. =========================== Inside waitForListener()... =========================== cmd: lsnrctl status TEST | tr '[:lower:]' '[:upper:]' | awk '/\"JVJ\"/{print;getline;print;}' | grep TEST | grep -i READY Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... Waiting for service JVJ to be available... ============================= Inside checkDBConnection()... ============================= Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/check_db_connection.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/check_db_connection.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/check_db_connection.sql Removing the file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/check_db_connection.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/check_db_connection.log pattern: ORA-12514 ============================= Could not find the pattern... ============================= EXIT STATUS: 0 Connection successful. ===================================== Validating APPS schema credentials... ===================================== Generating SQL file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.sql SQL output file : /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.log ========================== Inside executeSQLFile()... ========================== Executing the SQL... Execute SYSTEM command : sqlplus -s /nolog @/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.sql Removing the file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.sql ============================== Inside searchFileContents()... ============================== log_file: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.log pattern: ERROR ================ Pattern found... ================ EXIT STATUS: 1 Invalid APPS database user credentials. LOG FILE: /p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/log/TXK_POST_PDB_Tue_Feb_9_11_32_00_2021/validate_apps_password.log. *******FATAL ERROR******* PROGRAM : (/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/bin/txkPostPDBCreationTasks.pl) TIME : Tue Feb 9 11:39:25 2021 FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid APPS database user credentials. *******FATAL ERROR******* PROGRAM : (/p05/orajvj/app/tech_st/19.3.0/dbhome/appsutil/bin/txkPostPDBCreationTasks.pl) TIME : Tue Feb 9 11:39:25 2021 FUNCTION: main::validateAppsSchemaCredentials [ Level 1 ] ERRORMSG: Invalid APPS database user credentials. [oracle4@devsrv appsutil]$