Skip to main content

Oracle EBS R12.1.3 autoconfig failed with Error - txkCfgUtlfileDir.sh

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

Labels

Labels:

Comments

Post a Comment

Popular posts from this blog

Disable Firewall on Oracle Linux 8

In this blogpost we will see how we can stop/disable the firewall on Oracle Linux 8, the firewall command is same in both linux 7 an linux 8. The below listed is the procedure for stopping and disabling the  firewall on Oracle Linux 8. - Here we can see the firewall deamon in active state - Here when we stop the firewall in previous command, now the firewall daemon is dead - For permanent disabling the firewall on server, we can use "disable" option The following commands will be helpful: #systemctl status firewalld #systemctl stop firewalld #systemctl disable firewalld #systemctl enable firewalld #systemctl start firewalld Hope it helps !! Thanks for reading :) regards, X A H E E R
3 comments
Read more

Enable Desktop on Oracle Solaris 11.4

Oracle Solaris 11 installation has multiple options to choose for installation of an Operating Environment, but mostly Oracle Solaris text install media is used and this installation media doesn't offer the GUI Desktop Environment by default after the installation. This blog post will explain how we can enable the desktop for Oracle Solaris 11.4 operating system, after the completion of installation. We have to install "solaris-desktop" package and reboot the machine and GUI desktop will be enabled for the Operating System. In this blog post my virtual machine is connected to the internet and hence I am able to use available pupblic repository for package installation, if in case internet is not available for the server/machine then we have configure the local/Server  repository for the installation. Follow the below steps for desktop package installation: After installation of dekstop package we are now able to login with GUI desktop environment...
1 comment
Read more

Oracle AVDF Installation and Setup Document

This blogpost will provide you detailed information about Oracle Audit Vault and Database Firewall (Oracle AVDF) setup. Oracle AVDF is a comprehensive Database Activity Monitoring (DAM) solution that integrates with native audit data. Environment Setup: [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avcli mkdir: created directory ‘/oradb/oracle/avcli’ [oracrp@ebs-dev2-db01 ~]$ mkdir -pv /oradb/oracle/avagent mkdir: created directory ‘/oradb/oracle/avagent’ [oracrp@ebs-dev2-db01 ~]$ - Add these variables to the environment file vi DEV2CDB.env # AVS export AVCLI_HOME="/oradb/oracle/avcli" export AV_HOME="/oradb/oracle/avagent" export PATH="$PATH:$AV_HOME/bin" Download the JAR files:   AVDF installation requires one network interface card on respective hosts. IP assigned to AV server NIC will communicate with target databases and IP assigned to DF server will connect to AV Download - Agent jar file:   Login to AV console as avadmin user   - Go t...
Post a Comment
Read more