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 MoreOne of the index table FND_CONCURRENT_REQUESTS_N9’s block is corrupted. Causes of issue: Abnormal server down Steps to solve this issue: 1.Find table name of corrupted block SELECT k.owner, k.segment_type, k.segment_name,…
Read MoreThis os level command used to get the oracle EBS R12.2 web logic url. echo “http://”$(cat $CONTEXT_FILE | grep s_webhost | cut -d ‘>’ -f2 | cut -d ‘<‘ -f1)”.”$(cat…
Read MoreThis script fetch & transfer the specific concurrent request log file to remote location. $ vi Connout.sh cat /dev/null > /usr/tmp/ftp.log cat /dev/null > /usr/tmp/ftp1.log echo “Enter Concurrent program Request…
Read MoreIn this steps we can find any user name’s password in oracle apps. STEP 1: login to Database through Command Prompt #sqlplus / as sysdba STEP 2 : Create Function…
Read MoreA snapshot controlfile is a read consistent copy of a database controlfile which RMAN creates because the controlfile is changed constantly. The snapshot controlfile must be on a location shared…
Read More