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…
Read MoreIF YOU DON’T KNOW CURRENT PASSWORD ———————————– If you forget your administrative password and cannot start the server, the following procedure works for the default authenticator Note: This is not…
Read MoreDescription: 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 application tier node…
Read MoreDeclaration : 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. Script:…
Read MoreDescription: 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 , d.write_errs…
Read MoreDescription: 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…
Read MoreDescription: 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, so.object_type, so.tablespace_name, round(sum(ss.space_used_delta)/1024/1024) growth_mb…
Read MoreDescription : 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 :…
Read MoreDescription: 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…
Read MoreDescription: 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…
Read More