Thank you for your feedback.
Form temporarily unavailable. Please try again or contact docfeedback@servicenow.com to submit your comments.
Versions
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store
Close

Oracle database discovery

Oracle database discovery

Discovery can identify an Oracle database instance that is running on UNIX or Windows operating systems.

UNIX operating system requirements

In the UNIX operating system

  • Discovery requires credentials that allow read permission to the oratab file.
  • Discovery requires credentials that allow read permission to the System Parameter file.
  • Discovery identifies a running instance of an Oracle database from the process that starts with ora_pmon_. Ensure this process is running in the IP range you designate.

Windows operating system requirements

In the Windows operating system

  • Discovery requires credentials that allow read permission to the System Parameter file.
  • Discovery identifies a running instance of an Oracle database from the oracle.exe process. Ensure this process is running in the IP range you designate.

UNIX operating system

The following data is collected by Discovery for an Oracle database instance running on the UNIX operating system.

Label Table name Field name Source
SID (UNIX) cmdb_ci_db_ora_instance sid Extracts SID from the name of the process that starts with ora_pmon_
Version cmdb_ci_db_ora_instance version Tries to extract the version in this order
  • From the output of the ORA_HOME/bin/sqlplus /NOLOG command
  • From the output of the ORA_HOME/bin/lsnrctl status command
  • From the path of ORA_HOME
Oracle Home cmdb_ci_db_ora_listener oracle_home From the ORATAB file
System Parameter File (SPfile) cmdb_ci_db_ora_instance spfile The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error.
  • oracle_home/dbs/spfileSID.ora
  • oracle_home/dbs/spfile.ora
  • oracle_home/dbs/initSID.ora

Windows operating system

The following data is collected by Discovery for an Oracle database instance running on the Windows operating system.

Label Table name Field name Source
SID (Windows) cmdb_ci_db_ora_instance sid Extracts SID from the process parameter that is passed to the oracle.exe process
Version cmdb_ci_db_ora_instance version From the output of the ORA_HOME/bin/sqlplus.exe -V command
Oracle Home cmdb_ci_db_ora_listener oracle_home Parsed from the path of oracle.exe
System Parameter File (SPfile) cmdb_ci_db_ora_instance spfile The following locations are explored for the location of the System Parameter File. If this file does not exist in one of the explored locations, Discovery does not find the file and reports an error.
  • oracle_home\database\spfileSID.ora
  • oracle_home\database\spfile.ora
  • oracle_home\database\initSID.ora