Sunday, 19 July 2020

ORA-20100: ORA-20100: File o0148195.tmp creation failed. after upgrade database to 19c

ERROR:
======

SQL> EXEC FND_STATS.GATHER_SCHEMA_STATISTICS ('ALL');
BEGIN FND_STATS.GATHER_SCHEMA_STATISTICS ('ALL'); END;

*
ERROR at line 1:
ORA-20100: ORA-20100: File o0148195.tmp creation failed.
File could not be opened or operated on as requested.
Action: Make sure the directory - /mwdb-pl/oracle/19.3.0.0/temp/erpdev - is a
valid directory with write permissions and is accessible from the database
server node
ORA-06512: at "APPS.FND_FILE", line 319
ORA-06512: at "APPS.FND_FILE", line 364
ORA-06512: at "APPS.FND_FILE", line 421
ORA-06512: at "APPS.FND_STATS", line 585
ORA-06512: at "APPS.FND_STATS", line 1044
ORA-06512: at "APPS.FND_STATS", line 1044
ORA-06512: at "APPS.FND_STATS", line 1275
ORA-06512: at "APPS.FND_STATS", line 1275
ORA-06512: at "APPS.FND_STATS", line 815
ORA-06512: at line 1

Solutions:
======

Step:1 Check UTL_FILE_DIR path sis exits.

SQL> select value from v$parameter where name='utl_file_dir';

VALUE
--------------------------------------------------------------------------------
/mwdb-pl/oracle/19.3.0.0/temp/erpdev,/mwdb-pl/oracle/19.3.0.0/db_3/appsutil/outb
ound/erpdev_host,/tmp


Step 2: Change the permission.

cd /mwdb-pl/oracle/19.3.0.0/temp
chmod 777 erpdev

Step: 3 Updating UTL_FILE_DIR in an Oracle E-Business Suite Instance on Oracle Database 19c (2525754.1)

oradev$perl $ORACLE_HOME/appsutil/bin/txkCfgUtlfileDir.pl -contextfile=$CONTEXT_FILE \
-oraclehome=$ORACLE_HOME -outdir=$ORACLE_HOME/appsutil/log -mode=addUtlFileDir

Step: 4 Re-execute step.1




No comments:

Post a Comment

OS Watcher Installation in RAC

 Step:1 Download and untar the oswbb812.tar under the grid user in RAC on the both nodes. Follow the OS Watcher User's Guide (Doc ID 153...