Description: In Oracle EBS Instance, recently I have faced the error as lsinventory session failed while try to run ./opatch lsinventory in our Instance.OPatch wasn’t able to find the database [...]

IF YOU DON’T KNOW CURRENT PASSWORD ———————————– If you forget your administrative password and cannot start the [...]

Description: Delete the Secondary application Node from Application Tier, follow the below steps. Note: This steps are ONLY for deletion of secondary application tier nodes. The primary [...]

Declaration : In this scripts using for schedule statspack report generation for hourly, frequently and purge weekly snapshots. Statspack is instead of AWR because AWR report is licensed.   [...]

Description: This script is used for finding ASM error details on ASM disk. script: select io.inst_id , dg.name diskgroup_name , io.disk_number , d.name disk_name –, d.label , d.read_errs , [...]

Description: This query belongs to find the top sort segment usage on oracle. Script: col sid format 999999 col spid format a6 col tablespace format a10 col username format a25 col noexts format [...]

Description: This query used to find and calculate the top 20 tables by growth for users requested days. Script: select * from (select so.owner, so.object_name, –so.subobject_name, [...]

Description : This script is used to find total number of database startup in the year or month. You can schedule the script in crontab for every month. Script : #!/bin/sh date location=`find / [...]

Description: This Shell script is very useful to calculate and review total no of database shutdown in the year or month. We can schedule the script to crontab for every month. Script: #!/bin/sh [...]

Description: Once we completed clone successfully after that we run the Autoconfig its completed with error. error code (AC-50480: Internal error occurred) Cause :  The issue can occur if the [...]