| \n\nCredential type\n\n | \n\nAdditional information\n\n |
|---|---|
| \n\n[Applicative credentials](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/applicative-creds.md)\n\n | \n\nApplicative credentials are mandatory for two use cases:\n\n- Executing SQL queries against the remote Oracle DB Instance\n- Creating connections to database links\n- Software Asset Management activated\n\nYou must add the database user you configured during Oracle database installation. Specify `Oracle instance [cmdb_ci_db_ora_instance]` as the CI type. The user must also have access to the **tnsnames.ora** parameters file. Make sure that the tnsnames.ora is configured correctly and exists in the Oracle path on the target Windows host. Also, verify that the utilized Discovery Credentials can read tnsnames.ora file.\n\nThe user needs permissions for the SQL\\*Plus command line tool and permissions to execute SELECT queries against the following tables:\n\n- PRODUCT\\_COMPONENT\\_VERSION\n- V$VERSION\n- V$DATABASE\n- V$PARAMETER\n\n |
| \n\n[Oracle Wallet authentication](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/discovery-and-service-mapping-patterns/oracle-wallet-authentication.md)\n\n | \n\nYou can use Oracle Wallet instead of applicative credentials.\n\n |
| \n\n[Windows credentials](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/r_WindowsCredentialsForm.md)\n\n | \n\nRequired for Windows targets. The user must have read permissions to the `tnsnames.ora` file.For a list of privileged commands that you need for Discovery and Service Mapping, see [Service Mapping commands requiring a privileged user](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/service-mapping/r_CommandsnCredentials.md). This list includes commands that require elevated rights to discover and map Unix-based hosts in your organization.\n\n |
| \n\n[SSH credentials](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/platform-security/r_SSHCredentialsForm.md)\n\n | \n\nRequired for UNIX targets. The user must have read permission to the `oratab` file and read permission to the System Parameter file.For a list of privileged commands that you need for Discovery and Service Mapping, see [Service Mapping commands requiring a privileged user](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/service-mapping/r_CommandsnCredentials.md). This list includes commands that require elevated rights to discover and map Unix-based hosts in your organization.\n\n |
| \n\nCommand\n\n | \n\nDescription\n\n |
|---|---|
| \n\n`ps -ef | grep 'crsd.bin' |grep -v grep`\n\n | \n\nVerifies if Oracle CRS process is running.\n\n |
| \n\n`ps -ef |grep LISTENER | grep -v $$ | head -1 | awk '{print $8}'`\n\n | \n\nGets Oracle home from the listener process path. Used when the ORACLE\\_HOME environment variable is unavailable.\n\n |
| \n\n`ps -ef | grep 'd.bin' | grep -v grep | grep -v bash | awk '{print $8}'`\n\n | \n\nGets Oracle Grid home from the CRS daemon process path.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/olsnodes -c | egrep -v 'error|return code'`\n\n | \n\nGets Oracle CRS cluster name.\n\n |
| \n\n`sudo /u01/app/12.1.0.2/grid/bin/ocrcheck | egrep -v 'error|return code'`\n\n | \n\nGets Oracle CRS cluster ID.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/crsctl query crs softwareversion| egrep -v 'error|return code'`\n\n | \n\nGets Oracle CRS version.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/olsnodes | egrep -v 'error|return code'`\n\n | \n\nGets Oracle CRS nodes.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/crsctl status server | egrep -v 'error|return code'`\n\n | \n\nGets Oracle CRS node status.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/crsctl stat res -f | tr '\\n' '#'`\n\n | \n\nGets Oracle CRS resources.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/crsctl stat res -p | grep -v CHECK_R |grep -v error |grep -v failed`\n\n | \n\nGets Oracle CRS VIP resources.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/srvctl config scan | tr '\\n' ‘ '`\n\n | \n\nGets Oracle RAC SCAN VIP configurations.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/srvctl config vip -node ol7-121-rac1| egrep ' Name' | awk '{print $3}'`\n\n | \n\nGets Oracle CRS VIPs name.\n\n |
| \n\n`/u01/app/12.1.0.2/grid/bin/srvctl config vip -node ol7-121-rac1| grep ' IPv4 Address:' | awk '{print $4}'`\n\n | \n\nGet Oracle CRS VIPs ip\\_address.\n\n |
| \n\nClassifier\n\n | \n\nTrigger probes\n\n | \n\nPattern\n\n |
|---|---|---|
| \n\nOracle Instance\n\n | \n\n- Horizontal discovery probe: launches patterns\n- Powershell-Oracle - Instance PFile \\(for Windows\\)**\\***\n- Powershell-Oracle - Instance Version \\(for Windows\\)**\\***\n- SSHCommand-Oracle - Instance Details \\(for Linux\\)**\\***\n\n | \n\nApplication patterns:\n\n- Oracle DB On Windows Pattern\n- Oracle DB on UNIX Pattern\n\n This shared library pattern used by the [Linux Server](https://raw.githubusercontent.com/ServiceNow/ServiceNowDocs/australia/markdown/australia/it-operations-management/itom-visibility/r_DataCollDiscoLinuxComputers.md) pattern:\n\n UNIX Cluster - ORACLE Clusterware\n\n**Note:** This shared library pattern is triggered if the `crsd.bin` process is running on the Oracle database server.\n\n |
| \n\nOracle Listener\n\n | \n\nSSHCommand-Oracle - Listener Details\n\n | \n\nnone\n\n |
| \n\nLabel\n\n | \n\nField name\n\n | \n\nAdditional information\n\n |
|---|---|---|
| \n\nSID\n\n | \n\nsid\n\n | \n\nObtained from the name of the process that starts with `ora_pmon_`\n\n |
| \n\nInstall directory\n\n | \n\ninstall\\_directory\n\n | \n\nObtained from the path of `ORA_HOME`\n\n |
| \n\nVersion\n\n | \n\nversion\n\n | \n\nObtained in this order:- From the output of the `ORA_HOME/bin/sqlplus /NOLOG` command\n- From the output of the `ORA_HOME/bin/lsnrctl` status command\n- From the path of `ORA_HOME`\n\n |
| \n\nParameter file\n\n | \n\npfile\n\n | \n\nThe 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/spfile*SID*.ora\n- *oracle\\_home*/dbs/spfile.ora\n- *oracle\\_home*/dbs/init*SID*.ora\n\n |
| \n\nOracle Home\n\n | \n\noracle\\_home\n\n | \n\nObtained from the *ORATAB* file.\n\n |
| \n\nEdition\n\n | \n\nedition\n\n | \n\nObtained from the `context.xml` file.\n\n |
| \n\nName\n\n | \n\nname\n\n | \n\nCombination of SID name Host name in the format `SID@HOST_NAME`.\n\n |
| \n\nTCP port\\(s\\)\n\n | \n\ntcp\\_port\n\n | \n\nObtained from the `tnsnames.ora` file, or `lsnrctl` status command. If no valid information is retrieved, the default port 1521 is assigned.\n\n |
| \n\nLabel\n\n | \n\nField name\n\n | \n\nAdditional information\n\n |
|---|---|---|
| \n\nSID\n\n | \n\nsid\n\n | \n\nObtained from the process parameter that is passed to the `oracle.exe` process.\n\n |
| \n\nInstall directory\n\n | \n\ninstall\\_directory\n\n | \n\n \n\n |
| \n\nVersion\n\n | \n\nversion\n\n | \n\nObtained from the output of the `ORA_HOME/bin/sqlplus.exe -V` command.\n\n |
| \n\nParameter file\n\n | \n\npfile\n\n | \n\nThe 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\\\\spfile*SID*.ora\n- *oracle\\_home*\\\\database\\\\spfile.ora\n- *oracle\\_home*\\\\database\\\\init*SID*.ora\n\n |
| \n\nOracle Home\n\n | \n\noracle\\_home\n\n | \n\nParsed from the path of `oracle.exe`\n\n |
| \n\nEdition\n\n | \n\nedition\n\n | \n\n \n\n |
| \n\nTable privileges needed\n\n | \n\nAdditional information\n\n |
|---|---|
| \n\nThe following tables are accessed as part of the Oracle option extension for UNIX and Windows:- DBA\\_FEATURE\\_USAGE\\_STATISTICS\n- CDB\\_FEATURE\\_USAGE\\_STATISTICS\n- V$DATABASE\n- V$VERSION\n- GV$PARAMETER\n- V$CONTAINERS\n- V$INSTANCE\n\n | \n\nThe following pattern extensions use the Oracle script: options\\_packs\\_usage\\_statistics.sql. This sql script is for DB Server version 11.2 and later. You need the **Select any dictionary** privilege to execute the script. See the support document ID13172651.1 on [https://support.oracle.com/portal/](https://support.oracle.com/portal/) for more information about usage scripts. - Oracle option extensions for UNIX\n- Oracle option extensions for Windows\n\n |
| \n\nTable\n\n | \n\nLabels and field names\n\n |
|---|---|
| \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n | \n\nName \\[name\\]\n\n Cluster status \\[cluster\\_status\\]\n\n Cluster type \\[cluster\\_type\\]\n\n IP address \\[ip\\_address\\]\n\n Short description \\[short\\_description\\]\n\n Cluster ID \\[cluster\\_id\\]\n\n Cluster version \\[cluster\\_version\\]\n\n |
| \n\ncmdb\\_ci\\_unix\\_cluster\\_node\n\n | \n\nName \\[name\\]\n\n Node state \\[node\\_state\\]\n\n IP address \\[ip\\_address\\]\n\n Node status \\[node\\_status\\]\n\n |
| \n\ncmdb\\_ci\\_unix\\_cluster\\_resource\n\n | \n\nName \\[name\\]\n\n Resource type \\[resource\\_type\\]\n\n Resource status \\[resource\\_status\\]\n\n Properties \\[properties\\]\n\n |
| \n\ncmdb\\_ci\\_cluster\\_vip\n\n | \n\nName \\[name\\]\n\n IP address \\[ip\\_address\\]\n\n Cluster name \\[cluster\\_name\\]\n\n Cluster ID \\[cluster\\_id\\]\n\n |
| \n\nTable privileges needed\n\n | \n\nAdditional information\n\n |
|---|---|
| \n\nThe following tables are accessed as part of the Extend Oracle Instance extension for UNIX and Windows:- V$DATABASE\n- V$INSTANCE\n\n | \n\nThe Extend Oracle Instance extension needs to be installed. This extension is included in the Discovery and Service Mapping Patterns application, version 1.0.72 or higher, which can be downloaded from the ServiceNow Store.\n\n |
| \n\nCI\n\n | \n\nRelationship\n\n | \n\nCI\n\n |
|---|---|---|
| \n\nOracle instance\n\n | \n\nHosted on\n\n | \n\nComputer \\[cmdb\\_ci\\_computer\\] or Server \\[cmdb\\_ci\\_server\\]**Note:** This is a virtual machine. The **Is virtual** field is **true**.\n\n |
| \n\nComputer \\[cmdb\\_ci\\_computer\\] or Server \\[cmdb\\_ci\\_server\\]**Note:** This is a virtual machine. The **Is virtual** field is **true**.\n\n | \n\nVirtualized by\n\n | \n\nComputer \\[cmdb\\_ci\\_computer\\] or Server \\[cmdb\\_ci\\_server\\]**Note:** This is not a virtual machine.\n\n |
| \n\nBase class\n\n | \n\nRelationship\n\n | \n\nDependent class\n\n |
|---|---|---|
| \n\nOracle instance\n\n | \n\nHosted on\n\n | \n\nComputer \\[cmdb\\_ci\\_computer\\]**Note:** This is a virtual machine. The **Is virtual** field is **true**.\n\n |
| \n\nComputer \\[cmdb\\_ci\\_computer\\]**Note:** This is a virtual machine. The **Is virtual** field is **true**.\n\n | \n\nVirtualized by\n\n | \n\nComputer \\[cmdb\\_ci\\_computer\\]**Note:** This is not a virtual machine.\n\n |
| \n\nComputer \\[cmdb\\_ci\\_computer\\]**Note:** This is a virtual machine. The **Is virtual** field is **true**.\n\n | \n\nVirtualized by\n\n | \n\nVirtual Machine Instance \\[cmdb\\_ci\\_vm\\_instance\\]**Note:** The vCPU count is populated in this table.\n\n |
| \n\nVirtual Machine Instance \\[cmdb\\_ci\\_vm\\_instance\\]\n\n | \n\nHosted on\n\n | \n\nAWS Datacenter \\[cmdb\\_ci\\_aws\\_datacenter\\] or Azure Datacenter \\[cmdb\\_ci\\_azure\\_datacenter\\]\n\n |
| \n\nCI\n\n | \n\nRelationship\n\n | \n\nCI\n\n |
|---|---|---|
| \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n | \n\nVirtualizes::Virtualized by\n\n | \n\nCluster Virtual IP \\[cmdb\\_ci\\_cluster\\_vip\\]\n\n |
| \n\nUnix Cluster Resource \\[cmdb\\_ci\\_unix\\_cluster\\_resource\\]\n\n | \n\nDefines resources for::Gets resources from\n\n | \n\nUnix Cluster Node \\[cmdb\\_ci\\_unix\\_cluster\\_node\\]\n\n |
| \n\nCluster Virtual IP \\[cmdb\\_ci\\_cluster\\_vip\\]\n\n | \n\nUses::Used by\n\n | \n\nUnix Cluster Node \\[cmdb\\_ci\\_unix\\_cluster\\_node\\]\n\n |
| \n\nUnix Cluster Node \\[cmdb\\_ci\\_unix\\_cluster\\_node\\]\n\n | \n\nCluster of::Cluster\n\n | \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n |
| \n\nUnix Cluster Node \\[cmdb\\_ci\\_unix\\_cluster\\_node\\]\n\n | \n\nHosted on:Hosts\n\n | \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n |
| \n\nUnix Cluster Resource \\[cmdb\\_ci\\_unix\\_cluster\\_resource\\]\n\n | \n\nDefines resources for::Gets resources from\n\n | \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n |
| \n\nUnix Cluster \\[cmdb\\_ci\\_unix\\_cluster\\]\n\n | \n\nHosts::Hosted on\n\n | \n\nLinux Server \\[cmdb\\_ci\\_linux\\_server\\]\n\n |
| \n\nUnix Cluster Node \\[cmdb\\_ci\\_unix\\_cluster\\_node\\]\n\n | \n\nHosted on::Hosts\n\n | \n\nLinux Server \\[cmdb\\_ci\\_linux\\_server\\]\n\n |