To add to Rahul Priyadarshy, the Oracle Database Discovery has 1) Basic Oracle Database Discovery and two additional capabilities 2) Oracle Options and 3) Extend Oracle Instance Extension. Basic Oracle Database Discovery (#1) does not require new configurations, but Oracle Options (#2) and Extend Oracle Instance Extension (#3) requires additional configurations. All 3 capabilities are built into the into the Oracle DB On Windows Pattern and update tables/attributes as listed below.
1) Basic Oracle Database Discovery
Oracle Database Discovery is enabled by default when the Horizontal Discovery plugin is enabled. Oracle Database Discovery by default does NOT log into the Oracle Database. The sequence of steps for Oracle Database Discovery:
- ServiceNow Discovery discovers a Windows Server.
- During the Windows server discovery, the Windows - Application Dependency Mapping probe runs. An Oracle instance is detected, and oracle.exe is returned in the input payload of the Probe.
- The Oracle Instance Process Classifier (Discovery Definition->CI Classification->Processes) is launched based on finding the oracle.exe from step 2.
- The Oracle Instance Process Classifier launches the Oracle DB On Windows Pattern. The pattern creates a new entry in the Oracle Instances [cmdb_ci_db_ora_instance] table and CI Relationship [cmdb_rel_ci] table.
Note: In the Oracle DB On Windows pattern log, the first 4 sections are part of Basic Oracle Database Discovery. The sections Oracle option extension for windows and Extend Oracle Instance will not run without additional configurations and the following error shows in the logs: Applicative credentials for CI type cmdb_ci_db_ora_instance are not defined. Please go to the Credentials page to add the appropriate Applicative Credentials.
2) Oracle Options
The Oracle Options requires additional configurations to include: 1) creating a new credential in the Oracle Database with correct roles and table access and 2) adding the new credential to the ServiceNow Discovery credential table. The Oracle Options runs the script options_packs_usage_statistics.sql which logs into the Oracle Database. The data returned is populated in the Oracle Options [samp_oracle_options] table. The data in the Oracle Options table is utilized by the ServiceNow Software Asset Management Application.
Required configurations:
- In the Oracle database application, create a credential that has connect and owner_role roles. Add the read permission to the following tables and views: V_$INSTANCE, V_$DATABASE, V_$VERSION, GV_$PARAMETER, V_$CONTAINERS, CDB_FEATURE_USAGE_STATISTICS, and DBA_FEATURE_USAGE_STATISTICS.
- In the ServiceNow Discovery credentials table, add the credential from step 1 as an Applicative Credential (CI type: Oracle Instance [cmdb_ci_db_ora_instance]).
The sequence of steps for Oracle Options:
- The Basic Oracle Database Discovery (#1) runs as described in steps 1-4 above.
- With the added configurations, the Oracle DB On Windows Pattern executes the steps in the Oracle option extension for windows section. The data returned will be populated in the Oracle Options [samp_oracle_options] table.
Note: The Oracle option extension for windows will show green for a successful execution.
3) Extend Oracle Instance Extension
The Extend Oracle Instance Extension requires additional configurations to include: 1) creating a new credential in the Oracle Database with correct roles and table access, 2) adding the new credential to the ServiceNow Discovery credential table and 3) updating the Discovery and Service Mapping Patterns application. The steps in Extend Oracle Instance Extension logs into the Oracle Database. The data returned updates 6 attributes in the Oracle Instances [cmdb_ci_db_ora_instance] table.
Required configurations:
- In the Oracle database application, create a credential that has connect and owner_role roles. Add the read permission to the following tables and views: V_$INSTANCE and V_$DATABASE.
- In the ServiceNow Discovery credentials table, add the credential from step 1 as an Applicative Credential (CI type: Oracle Instance [cmdb_ci_db_ora_instance]).
- Upgrade the Discovery and Service Mapping Patterns application to version 1.0.72 or higher.
The sequence of steps for Extend Oracle Instance Extension:
- The Basic Oracle Database Discovery (#1) runs as described in steps 1-4 above.
- With the added configurations, the Oracle DB On Windows Pattern will now successfully execute the steps in the Extend Oracle Instance section. The data returned updates the following 6 attributes in the Oracle Instances [cmdb_ci_db_ora_instance] table: instance, host_name, cdb_yn, db_unique_name, database_name, and replication_enabled.
Note: The Extend Oracle Instance section will show green for a successful execution.
