ORACLE EBS 12.1.1 INSTALLATION STEPS:1 Login into the cloud Create Instance Main menuàcomputeà instanceàcreate instance Give name to the instance Choose availability domain Choose hardware and software for instance Choose…
Read MoreThis script is useful to frequently monitor db and apps listener status running on single node. Run this script in crontab to frequently monitor db&app listener status. #!/bin/bash rm DB.log…
Read MoreThis script is used to check the mount points space status without mail alert. Save the mount points name in mn.log file before running this script. #!/bin/bash rm mn1.log rm…
Read MoreThis script is useful when the dev Team asks larger number of concurrent request outfiles frequently. Before running this script copy the required concurrent request id to conrequestid.txt file. To…
Read MoreThis error occurred when we install Oracle EBS R12.1 on oracle cloud. CAUSES OF ISSUE The http port number and instance public ip is blocked by the vcn network. There…
Read MoreSQL> 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 More