April 2024 ~ Knowledge Base Articles On Oracle Technology and Cloud Computing

Data Center Consolidation

Data center consolidation is the process of reducing the volume of physical IT assets through highly efficient and scalable technologies. Organizations leverage data center consolidation to reduce operating costs.

Monday, April 29, 2024

Unable to create files in the following UTL_FILE_DIR locations

19c Database , Apps DBA , Concurrent Manager No comments

-----------------------------------------------------------------------------------------------------------------Warning: Unable to create files in the following UTL_FILE_DIR locations:- /u01/app/oratest1/oracle/product/temp/TEST1- /u01/app/oratest1/oracle/product/19.0.0.0/temp/TEST1-...

ORA-20100: Temporary file creation for FND_FILE failed

19c Database , ORA- , Oracle 12.2.x No comments

APP-AR-11526: ORA-20100: ORA-20100: Temporary file creation for FND_FILE failed.SOLUTIONThere are 4 steps for addressing the ORA-20100 error:1. utl_file_dir parameter is not set. Run following SQL to check: select value from v$parameter where name = 'utl_file_dir';If no value is returned, make the setup according to Doc ID 2525754.1,...