Performing a Query on an Oracle Database Server

 Home  Previous  Next

This section details the various connection settings available for performing queries on Oracle database server.

To configure a connection to a Oracle database server

1.In the PATROL Console, right-click the Host or Monitor Group icon and select KM Commands > New > Monitor...
2.Select Database Query: Oracle Database Server from the drop-down list and click Next.

Analyzing_Database_Query_Oracle_1

Performing a Query on an Oracle Database Server - Oracle Database Server Connection Information

3.Define the Connection Information to the Oracle database server:
▪Database name: Enter the name of the database.
▪Port number: Enter the port to be used to access the Oracle database (Default: port 1521).

NoteThese settings apply to all Oracle Database Server connections defined for the host.

4.Click Next.

Analyzing_Database_Query_Oracle_2

Performing a Query on an Oracle Database Server - Oracle Database Server Query Information

5.Define the Query Information to the Oracle database server:
▪Credentials: Select the type of credentials that you want to use:
•System Credentials (default): Uses the credentials previously specified when creating the Host.
•Add new credentials...: Lets you set new specific credentials.
•SQL Query: Enter the SQL query you wish to perform.
•Timeout: Specify the time in seconds after which the query will be stopped (Default: 30 seconds). If the query times out, the Status parameter will be set to 2 (Failed) and an alarm will be triggered.
•Report execution errors in Group's CollectionErrorCount: Select this option to have the CollectionErrorCount parameter of the Group reflect possible alerts triggered upon the query execution. The CollectionErrorCount parameter of the Group reports on the collection errors of any Monitor associated to the group, for which this option is available and selected, providing a global view of the collection errors for the whole Group.
6.Click Next.
7.Configure the Monitor settings.
8.Click Finish. The corresponding Database Query instance (Database Query: <Display Name>) is created in the PATROL Console. The collected parameters for Database Query Monitors are listed in the SEN_MS_DBQUERY chapter.