Oracle Instance Status Test
This test monitors each instance of an Oracle server, and reports whether that instance is available or not. If a user complaints of an Oracle server being inaccessible, you can use this test to determine whether the server itself is down or only the target instance is down.
This test is disabled by default. To enable the test, go to the enable / disable tests page using the menu sequence : Agents -> Tests -> Enable/Disable, pick Oracle Database as the Component type, Performance as the Test type, choose this test from the disabled tests list, and click on the << button to move the test to the ENABLED TESTS list. Finally, click the Update button.
Note:
-
For this test to report metrics for an Oracle database server that is executing on Unix platforms, the eG installed user that is executing the sqlplus command to collect the required metrics should be within the Oracle group. To add the eG installed user say for e.g., tim, you should use the following command:
usermod -a -G <Oracle_Group> <eG_User>
Example:
usermod -a -G Oracle_Group tim
-
To make sure that this test reports metrics for an Oracle database server configured with multiple instances, you need to insert the following entry in the listener.ora file of each instance.
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=orcl.us.acme.com)
(ORACLE_HOME=/oracle10g)
(SID_NAME=orcl))
Target of the test : An Oracle database server
Agent deploying the test : An internal agent
Outputs of the test : One set of results for each instance of an Oracle server
|
Measurement | Description | Measurement Unit | Interpretation | ||||||
---|---|---|---|---|---|---|---|---|---|
Oracle Instance availability: |
This measure indicates whether this instance is available or not. |
Percent |
The value 100 denotes that the instance is available, and the value 0 indicates that the instance is unavailable. The detailed diagnosis of this measure displays information about successful connectivity attempts and error messages reported when the Oracle instances are unavailable. Use the detailed diagnosis of this measure to know number of successful and failed attempts |
||||||
Uptime: |
Indicates how long the instance has been up and running. |
Seconds |
|
||||||
Uptime since last measure: |
Indicates the duration for which the instance has been up since the last measurement period. |
Seconds |
If the value of this measure is lesser than the test frequency, it indicates that the instance was rebooted during the last measurement period. |
||||||
Is rebooted? |
Indicates whether this instance was rebooted or not. |
|
This measure reports the value Yes if the instance was rebooted in the last measurement period, and the value No if it was not rebooted. The numeric values that correspond to these measure values have been listed in the table below:
Note: This test reports the Measure Values listed in the table above to indicate whether/not the instance was rebooted. In the graph of this measure however, the same will be represented using the numeric equivalents. |