SQL> select count(*),status from wf_notifications group by status; COUNT(*) STATUS ———- ——– 1530 CANCELED 1627 CLOSED 15266 OPEN SQL> select count(*),status, MAIL_STATUS from wf_notifications group by 2 status, MAIL_STATUS order by status; COUNT(*) STATUS…
Read MoreAlert Log File location: $ORACLE_HOME/admin/$CONTEXT_NAME/bdump/alert_$SID.log Trace file location: $ORACLE_HOME/admin/SID_Hostname/udump Application Tier Logs Start/Stop script log files location: $COMMON_TOP/admin/log/CONTEXT_NAME/ OPMN log file location $ORACLE_HOME/opmn/logs/ipm.log Apache, Jserv, JVM log files locations: $IAS_ORACLE_HOME/Apache/Apache/logs/ssl_engine_log…
Read MoreTo obtain the current patchset levels for each specific E-Business Suite functional product test the following steps: 1. Log into OAM. (Responsibility System Administrator,”Oracle Applications Manager”, menu “OAM Support Cart”)…
Read MoreIf an adop session is running and system crashes then it fails to update the status in the internal repository If we try to run it adop again it will…
Read MorePrepare phase failed due to GET_ACTIVE_CP_REQ_ID(c_req_id) error While running adop=prepare phase recieved error LOG FILE ———————– Filename =adop_20200822_140410.log See the following error: [EVENT] Submitting ADZDPATCH concurrent program. [PROCEDURE] [START 2020/08/22…
Read Morefs_clone failed :[UNEXPECTED]Error occurred running”perl/oradata/applmgr/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl When attempting to run FSclone, the following error occurs. Error can be seen in adop_<TIME_STAMP>.log: [UNEXPECTED]Error occurred running “perl <DIR>/<SID>/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/txkADOPPreparePhaseSynchronize.pl -contextfile=<DIR>/<SID>/fs1/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -patchcontextfile=<DIR>/<SID>/fs2/inst/apps/<CONTEXT_NAME>/appl/admin/<CONTEXT_NAME>.xml -promptmsg=hide -console=off…
Read MoreASMLIB is a storage management interface. ASMLIB is not required for ASM to function; it is like an add-on library that simplifies the tasks of managing and discovering the disks.…
Read MoreThe auditing mechanism for Oracle is extremely flexible. Oracle stores information that is relevant to auditing in its data dictionary. Every time when a user attempts anything in the database…
Read MoreBelow are some of the useful ASM commands which will be helpful all the time. ASMCMD > showversion ASMCMD > showversion –releasepatch –softwarepatch ASMCMD > showpatches ASMCMD > showclustermode ASMCMD…
Read MoreWhere I Faced this Issue? When I ran adcfgclone appsTier on EBS 12.2 I got this error, and it said got error while running autoconfig, but the actual error is…
Read More