In one of our csutomer Environment during the Oracle E-Business suite siwtchover activity we encounted the following error during exeuction of autoconfig.
adcvmlog.xml renamed to /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/PROD_ERPAPPSdr01/06081214/adcvmlog.xml.06081215
[CVM Error Report]
The following report lists errors encountered during CVM Phase
/u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.sh 1
No of scripts failed in CVM phase: 1
AutoConfig is exiting with status 1
AutoConfig execution completed on Sat Jun 8 12:15:08 2024
Time taken for AutoConfig execution to complete : 0 mins 23 secs
Cause:
UTL_FILE_DIR is obselete with Database 19c and hence autoconfig is not able to set/locate the correct utl_file_dir
Solution:
Need to set utl_file_directory as per the new tech stack tools and once the locations are set to valid directories autoconfig will be completed successfully.
Script "txkCfgUtlfileDir.pl" will be used with three different actions to set this to valid location
mode=getUtlFileDir
mode=setUtlFileDir
mode=createDirObject
Execute Mode getUtlFileDir:
oraprod@ERPAPPSdr01:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/scripts/PROD_ERPAPPSdr01$ perl /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl \ -contextfile=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.xml -oraclehome=/u01/oracle/PRODDR/db/tech_st/19c \ -outdir=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/log -mode=getUtlFileDir Enter the APPS Password: *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_26_44_2024/txkCfgUtlfileDir.log Program : started @ Sat Jun 8 12:26:59 2024 *** Log File = /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_26_44_2024/txkCfgUtlfileDir.log Script Name : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started : Saturday, June 8, 2024 at 12:27:00 PM +03 Log File : /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_26_44_2024/txkCfgUtlfileDir.log Context file: /u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.xml exists.Execute Mode setUtlFileDir:
oraprod@ERPAPPSdr01:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/scripts/PROD_ERPAPPSdr01$ perl /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl \ -contextfile=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.xml -oraclehome=/u01/oracle/PRODDR/db/tech_st/19c \ -outdir=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/log -mode=setUtlFileDir Enter the APPS Password: Enter the SYSTEM Password: *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_30_12_2024/txkCfgUtlfileDir.log Program : started @ Sat Jun 8 12:31:24 2024 *** Log File = /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_30_12_2024/txkCfgUtlfileDir.log Script Name : txkCfgUtlfileDir.pl Script Version : 120.0.12010000.9 Started : Saturday, June 8, 2024 at 12:31:24 PM +03 Log File : /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_30_12_2024/txkCfgUtlfileDir.log Context file: /u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.xml exists. Value for s_applptmp on Apps Tier nodes is valid Completed : Saturday, June 8, 2024 at 12:31:31 PM +03 Successfully Completed the script ERRORCODE = 0 ERRORCODE_END oraprod@ERPAPPSdr01:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/scripts/PROD_ERPAPPSdr01$Execute Mode createDirObject:
perl /u01/oracle/PRODDR/db/tech_st/19c/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.xml -oraclehome=/u01/oracle/PRODDR/db/tech_st/19c -outdir=/u01/oracle/PRODDR/db/tech_st/19c/appsutil/log -mode=createDirObject Inside executeSQLFile()... ========================== Executing the SQL... Removing the file: /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/TXK_UTIL_DIR_Sat_Jun_8_12_38_57_2024/get_all_directory_objects.sql error_lines_array_length: 0 search_text_lines_array_length: 0 EXIT STATUS: 0 Getting the directory objects. Validating s_db_util_filedir...Execute Autoconfig:
oraprod@ERPAPPSdr01:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/scripts/PROD_ERPAPPSdr01$ adautocfg.sh
Enter the APPS user password:
The log file for this session is located at: /u01/oracle/PRODDR/db/tech_st/19c/appsutil/log/PROD_ERPAPPSdr01/06081243/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
Using ORACLE_HOME location : /u01/oracle/PRODDR/db/tech_st/19c
Classpath : :/u01/oracle/PRODDR/db/tech_st/19c/jdbc/lib/ojdbc8.jar:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/java/xmlparserv2.jar:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/java:/u01/oracle/PRODDR/db/tech_st/19c/jlib/netcfg.jar:/u01/oracle/PRODDR/db/tech_st/19c/jlib/ldapjclnt19.jar
Using Context file : /u01/oracle/PRODDR/db/tech_st/19c/appsutil/PROD_ERPAPPSdr01.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 successfully.
oraprod@ERPAPPSdr01:/u01/oracle/PRODDR/db/tech_st/19c/appsutil/scripts/PROD_ERPAPPSdr01$
Conclusion:
You should use correct and valid directories with required permissions in order to complete these scripts successfully.
Thanks for reading.
BR,
ZAHEER
Comments