script to backup application home based on mount point space
This script is used to take backup of oracle application home in specific mount point. First it will check the size of apps home and calculate the mount point future…
Read Morequery 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 MoreOracle Database 19c Patch Release Update – Jan 2021(Patch Id – 32218454)
DESCRIPTION This article we are going to see steps to apply the latest Oracle 19c Database Release Update Patch 32218454 DOWNLOAD THE PATCH FROM ORACLE SUPPORT CHECK THE CURRENT OPTACH…
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 MoreAutconfig Takes a Very Long Time To Run “adupdlobs.pl”
When running autoconfig during adcfgclone.pl the adupdlobs.pl taken more than 30 min but it not completed. Also please use the below script to validate. SELECT pctversion FROM dba_lobs WHERE table_name=’FND_LOBS’…
Read MoreApproval Limit change extract for any Job/Assignment change
This sql query will be useful to extract the approval limits that are changed for any employee’s job/assignments supervisor change SQL Query SELECT pbg.name business_group_name, papf.employee_number, papf.person_id, cur.effective_start_date new_assignment_effective_date, papf.attribute30…
Read MoreRequisition to Invoice Payment Status extract query
This sql query will help to get the payment status of the requisition , PO , Invoice and its payment status SELECT DISTINCT prh.segment1 req_number, prh.authorization_status req_status ph.segment1 po_number ai.invoice_num,…
Read More