|
This section details the various connection settings available for performing queries on an Oracle database server. First steps are common to all database queries and connection methods. They are described in the Analyzing a Database Query chapter.
Configuring a connection to a Oracle database server
| 1. | Define the Connection Settings to the Oracle database server: |
Oracle Database Server - Connection Settings
| ▪ | Database Name: Enter the name of the database. |
| ▪ | Oracle Port Number: Enter the port to be used to access the Oracle database. |
| ▪ | Username: Enter the username to use to connect to the database. |
| ▪ | Password: Enter the password associated with the specified username. |
 Connection Settings will be shared by all the queries defined within the Oracle Database Server Monitors.
| 2. | Define the SQL Query and Timeout properties |
Other Database Server - Query and Timeout Settings
| ▪ | SQL Query: Enter the SQL query you wish to perform. |
| ▪ | Timeout (seconds): Specify the time in seconds after which the query will be stopped (Default: 30 seconds). If the query times out, the Status attribute of the Studio Database Query Monitor Type will be set to 2 (Failed) and an alarm will be triggered in TrueSight Operations Management. |
| ▪ | Report Errors in Group's "CollectionErrorCount": Select this option to have the Collection Error Count attribute of the Group Monitor reflect possible alerts triggered upon the query execution. The Collection Error Count attribute of the Group reports on the collection errors of all Monitors, associated to the Group, for which this option is available and selected, providing a global view of the collection errors for the whole Group. |
| 3. | Define the Monitor Settings: |
| ▪ | Internal ID: Enter an ID to identify the managed Oracle database query instance in TrueSight Operations Management. |
| ▪ | Display Name: Enter a name to identify the managed Oracle database query instance in TrueSight Operations Management. |
| ▪ | Optional — Polling Interval: Set the frequency at which the data collection will be performed. Default is 2 minutes. |
| ▪ | Optional — Alert Actions: Define the action(s) Monitoring Studio needs to perform when the thresholds for this Oracle database query instance is breached. |
| 4. | Optional — Define the Content Processing rules you wish to apply to the Oracle database query output: |
| ▪ | String Searches: Define the search criteria for a specific string you wish to find or not find in the Oracle database query output. |
| ▪ | Numeric Extractions: Define any numeric value to be extracted from the Oracle database query output. |
| 5. | Click the Add to List button to complete the creation of the Oracle database query instance. |
| 
