Detect symbolic link directories in Oracle
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…
Read MoreUsing INCLUDE & EXCLUDE parameters together in Data Pump – Oracle 21c
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…
Read MoreView Output/Log returns “Authentication Failed/File server could not identify source file ” error Concurrent Program – R12.1.3
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…
Read MoreHow to Generate AWR snaps for Multitenant Database at CDB and PDB level
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…
Read MoreActive EBS users and their respective responsibilities in Oracle E-Business Suite
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…
Read MoreIdentify versions of components in EBS
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…
Read MoreHold Pending Concurrent Requests and release them
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…
Read MoreGather Schema Statistics fails with ORA-20005
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 due to ORA-20005:…
Read MoreRMAN Active Duplicate Fails with ORA-19837 ORA-19849 ORA-19850
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 script Memory Script ORA-19849:…
Read MoreOutput Post Processor (FNDOPP) is not Staring
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] java.sql.SQLException:…
Read More