query to check ORA errors
This query is used to check the ORA error in past one hour. query: COLUMN ORIGINATING_TIMESTAMP FORMAT A40 COLUMN message_text FORMAT A100 set linesize 300 SELECT ORIGINATING_TIMESTAMP , message_text FROM…
Read Morescript to copy and import schema backup from prod to uat
This script is useful to import monthly backup of specific schema from prod to uat after taking necessary schema backup in uat. In prod every month the schema is exported…
Read Moreoracle ebs r12.1.1 installation on oracle cloud
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 Morescript to monitor apps and db listener running on single node
This 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 Morescript to alert mount point space status without mail alert
This 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 Morescript to get concurrent request outfiles for list of concurrent request id.
This 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 MoreOracle Ebs R12.1 Post Install Check Error
This 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 MoreORA-01578, ORA-01110 index table block corruption
One 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 Moregetting ebs R12.2 web logic url from os level
This 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 MoreFetching particular concurrent request out file remotely
This 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 More