Monitoring Oracle e-Business Suite (R12.2)

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