How do I drop an Oracle database including datafiles

 How do I drop an Oracle database including datafiles?1. Make a connection with the database as a sys user.[oracle@db01 ~]$export ORACLE_SID=CDB [oracle@db01 ~]$sqlplus '/ as sysdba'2. Shutdown the database.SQL> shu immediate3. Start Database in Exclusive mode till mount stage. Start the process to drop the oracle database manually.SQL>...

Read More

Unable to create files in the following UTL_FILE_DIR locations

 -----------------------------------------------------------------------------------------------------------------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-...

Read More

ORA-20100: Temporary file creation for FND_FILE failed

 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,...

Read More