EBS database post upgrade - Implementing Autoconfig failed in RAC
Posted by satish on Jan 25, 2023; 3:55pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/EBS-database-post-upgrade-Implementing-Autoconfig-failed-in-RAC-tp11502.html
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