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

Collecting Version and Patch Inventory Details for Oracle Identity Manager 11g Issues

 Gathering version and patch details for issues in OIM 11g:  These steps assume Linux variables and pathing.  For Windows environments, adjust your steps accordingly.  For OIM 11g clustered domains which are *not* using shared storage, these commands must be run on each cluster nodes installation location. For the WLS home,...

Read More

Change APPS password in EBS R12.2.x Weblogic Admin server

Normal 0 false false false EN-US X-NONE AR-SA ...

Read More

Oracle EBS R12 on 19c Database

Oracle has recently announced the release of Oracle E-Business Suite 19c Database. With the Database 19c certification, EBS 12.2 On-Premises databases are now certified with the CDB architecture (multitenant architecture).   Background With the launch...

Read More