Oracle Database 12c discovery
Summarize
Summary of Oracle Database 12c discovery
The ServiceNow Discovery application supports the discovery of Oracle Database 12c features, specifically pluggable databases (PDBs) and container databases (CDBs). To utilize these features effectively, customers may need to update the Discovery and Service Mapping Patterns application from the ServiceNow Store. PDBs are collections of database objects that function as separate databases within a CDB.
Show less
Key Features
- Discovery of PDBs and CDBs, enabling comprehensive database management.
- Requirements for user credentials and permissions configuration, including:
- Applicative credentials for CDB/PDB discovery.
- Windows and Unix credentials setup for database access.
- Permissions to query specific Oracle database tables.
- Data collection includes detailed information about PDB instances and CDB sizes, such as:
- Instance names and versions.
- Installation directories and Oracle home paths.
- Database size metrics (allocated, used, and free space).
Key Outcomes
By configuring the necessary credentials and permissions, ServiceNow customers can successfully discover and manage Oracle Database 12c environments, including detailed insights into PDBs and CDBs. This enhanced visibility helps in optimizing database performance and resource allocation.
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 requires updating 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 website 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
- 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
Data collected during Discovery
| 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.