OracleDB

Introduction

Oracle Database is a multi-model database management system produced and marketed by Oracle Corporation.

It is a database commonly used for running online transaction processing (OLTP), data warehousing (DW) and mixed (OLTP and DW) database workloads.

Prerequisites

• Requires Gateway 7.0.0 and above.

• Add SSH credentials on target device (For which user has permissions to execute lsnrctl services  and srvctl commands).

Discovery using the Agent

Collector Type: Agent

Category: Application Monitors

Application Name: oracledb

Global Template Name: DB-Oracle DotNet v4

Parameters

Note: All field attributes are mandatory, use default values wherever applicable.

Collected Metrics

Prerequisites

• Database and port(1521) can be accessed by the gateway.
• A gateway management profile mapped to a resource.
• Create credentials with type Database before assigning a template to a resource. The Port, Connection Time-out, and Is Secure values are not used to create credentials.

Database discovery and monitoring

The administrator can deploy an agent or gateway to support OracleDB agent-based or agentless monitoring.

Discovery using the Gateway

The gateway establishes a connection to the database using the Java Database Connectivity (JDBC) Java API and collects metrics using SQL queries. To monitor an OracleDB, install gateway version 5.0.0 or later.

Use one of the following mechanisms to discover OracleDB servers to add them to your inventory:

• WMI
• SSH
• SNMP

Optionally, add a database server manually to the infrastructure inventory:

1. Select Infrastructure and click Resources.
2. Click the Settings icon on the top-right and click Add.
3. On the Add Device page, enter the Device Type and any other information you want to enter.
4. Click Save.

Prepare the device to start monitoring

1. Associate appropriate database credentials to the discovered database.
2. Assign one or more database-specific global monitors or templates on the device.
   Optionally, create custom metrics or monitors using SQL queries and assign them to the database.

To track monitoring of OracleDB database in your cloud environment, see Monitoring Cloud Database using Gateway.

Create custom metrics

To create a metric using SQL query for OracleDB monitoring, navigate to Monitoring > Metrics > Create Metric. For example, to create a metric to check the DB instance use:

SELECT INSTANCE_NAME, DATABASE_STATUS FROM V$INSTANCE

For more information, see Create a Metric.

Assign templates from setup

Assign OracleDB templates to one or more resources for a selected client and change the configuration parameters while assigning templates. For more information, see Assign Templates from Setup.

Assign templates at the device level

Applying Oracle templates at the device level helps assign one or more templates to a specific resource. You can change the configuration parameter default values while assigning the templates. For more information, see Assign Templates at the Device Level.

Template configuration parameters

Assign template from device management policies

Device management policies help manage resources. You can assign monitoring templates, knowledge base articles, and custom attributes using device management policies. The device management policy can be applied to one or a set of resources. For more information, see Create Policies.

View resource metrics

The gateway monitors the application using the assigned templates and displays the results in graphical format. To view resource metrics, click the database resource name > resource Details > Metrics.

Troubleshooting

If you have OracleDB monitoring issues, verify gateway, telnet, and database connectivity:

ping <IP Address>
telnet <IP Address> <Port>
gcli
db <Database Type> <IP Address> <User Name> <Password> <Port> <Database Name> <Connect Timeout> <ReadTimeout> <Secure Flag> <Query>

Beginning with gateway version 5.3.0, use the following format for the latest , including the result-set:

db <Database Type> <IP Address> <User Name> <Password> <Port> <Database Name> <Connect Timeout> <Read Timeout> <Secure Flag> <ResultSet?: Yes/No> <Query>

Supported templates

Supported metrics

Refer to the Oracle Cloud (OCI) for more information about Oracle Cloud.