Convert Filesystem to Rac txkPostPDBCreationTasks.pl fails at autoconfig
Posted by munir on Oct 23, 2024; 12:43pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Convert-Filesystem-to-Rac-txkPostPDBCreationTasks-pl-fails-at-autoconfig-tp12716.html
Using Oracle 19c RAC Multitenant (Single PDB) with Oracle E-Business Suite Release
12.1 (Doc ID 2530680.1)
perl $ORACLE_HOME/appsutil/bin/txkPostPDBCreationTasks.pl -dboraclehome=/u01/app/oracle/product/19.3.0/dbhome_1 \
-outdir=/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log -cdbname=TESTCDB -cdbsid=TESTCDB1 -pdbsid=TEST \
-appsuser=apps -israc=yes -virtualhostname=rac1-vip -dbport=1529 -scanhostname=rac-scan.apps33.info \
-scanport=1521 -servicetype=onpremise
=============================
EXIT STATUS: 0
DB tables cleaned successfully.
LOG FILE: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/cleanup_db_tables.log.
################# BEGIN AUTOCONFIG RUN #################
Executing SYSTEM command: /u01/app/oracle/product/19.3.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/bin/adconfig.pl -contextfile=/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/TEST_rac1.xml -log=/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/acfg_log_Wed_Oct_23_17_46_28_2024.log
Log file: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/acfg_log_Wed_Oct_23_17_46_28_2024.log
stty: standard input: Inappropriate ioctl for device
Enter the APPS user password:
stty: standard input: Inappropriate ioctl for device
The log file for this session is located at: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/acfg_log_Wed_Oct_23_17_46_28_2024.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/app/oracle/product/19.3.0/dbhome_1
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Value of s_dbcset is AL32UTF8
Character set is not present in the allowed list. Need to add orai18n.jar to the CLASSPATH.
Library orai18n.jar exists.
Classpath : :/u01/app/oracle/product/19.3.0/dbhome_1/jdbc/lib/ojdbc8.jar:/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/java/xmlparserv2.jar:/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/java:/u01/app/oracle/product/19.3.0/dbhome_1/jlib/netcfg.jar:/u01/app/oracle/product/19.3.0/dbhome_1/jlib/ldapjclnt19.jar:/u01/app/oracle/product/19.3.0/dbhome_1/jlib/orai18n.jar
Using Context file : /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/TEST_rac1.xml
Context Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and templates to database...COMPLETED
Updating rdbms version in Context file to db19
Updating rdbms type in Context file to 64 bits
Configuring templates from ORACLE_HOME ...
AutoConfig completed with errors.
Failed to execute /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/bin/adconfig.pl.
AutoConfig did not run successfully.
Please check the log file /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/acfg_log_Wed_Oct_23_17_46_28_2024.log to resolve any errors and re-run AutoConfig.
################## END AUTOCONFIG RUN ##################
=================================
Inside getServiceNameFromCtx()...
=================================
Generating SQL file : /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.sql
SQL output file : /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.out
Spool File : /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/spool_get_patch_service_name.log
==========================
Inside executeSQLFile()...
==========================
Executing the SQL...
Execute SYSTEM command : sqlplus -s /nolog @/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.sql
==============================
Inside searchFileContents()...
==============================
log_file: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.out
pattern: ERROR
================
Pattern found...
================
Removing the file: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.sql
EXIT STATUS: 1
patch_service_name:
Failed to read patch service name from DB context file.
LOG FILE: /u01/app/oracle/product/19.3.0/dbhome_1/appsutil/log/TXK_POST_PDB_Wed_Oct_23_17_46_28_2024/get_patch_service_name.out.
*******FATAL ERROR*******
PROGRAM : (/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME : Wed Oct 23 17:50:34 2024
FUNCTION: main::getServiceNameFromCtx [ Level 1 ]
ERRORMSG: Failed to read patch service name from DB context file.
*******FATAL ERROR*******
PROGRAM : (/u01/app/oracle/product/19.3.0/dbhome_1/appsutil/bin/txkPostPDBCreationTasks.pl)
TIME : Wed Oct 23 17:50:34 2024
FUNCTION: main::getServiceNameFromCtx [ Level 1 ]
ERRORMSG: Failed to read patch service name from DB context file.