Oracle Monitoring

About Oracle Monitoring

Oracle monitor allows you to monitor Oracle RDBMS health status. It connects to the Oracle database and executes the query provided in the monitor’s settings.

The monitor can be used by Oracle DB administrators for checking database connection state and some critical data availability.

Note: for most types of Application monitoring (see Application Monitoring), you need to have Smart Agent downloaded, installed and running on your machine to configure the monitoring (see Downloading Smart Agent for Linux and Windows).

Please note that Oracle monitor is supported starting from 4.01.30 version on Windows agent and 4.01.36 version on Linux agent.

Oracle monitor can be configured for both Windows and Linux Smart Agents. As a prerequisite, you need to have JAVA installed on the machine where Smart Agent is running.

Oracle monitor provides 3 metrics:

  • Execution time – time it took to execute the query
  • Query Result – the query result string
  • Status – the monitoring check result, OK or NOK

There can be 2 different scenarios for the monitoring check results:

1. Connection was successful and the query returned some results. In this case the output will be:

a. Query execution time in ms

b. Query result string ((max 50 symbols) constructed as follows: {column1_1:value1_1, column2_1:value2_1};{column1_2:value1_2, column2_2:value2_2};…

c. Status equals OK

2. An error occurred while connecting to the database or executing the query. In this case the output will be:

a. Detailed error message

b. Status equals NOK

 

Adding Oracle Monitor

Adding Oracle Monitor for Windows

Go to the Monitors menu and select Application Monitors->Oracle.

Monitor_List

The Add Application Monitor – Step 1 window will open.

Add_Oracle_Windows_

If you have already downloaded and installed Smart Agent for Windows, select it from the Agent list.

Make sure that your Smart Agent for Windows is running, as shown under Agent Status. If the Agent is stopped, run it from Smart Agent Controller window (see Downloading, Installing and Running Smart Agent for Windows).

Agent_Key.png

If you haven’t downloaded Smart Agent for Windows yet, click on the Download Agent button to download it. Follow the instructions under Downloading, Installing and Running Smart Agent for Windows.

Note that it may take up to 5 min for newly installed Agent to appear in the agent list (you can click Refresh to refresh the agent list).

Select the Windows Agent from the list, and click Next.

The Add Application Monitor – Step 2 window will open.

Add Oracle Application Monitor – Step 2

Select from the Monitor Group combo box the monitor group for this monitor to be assigned to.

You can also create a new monitor group by clicking on the “+” icon next to Add a new Group.

Under Host enter the address of your server hosting the Oracle DB.

Enter the Port.

Enter the SID (Oracle System Identifier), and Username and Password if required.

In the Query box enter the query to be executed. Note that only SELECT queries are supported.

You can also run a test here to check the database availability, your provided credentials and the query.

Click Test to run the test. Wait a little, as the test takes about 1 min to complete.

Test Oracle Monitor Activity

If the test is completed successfully, you will see the test results right here in the wizard window.

Oracle Activity Test Complete

If there was a failure establishing connection, you will see an error message on the screen:

Oracle Activity Test Failed

To add more Application monitors of different types to the same Smart Agent, click the green “+” button under Add More Monitors (see Adding Multiple Server-Device and Application Monitors for the Same Agent).

Add More Application Monitors

Click Add when finished.

The Alert Configuration window will appear.

http://www.monitis.com/support/wp-content/uploads/2016/09/word-image-91.png

  • Click Send to All Contacts if you want to send alerts for this monitor to all contacts.
  • Click Custom Configuration (Advanced) to configure sending alerts for this monitor only to selected contacts.The Alert Rules window will open. Click on the Add Alert Rule button to configure alert rule(s) for your monitor.

New Alert Rule

Set up the alert rule and click Add Rule. See Alert Rules in Alerts 2.0 for more info about alert rules.

Note: To be able to add alert rules, you need to set up thresholds (Critical or Warning) in your monitor first.

A threshold includes two conditions connected by a logical OR. If any of the conditions matches the monitor will enter your specified state.

  • Check fails (response timed out, connection failure, etc)
  • Any or all of your selected metrics meet the failure conditions you specified for them

ORACLE-1.png

ORACLE-2.png

See Thresholds for more info.

  • Click Don’t Send Alerts if you don’t want any alerts for this monitor to be sent.

Your newly created application monitor will appear in your Monitis dashboard. Wait until it loads the first results.

Oracle Monitor Windows Results

 

Adding Oracle Monitor for Linux

Go to the Monitors menu and select Application Monitors->Oracle.

Add Oracle for Linux

The Add Application Monitor – Step 1 window will open.

Add Oracle for Linux - Step 1

If you have already downloaded and installed Smart Agent for Linux, select it from the Agent list.

Make sure that your Smart Agent for Linux is running, as shown under Agent Status. If the Agent is stopped, run it on your Linux machine (see Downloading, Installing and Running Smart Agent for Linux).

Status Monitoring Smart Agent

If you haven’t downloaded Smart Agent for Linux yet, click on the Download Agent button to download it. Follow the instructions under Downloading, Installing and Running Smart Agent for Linux. Note that it may take up to 5 min for newly installed Agent to appear in the list (you can click Refresh to refresh the agent list).

Select the Linux Agent from the list, and click Next.

The Add Application Monitor – Step 2 window will open.

Add Oracle for Linux - Step 2

Select from the Monitor Group combo box the monitor group for this monitor to be assigned to.

You can also create a new monitor group by clicking on the “+” icon next to Add a new Group.

Under Host enter the address of your server hosting the Oracle DB.

Enter the Port.

Enter the SID (Oracle System Identifier), and Username and Password if required.

In the Query box enter the query to be executed. Note that only SELECT queries are supported.

You can also run a test here to check the database availability, your provided credentials and the query.

Click Test to run the test. Wait a little, as the test takes about 1 min to complete.

Oracle Linux Activity Test

If the test is completed successfully, you will see the test results right here in the wizard window.

Oracle Linux Activity Test Complete

If there was a failure establishing connection, you will see an error message on the screen:

Oracle Linux Activity Test Failed

To add more Application monitors of different types to the same Smart Agent, click the green “+” button under Add More Monitors (see Adding Multiple Server-Device and Application Monitors for the Same Agent).

Adding Multiple Oracle Monitors

Click Add when finished.

The Alert Configuration window will appear.

http://www.monitis.com/support/wp-content/uploads/2016/09/word-image-104.png

  • Click Send to All Contacts if you want to send alerts for this monitor to all contacts.
  • Click Custom Configuration (Advanced) to configure sending alerts for this monitor only to selected contacts.The Alert Rules window will open. Click on the Add Alert Rule button to configure alert rule(s) for your monitor.

New Alert Rule

Set up the alert rule and click Add Rule. See Alert Rules in Alerts 2.0 for more info about alert rules.

Note: To be able to add alert rules, you need to set up thresholds (Critical or Warning) in your monitor first.

A threshold includes two conditions connected by a logical OR. If any of the conditions matches the monitor will enter your specified state.

  • Check fails (response timed out, connection failure, etc)
  • Any or all of your selected metrics meet the failure conditions you specified for them

C:\Users\monitis_user\Desktop\ORACLE-1.png
C:\Users\monitis_user\Desktop\ORACLE-2.png

See Thresholds for more info.

  • Click Don’t Send Alerts if you don’t want any alerts for this monitor to be sent.

Your newly created application monitor will appear in your Monitis dashboard. Wait until it loads the first results.

Oracle_Monitor_Data_

 

Settings

You can use the Settings menu to change at any time Oracle monitor setup data: e.g. provide a new host, user credentials or query to execute.

http://www.monitis.com/support/wp-content/uploads/2016/09/word-image-109.png

 

Viewing Oracle Monitor Data

You can view Oracle monitor in a Chart or Table view.

Oracle_Monitor_Data_

Oracel_Monitor_Data_Table_View_

If the status is NOK, an error message will be shown in the Query Result field.