With the de-support of UTL_FILE_DIR with Oracle Database 18c. There’s a major behavior change in Oracle 18c/19c: No symbolic links for Data Pump directories. So if you have created a symbolic [...]

A new enhancement in Oracle Database version 21c is saving a lot if effort in Data pump activities. In the earlier versions of Oracle using the INCLUDE and EXCLUDE parameters in the data pump [...]

In Oracle E-Business Suite R12.1.3, when you try to view a report output/log, the following two errors are displayed: File server could not identify source file. or Authentication failed. In such [...]

The AWR snaps are usually generated at the CDB level by default. They can be created both at the CDB and PDB level.   To generate AWR report at CDB level, SQL> alter session set [...]

Every time a customer or client asks for a list of EBS Users and their responsibilities, the DBA team would generally execute the “Active Users” Concurrent Program from the System [...]

Useful commands to find the versions of various components used in Oracle E-Business Suite Find Apache Version or Oracle Application server version in R12 Log in to the Application server and [...]

Here is an easy way to put all the Pending Concurrent requests in hold, if we are going through any situation(Mostly any Production Cutover/Go live scenarios). 1. First create a backup table and [...]

Gather Schema Statistics fails with “ORA-20005: Object Statistics Are Locked (Stattype = ALL)” Log file shows the following error, ORACLE error 20005 in FDPSTP Cause: FDPSTP failed [...]

RMAN active duplicate fails with error: RMAN-03002: failure of Duplicate Db command at 09/25/2018 08:24:05 RMAN-05501: aborting duplication of target database RMAN-03015: error occurred in stored [...]

The Output Post Processor (FNDOPP) Manager is not starting, process status is shown as Actual with 0 and the Target is 1 The OPP logfile shows the following exceptions: [UNEXPECTED] [...]