Oracle Listener HD discovery

ServiceNow Discovery uses the Oracle Listener HD pattern to find and map Oracle real application cluster components. To discover these resources, install the CMDB CI Class Models and the Discovery and Service Mapping Patterns from the ServiceNow Store.

Oracle RAC enables you to cluster an Oracle database. Oracle RAC uses Oracle Clusterware for the infrastructure to bind multiple servers so they operate as a single system. Oracle Clusterware enables you to create a clustered pool of storage that can be used by any combination of non-cluster and Oracle RAC databases. Discovery uses Oracle Listener HD patterns to discover information about the Oracle Database Listener and the components in the Oracle RAC infrastructure, when such a setup is configured.

Request apps on the Store

Visit the ServiceNow Store to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Prerequisites

• Ensure that the following plugins are installed:
  • CMDB CI Class Models plugin (Version 1.29.0 or later). ​
  • Discovery and Service Mapping Patterns plugin (Version 1.0.82 or later).​
• Ensure that the Discovery User is in the Oracle DBA group or has the correct Permissions.
• Ensure that the MID Server has access to the target device.
• Ensure that the Oracle Clusterware/Grid infrastructure is installed and the Oracle RAC Database is configured. If there is an Oracle Clusterware setup.
• Ensure that the Oracle Listener process is running on a UNIX OS host.​
• Use Oracle Clusterware minimum version 12.2.X.X (Oracle Database 12c Release 2) or higher, If there is an Oracle Clusterware setup​.
  Remarque :

  This pattern is supported from the Paris release on. More UNIX OS types (AIX, Solaris, HP-UX) are supported from version 1.0.87 of the Discovery and Service Mapping Patterns plugins.

  The following commands are executed during the pattern execution. Executing the commands enables the pattern to populate allthe relevant CMDB classes with the necessary information:

  • export TNS_ADMIN=<oracle_home_directory>/network/admin: Sets the ORACLE_HOME to the TNS_ADMIN environment variable.

  • export ORACLE_BASE==<oracle_home_directory>: Sets the ORACLE_HOME to the ORACLE_BASE environment variable.

  • lsnrctl status LISTENER_NAME: Checks the Database Listener status​.

  • ps -ef | grep 'd.bin’: Searches for the GRID_HOME path​.

  • crsctl query cluster site -all: Lists the nodes and disks that the sites contain​.

  • lsnrctl services LISTENER_NAME: Lists the services that the listener identifies.

  • crsctl stat res -f -w '((TYPE = ora.database.type))’: Lists the database name, associated node, type, and active status.​

    Remarque :

    If no output is obtained from the lsnrctl status LISTENER_NAME, then the Oracle Listener HD pattern is terminated.

Limitations

The Oracle Clusterware setup is only supported for the UNIX Operating Systems. The base system SSH Command-Oracle - Listener Details classifier probe is inactive (Active is set to False), when installing the CMDB CI Class Models version 1.29.0 or higher.

Figure 1. Classifier Probes- Oracle Listener Details

The Oracle Listener process classification triggers the Oracle Listener HD pattern.

Figure 2. Classifier Probes- Horizontal Pattern

Data collected by Discovery during horizontal discovery

The Oracle Listener HD pattern populates the following CIs:

Tableau 1. Main CI (Oracle Database Listener) [cmdb_ci_db_ora_listener]

Field	Description
name	The name of the Oracle Database Listener.
oracle_home	The Oracle home directory where software is installed.
configuration	The listener.ora network configuration file.
scan_listener_name	The name of the SCAN LISTENER.
version	The version of the Oracle product.
tcp_port	The listening port for Oracle client connections.

Figure 3. Oracle Database Listener Form​

Figure 4. Oracle Database Listener View Map​

Tableau 2. (Oracle Instance) cmdb_ci_db_ora_instance

Field	Description
sid	The specific name that specifically identifies the instance.​
name	The name of the Oracle instance combination of SID@HOST_NAME​

