How to Discover Oracle Database Servers by SQL

This task describes how to discover Oracle database servers by SQL. This discovery adds a valid credentials ID to the CMDB. You can then use this CI to fully discover the database.

This task includes the following steps:

1. Prerequisite - Set up protocol credentials

   Oracle Database Connection by SQL discovery uses the Generic DB Protocol (SQL).

   For credential information, see Supported Protocols.

2. Prerequisite - Verify user on Oracle database server

   Run the Databases TCP Ports job to verify the port used by the Oracle Database Server.

3. Run the discovery

   Activate the following jobs in the listed order:

   1. Databases TCP Ports

   2. Oracle Database Connection by SQL

   3. Oracle Topology by SQL or Oracle Topology by SQL - Service Name

      Note Due to the large amount of data reported by the Oracle Topology by SQL job, topology data is sent in chunks. Chunk size (the number of objects in a chunk) is regulated by the discoverReportPageSize job parameter. The default value is 1,000 objects in one chunk.

   For details on running jobs, see "Module/Job-Based Discovery" in the Data Flow Management section of the UCMDB Help.