how Oracle Databases (cmdb_ci_oracle_database) is discovered ?

[Jose Santos Alv]

When I run a quick discovery on a Linux server,  the server got created/updated, then an Oracle Instance (cmdb_ci_db_ora_instance) is created under the same server, and I know this is thanks to the Oracle On Unix Pattern. But then, how the oracle database (cmdb_ci_oracle_database) is created under the Oracle Instance ? which pattern is responsible for that ? This is something I want to understand because these are being created with a specific format name and without assignment group. 

[Ratnakar7 · Accepted solution]

Hi @Jose Santos Alv ,

In ServiceNow, the discovery of Oracle databases (cmdb_ci_oracle_database) is typically done through patterns that are part of the Oracle Database application. Specifically, the Oracle Database pattern creates cmdb_ci_oracle_database records as part of the discovery process.

Here's a simplified overview of how the discovery process works:

1. Server Discovery:

   • When you run a discovery on a Linux server, the Discovery application uses various patterns to identify and update information about the server. This includes the creation or update of the cmdb_ci_computer record for the server.

2. Oracle On Unix Pattern:

   • The Oracle On Unix Pattern is used to discover Oracle instances running on Unix-based servers. This pattern identifies Oracle instances and creates or updates cmdb_ci_db_ora_instance records associated with the server.

3. Oracle Database Application:

   • The Oracle Database application in ServiceNow contains patterns specifically designed to discover and manage Oracle databases. One of these patterns is responsible for creating cmdb_ci_oracle_database records.

4. Discovery Process:

   • During the discovery process, the Oracle Database pattern may gather information about the Oracle databases on the server, including details such as the database name, version, and other relevant attributes.

5. cmdb_ci_oracle_database Records:

   • Based on the information collected, the Oracle Database pattern creates or updates cmdb_ci_oracle_database records associated with the Oracle instance.

Regarding the specific format name and the absence of an assignment group, this is likely determined by the configuration and customization in your instance:

• Format Name: The format of the names of discovered records is often configurable in the Discovery application. Check the Oracle Database application settings and the specific Oracle patterns for any configuration related to naming conventions.

• Assignment Group: The assignment group for discovered records is typically set based on the configuration in your instance. Check the Oracle patterns, specifically the cmdb_ci_db_ora_instance and cmdb_ci_oracle_database patterns, for any assignment group configuration.

Thanks,

Ratnakar

[Jose Santos Alv]

is Oracle Database Application the name of the pattern where the name for these are set ?

[Ratnakar7]

Hi @Jose Santos Alv ,

When it comes to Oracle databases, there isn't a single pattern called "Oracle Database Application" in the standard ServiceNow Discovery library. Instead, there are multiple patterns related to Oracle databases, and their names might vary depending on the version of ServiceNow or the specific updates that have been applied.

Patterns for Oracle databases are generally named to reflect the nature of the CI they are discovering. Some common patterns related to Oracle databases might include:

• Database - Oracle
• Database - Oracle RAC
• Database - Oracle Application
• Database - Oracle RDBMS

These are just examples, and the actual names may vary. It's essential to check the ServiceNow documentation or your specific ServiceNow instance to determine the exact patterns available.

Thanks,

Ratnakar