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

For Discoverer 10g: 1. On the Discoverer 10g Server machine, please set the environment variables by running the following script, . ./$OH/discoverer/discwb.sh (Note : It is dot space dot slash [...]

One small article on ASMCMD commands which can help you in day to day ASM Command-Line tasks. 1. Let’s check ASMCMD’s version. [oracle@dbnode1 ~]$ asmcmd -V asmcmd version 11.2.0.0.0 Let’s enter [...]