People ask what do I look for when monitoring an EBS instance for availability? Oracle Enterprise Manager (OEM) with the Applications Management Pack (AMS) gives a good starting point, but here is a condensed list of my general health check items for my production instance. It’s not everything possible, but it’s what I generally would check during a shake-down of a disaster-recovery exercise.
Warning | Critical | ||||
Oracle E-Business Suite | |||||
Oracle Applications Infrastructure Service | |||||
Database Instance | select SYSDATE from dual; | Up/Down | |||
Tablespace Freespace Available | >80% | >90% | |||
Temporary Tablespace Used | >80% | >90% | |||
Undo Tablespace Used | >80% | >90% | |||
Fast Recovery Area Utilization | >80% | >90% | |||
Redo Log Switch Rate | > 10/hr. | >20/hr | |||
Blocking Sessions | >1 | >5 | |||
Database Listener | tnsping <ORACLE_SID> | Up/Down | |||
TNSPing Response Time | > 25ms | > 100ms | |||
Applications Listener | tnsping <FNDFS_ORACLE_SID> | Up/Down | |||
Host Monitoring | |||||
CPU Utilization | > 80% | > 95% | |||
RAM Utilization | > 90% | > 99% | |||
Mountpoint Free Space Available | <10% | <5% | |||
Concurrent Processing Services | |||||
Internal Manager | Up/Down | ||||
Standard Manager | < 10 | ||||
Output Post Processor | < 3 | ||||
Receiving Transactions Manager | < 1 | ||||
Document Approval Manager | < 1 | ||||
Forms Applications Service | |||||
Forms Listener Service | Up/Down | ||||
Forms Runtime Processes | <1 | ||||
Forms Response Time | >5 secs | >30 secs | |||
Active Forms Sessions | > 100 | > 200 | |||
Self-Service Applications Service | |||||
HTTP Listener Service | Up/Down | ||||
OPMN Processor | Up/Down | ||||
OC4J Service | Up/Down | ||||
WebLogic Deployed Services | Up/Down | ||||
WebLogic AdminServer | Up/Down | ||||
OA Framework Page Response Time | > 5 secs | > 10 secs | |||
Oracle Applications JVM Usage | >80% | >90% | |||
Workflow Serivce | OAM Dashboard | Up/Down | |||
Workflow Agent Listener | Up/Down | ||||
Workflow Background Engine | Up/Down | ||||
Workflow Notification Mailer Services | Up/Down | ||||
Oracle E-Business Suite Custom Objects | |||||
Invalid Object Count | > 482 | > 500 | |||
Oracle E-Business Suite Patch Information | |||||
Patch Inventory | |||||
ADOP Session Status | >1 Pending | >1 Failed |
Hi Jhului
Thanks for your post…
I am planning to Configure AMP 13c on EM 13c for EBS R12.2.5.
Could you please some step by step document for the same?
Thanks
Venkatesh RK
Getting Started with Oracle Application Management Pack (AMP) for Oracle E-Business Suite Release 13.1.1.1.0 (Doc ID 2045552.1)
https://support.oracle.com/epmos/faces/DocContentDisplay?id=2045552.1
Hi Jhului,
are you monitoring above tasks using any script? or just doing manual everyday?
Thanks,
Jagadeesh