APPLIES TO: Oracle Applications DBA - Version 12.1.3 to 12.2.9 [Release 12.1 to 12.2] SYMPTOMS: Autoconfig failed in application tier node after upgrading database to 19c on setting s_applptmp context variable to a location which was not physically existing in database tier node. PROGRAM : (/<base_location>/apps/apps_st/appl/fnd/12.0.0/patch/115/bin/txkCfgUtlfileDir.pl) TIME : <Timestamp> FUNCTION: main::checkApplpTmpOnFS [ Level 1 ] ERRORMSG: Value /<base_location>/inst/apps/<sid_hostname>/appltmp defined for s_applptmp context variable is INVALID. ) ERRORCODE = 1 ERRORCODE_END .end std out. *** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS *** Log File = /<base_location>/inst/apps/<sid_hostname>/logs/appl/rgf/TXK_UTIL_DIR_<timestamp>/txkCfgUtlfileDir.log /<base_location>/apps/apps_st/appl/fnd/12.0.0/bin/txkCfgUtlfileDir.sh: There is no process to read data written to a pipe. .end err out. [CVM Error Report] The following report lists errors encountered during CVM Phase <filename> <return code where appropriate> /<base_location>/apps/apps_st/appl/fnd/12.0.0/bin/txkCfgUtlfileDir.sh 1 No of scripts failed in CVM phase: 1 CHANGES: Performed database upgrade to 19c version. CAUSE: Multi node configuration where database and application tier resided in different server. So the requirement was to set to separate location for $APPLPTMP variable location in DB and apps tier node respectively. In apps tier server, the location for $APPLPTMP was to be set to /<base_location>/inst/apps/<sid_hostname>/appltmp which was physically not present in DB tier node. Hence adding $APPLPTMP location to UTL_FILE_DIR parameter using script txkCfgUtlfileDir.pl following note Using UTL_FILE_DIR or Database Directories for PL/SQL File I/O in Oracle E-Business Suite Releases 12.1 and 12.2 (Doc ID 2525754.1) was failing ultimately causing the autoconfig execution failure. SOLUTION: Below workaround can be implemented if $APPLPTMP location does not exist in DB tier node and is present in apps tier node: 1. Source the PDB environment file using the following command: $ORACLE_HOME/<pdb_name>_.env 2. Manually add the specified $APPLPTMP variable directory location of apps tier node in text file named <DB_NAME>_utlfiledir.txt located in the database tier <ORACLE_HOME>/dbs directory . 3. Then run perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE -oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=setUtlFileDir -skipdirvalidation=Yes 4. Run autoconfig in apps tier node. 5. Retest the issue.
Recent Posts
