Oracle Database 12c discovery

The ServiceNow Discovery application can discover pluggable databases (PDBs) and container databases (CDBs), which are features of Oracle Database 12c. Discovering some of these resources may require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.

A PDB is a portable collection of schemas, schema objects, and non-schema objects that appear to an Oracle Net client as a separate database. A collection of PDBs is called a container database (CDB).

For more information about PDBs and CDBs, see What are CDBs, PDBs and Containers?

Request apps on the Store

Visit the ServiceNow Store to view all the available apps, and for information about submitting requests to the store. For cumulative release notes information for all released apps, see the ServiceNow Store version history release notes.

Prerequisites

Set the user credentials and grant permissions:

• Configure Applicative credentials.
• For Windows, configure Windows credentials
• For Unix, configure SSH credentials
• For the Oracle database, configure Oracle database discovery
• Provide a user with permissions to run queries on the following tables:
  • V$DATAFILE
  • V$TEMPFILE​
  • V$LOG
  • DBA_FREE_SPACE
  • V$DATABASE
  • V$PDBS
  • V$PARAMETER

Remarque :

Set applicative credentials at the CDB level to discover relationships for PDBs and the CDB size only. Alternatively, set applicative credentials at the CDB/PDB level to discover relationships for PDBs and the CDB/PDB size. If you do not set applicative credentials at the CDB level, no PDB attributes are discovered.

Data collected during Discovery

Discovery collects the following data:

Table and field	Description
cmdb_ci_db_ora_pdb_instance: Relation Type : Managed By​​
sid	Name of the PDB instance​​
name	Name of the CI in CMDB. This is a combination of sid and the hostname​.
version	Version of the PDB as taken from the CDB instance​​
edition	Edition of the PDB as taken from the CDB instance​​
install_directory	Install directory of the PDB as taken from the CDB instance
oracle_home​	Oracle home of the PDB as taken from the CDB instance
cdb_name	Name of the cdb sid that contains the PDB. This refers to the Oracle database instance configuration item (CI​)
cmdb_ci_db_instance_size: Relation Type : Contained By​​
sid	Name of the Oracle database CDB/PDB instance​​
name	Name of the CI in CMDB. This is a combination of the sid and the hostname.
db_size	Total size allocated to the database instance
used_size	Size used by the database instance
free_size	Size of the free space on the database instance

The following is a dependency view of the relationship between PDBs, CDBs, and containers.