My Oracle Support Banner

Why txkPostPDBCreationTasks.pl Generate DB Context File with Parameter s_db_util_filedir Value As /usr/tmp ? (Doc ID 2800713.1)

Last updated on JANUARY 21, 2024

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2.10 and later
Information in this document applies to any platform.

Goal

When running txkPostPDBCreationTasks.pl script on 19c RAC database, it generated a DB context file followed by running AutoConfig in the background.
The AutoConfig also ran txkCfgUtlfileDir.pl script in the background which resulted in below error.

txkCfgUtlfileDir.log :

==========================
Inside executeSQLFile()...
==========================

Executing the SQL...

Removing the file: <ORACLE_HOME>/appsutil/log/TXK_UTIL_DIR_Mon_Aug_2_17_46_39_2021/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...

===========================================
Inside checkUtlFileDirObjectPathExists()...
===========================================

EBS custom directory object ODPDIR exists for /usr/tmp
Directory object exists for path : /usr/tmp
*******FATAL ERROR*******
PROGRAM : (<ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl)
TIME : Mon Aug 2 17:46:41 2021
FUNCTION: main::checkUtlFileDir [ Level 1 ]
ERRORMSG: Directory /usr/tmp is a symbolic link.

Completed : Mon Aug 2 17:46:41 JST 2021

ERROR DESCRIPTION:
(*******FATAL ERROR*******
PROGRAM : (<ORACLE_HOME>/appsutil/bin/txkCfgUtlfileDir.pl)
TIME : Mon Aug 2 17:46:41 2021
FUNCTION: main::checkUtlFileDir [ Level 1 ]
ERRORMSG: Directory /usr/tmp is a symbolic link.
)

ERRORCODE = 1 ERRORCODE_END


This error was occurring because the generated DB context file automatically set parameter : s_db_util_filedir value as /usr/tmp directory.
Why did system automatically set /usr/tmp to parameter : s_db_util_filedir on DB context file?


 

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Goal
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.