Data collected by Discovery on Oracle databases

Discovery identifies and classifies information about Oracle databases.

UNIX operating system

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

Table 1. Data collected by Discovery on an UNIX Oracle database
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.

Table 2. Data collected by Discovery on a Windows Oracle database
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