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:

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
2 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 Applications R12.2 Installation on Linux using virtual box

Oracle E-Business suite R12.2 is released a month ago. I received too many requests from my followers to demonstrate this Installation. This is a step by step detailed article for Installing Oracle E-business suite R12,2 on Oracle Enterprise Linux 5.7 (64-bit). I've used oracle virtual box for Installing Linux. Note:  This Installation is demonstrated on virtual machine with 8GB RAM and Installation completed in 7 hours. I am not sure whether this Installation will work with less than this .  My Virtual Machine configuration: CPU    = 1 core RAM   = 8 GB HDD   =  380 GB Software's Required: 1) Oracle Virtual Box 2) Oracle Enterprise Linux 5.7 (64-bit) 3) Oracle E-Business suite R12.2 for LinuxX86-64-bit Installation Steps: Hardware requirements Create virtual machine and Install operating system Operating System pre-requisites Prepare Stage Area Install Oracle EBS R12.2 software Verify Installation 1. Hardware Requirement
12 comments
Read more