Figure 5. Oracle Instance Form

Figure 5. Oracle Instance View Map

Tableau 3. (Oracle Database) cmdb_ci_oracle_database

Field	Description
name	The Oracle database unique name.
type	The Oracle database type.
operational_status	The active status of the Oracle database.
node	The host name of the node hosting the Oracle database.

Figure 7. Oracle Database Form

Figure 7. Oracle Database View Map

Tableau 4. (Oracle Cluster) cmdb_ci_oracle_cluster

Field	Description
name	The name of the Oracle database cluster.
cluster_id	The GUID of the Oracle database cluster.
cluster_status	The active state of the Oracle database cluster.
ip_address	The IP addresses of the nodes participating in the cluster.

​

Figure 9. Oracle Cluster Form

Figure 9. Oracle Cluster View Map

Tableau 5. (Oracle Cluster Node) cmdb_ci_oracle_cluster_node​

Field	Description
name	The hostname of the cluster node combination of HOSTNAME@CLUSTER_NAME.​
ip_address	The IP address of the cluster node, if resolvable by DNS.​
server	The hostname of the host hosting the cluster node.​
cluster	The name of the cluster to which the cluster node is associated.

Figure 11. Oracle Cluster Node Form​

Figure 12. Oracle Cluster Node View Map​

Tableau 6. (Linux Server) cmdb_ci_linux_server​

Field	Description
name	The hostname of the Linux server that is hosting the Oracle Listener process.

Figure 13. Linux Server Form

Figure 14. Linux Server View Map​

Tableau 7. (AIX Server) cmdb_ci_aix_server​

Field	Description
name	The hostname of the AIX server that is hosting the Oracle Listener process.

Tableau 8. (HPUX Server) cmdb_ci_hpux_server

Field	Description
name	The hostname of the HP-UX server that is hosting the Oracle Listener process.

Tableau 9. (Solaris Server) cmdb_ci_solaris_server

Field	Description
name	The hostname of the Solaris server that is hosting the Oracle Listener process.

Tableau 10. Oracle DB Service (cmdb_ci_db_ora_service)

Field	Description
name	The name of the service.
tcp_port	The port of the service.
listener_name	The name of the Listener managing the service.
version	The version of the service.

CI Relationships

Relationships created by the Oracle Listener HD Pattern

CI	Relationship	CI
cmdb_ci_oracle_cluster	“Cluster of :: Cluster”	cmdb_ci_oracle_cluster_node
cmdb_ci_oracle_cluster_node	“Hosted on :: Hosts”	cmdb_ci_linux_server
cmdb_ci_db_ora_instance	“Runs on :: Runs”	cmdb_ci_linux_server
cmdb_ci_db_ora_listener	“Depends on :: Used by”	cmdb_ci_db_ora_instance
cmdb_ci_db_ora_instance	“Uses :: Used by”	cmdb_ci_db_oracle_database​
cmdb_ci_oracle_database	"Hosted on :: Hosts”	cmdb_ci_oracle_cluster_node
cmdb_ci_oracle_cluster_node	“Hosted on :: Hosts”	cmdb_ci_aix_server
cmdb_ci_db_ora_instance	Runs on :: Runs”	cmdb_ci_aix_server
cmdb_ci_oracle_cluster_node	“Hosted on :: Hosts”	cmdb_ci_solaris_server
cmdb_ci_db_ora_instance	Runs on :: Runs”	cmdb_ci_solaris_server
cmdb_ci_oracle_cluster_node	“Hosted on :: Hosts”	cmdb_ci_hpux_server
cmdb_ci_db_ora_instance	Runs on :: Runs”	cmdb_ci_hpux_server
cmdb_ci_db_ora_service	Managed by::Manages	cmdb_ci_db_ora_listener
cmdb_ci_db_ora_instance	Uses::Used by	cmdb_ci_db_ora_service