Oracle Apps DBA Monitoring Shell Scripts
Being an Oracle DBA/APPS DBA, key task is Oracle Database Monitoring and Oracle E Business Suite application system monitoring.
We can prevent most of the issues by setting up alert monitoring.
Below are the Oracle DBA Scripts for monitoring which can be deployed/scheduled in crontab/OEM
as per requirement.These scripts will send the notification over mail in html
format which is well formatted and easy to read. Scripts are generic and easy to deploy with minimal time.
I hope this will help you to enable your Oracle Database Performance monitoring and Oracle E business suite monitoring :)
Oracle Database Monitoring Scripts:
- Script to Monitor Current Database Size and its Growth Since Last Run
- Script To Monitor Database Alert Log For Any "ORA-" Errors
- Script To Monitor Database Tablespace Usage
- Script To Monitor Oracle Database Sessions Consuming High TEMP Tablespace
- Script to Monitor Temporary (TEMP) Tablespace Usage
- Script to Monitor Database Status or Availability
- Script to Monitor Database Listener
- Script To Monitor Database Locks
Oracle EBS Application Monitoring Scripts:
- Script To Check Workflow Mailer Service Components Status and Send Notification if DOWN
- Script To Monitor "Gather Schema Statistics" Concurrent Request
- Script to Monitor Long Running Concurrent Requests
- Script to Monitor All Concurrent Managers
- Script to Monitor Output Post Processor (OPP) Concurrent Manager
- Script to Monitor Cost Manager and other Inventory Interface Managers
Operating System (OS) Monitoring Scripts:
Miscellaneous Oracle Database / EBS Application Related SQL Scripts:
Great post.
ReplyDeleteIf possible can you please upload some more useful Monitoring Scripts.
Thanks
Sure. If you have any suggestions then let me know, I will create the scripts accordingly.
DeleteThis comment has been removed by the author.
DeleteThanks Kiran!
DeleteHow can we create consolidated health check scripts for db,apps and fmw in R12 Environment?
How can we get the total report in Unique HTML Format?
Please let me know your suggestions. Thank You
My Mail id: sentprasath@gmail.com
DeleteCan you please give the steps for creating any shell script like how to get 90% filled tablespace details
ReplyDeleteHi Kiran- Could you please help to provide the script for form runaway session.
ReplyDeleteHi Kiran- Could you please help to provide the script for form runaway session.
ReplyDeleteCool.. It includes almost all the Oracle monitoring scripts. Thanks for sharing.
ReplyDeleteHi I am unable to download the scripts, it says below error.
ReplyDeleteThis site can’t be reachedh2hdba.blogspot.in’s server IP address could not be found.
Try running Windows Network Diagnostics.
DNS_PROBE_FINISHED_NXDOMAIN
Regard's
Vinod Kumar
This has been fixed now.
DeleteThere were broken links, Thanks for letting me know.
Deep Learning Projects assist final year students with improving your applied Deep Learning skills rapidly while allowing you to investigate an intriguing point. Furthermore, you can include Deep Learning projects for final year into your portfolio, making it simpler to get a vocation, discover cool profession openings,
ReplyDeleteOracle Apps DBA Training in Bangalore