Discovery > Discovery Modules > Database > Oracle Database Server Discovery > Oracle Database Connection by SQL Job

Oracle Database Connection by SQL Job

This section includes details about the job.

ClosedAdapter

ID: Oracle Connection By SQL

ClosedTrigger TQL

  • Trigger query:

  • CI attribute conditions:

    CI

    Attribute Value
    IpAddress NOT IP Probe Name Is null
    IpServiceEndpoint

    IpServiceName Equal ignore case oracle

    OR ServiceNames Contains oracle
ClosedDiscovery Flow

This job performs the following actions:

  1. Gets the Oracle credentials that are specified in the Discover Probe configuration.
  2. Tries to connect using the specific credentials.

  3. If connection is successful, reports the Oracle Database with the connected credentials.

  4. If connection is successful, asks the database for it's primary IP and checks if this IP matches the one used for connection.

    If the primary IP does not match the one used for connection, the job checks if the database is in clustered mode.

  5. If the IP reported by the database is reachable from the probe and it is possible to connect to it, that IP is populated to the UCMDB. Otherwise, the IP used for initial connection is populated to the UCMDB.