---
sourceDocument: Brazil IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/it-operations-management

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Oracle PDBs and CDBs

# Oracle pluggable database and container database discovery {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read
Summarize  
![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI  
This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.  

## Summary of Oracle pluggable database and container database discovery

The ServiceNow Discovery application enables the identification and mapping of Oracle pluggable databases (PDBs) and container databases (CDBs) within your IT environment.
PDBs represent portable collections of schemas and objects appearing as separate databases to Oracle clients, while a CDB is a container holding multiple PDBs.
This capability may require updating to the latest Discovery and Service Mapping Patterns application from the ServiceNow Store to ensure compatibility and comprehensive discovery.
Show full answer Show less  

## Prerequisites

To effectively discover Oracle PDBs and CDBs, you must configure appropriate credentials and permissions:

* Set applicative credentials or Oracle Wallet authentication for the databases.
* Configure Windows credentials if discovering on Windows platforms.
* Configure SSH credentials for Unix systems.
* Grant database user permissions to query key Oracle tables such as V$DATAFILE, V$TEMPFILE, V$LOG, DBAFREESPACE, V$DATABASE, V$PDBS, and V$PARAMETER.
* Apply applicative credentials at the CDB level to discover relationships and size metrics for PDBs and the CDB. Alternatively, apply credentials at both CDB/PDB levels for detailed discovery.
* Note that without applicative credentials at the CDB level, PDB attributes will not be discovered.

## Data Collected During Discovery

The discovery process collects detailed information about Oracle PDB and CDB instances, including:

* **cmdbcidborapdbinstance:** Captures PDB instance details such as instance name (SID), combined CI name, version, edition, install directory, Oracle home, and associated CDB name.
* **cmdbcidbinstancesize:** Captures size-related metrics for both CDB and PDB instances, including total allocated size, used size, and free space.

The discovery results establish relationships between PDBs, CDBs, and their containers, supporting accurate configuration management and dependency mapping within the CMDB.

## Practical Benefits for ServiceNow Customers

* Enables comprehensive visibility and management of Oracle database architectures, including multi-tenant environments.
* Supports accurate CMDB population with detailed Oracle database instance attributes and sizes.
* Facilitates impact analysis and dependency mapping for Oracle databases through discovered relationships.
* Improves operational efficiency by ensuring discovery aligns with Oracle's architecture and credential requirements.  
The ServiceNow Discovery application can discover Oracle pluggable databases (PDBs) and container databases (CDBs). Discovering some of these resources might 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?](http://www.oracle-wiki.net/premium:startdocsminimulticdbs)

## Request apps on the Store {#oracle-cdb-pdb-discovery__section_gvb_cql_rlb}

Visit the [ServiceNow Store](https://store.servicenow.com/sn_appstore_store.do#!/store/home) 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](https://www.servicenow.com/docs/r/store-release-notes/sn-store-release-notes.html).{#oracle-cdb-pdb-discovery__inline-send-to-store}

## Prerequisites {#oracle-cdb-pdb-discovery__section_s3d_tkh_w3b}

Set the user credentials and grant permissions:

* Configure [Applicative credentials](https://www.servicenow.com/docs/access?context=applicative-creds&version=brazil&pubname=brazil-platform-security&ft:locale=en-US) or [Oracle Wallet authentication](https://www.servicenow.com/docs/ET3J8KFXdB~Njl~0usZFkg "With Oracle Wallet authentication, Discovery reads database credentials directly from the target server. This approach keeps credentials within the target environment instead of storing them on the ServiceNow AI Platform.")
* For Windows, configure [Windows credentials](https://www.servicenow.com/docs/access?context=r_WindowsCredentialsForm&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
* For Unix, configure [SSH credentials](https://www.servicenow.com/docs/access?context=r_SSHCredentialsForm&version=brazil&pubname=brazil-platform-security&ft:locale=en-US)
* For the Oracle database, configure [Oracle database discovery](https://www.servicenow.com/docs/_O~KPd3Wg3maW68e17ByUg "Discovery can identify an Oracle database instance that is running on UNIX or Windows operating systems. It can also find Oracle clusterware, which runs Real Application Clusters (RAC).")
* 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
  {#oracle-cdb-pdb-discovery__ul_os2_hgv_w3b}
{#oracle-cdb-pdb-discovery__ul_c4h_mcj_hkb}  
Note:  
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 {#oracle-cdb-pdb-discovery__section_uhs_zf5_w3b}

Discovery collects the following data:{#oracle-cdb-pdb-discovery__table_ktj_ph5_w3b__entry__2}

| 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 |
[ ]

{#oracle-cdb-pdb-discovery__table_ktj_ph5_w3b} The following is a dependency view of the relationship between PDBs, CDBs, and
containers.
**Related reference**   

* [Oracle Catalog discovery](https://www.servicenow.com/docs/vL_s0dsFu~bI_T11EbUDjg "The Discovery and Service Mapping Patterns application uses the Get Catalog info pattern extension of the Oracle DB on Unix and Oracle DB on Windows patterns to find Oracle Catalog objects. Discovering some of these resources might require updating to the latest version of the Discovery and Service Mapping Patterns application from the ServiceNow Store.")
* [Oracle GLAS data collection using patterns](https://www.servicenow.com/docs/A593Ssdlt_aniZdQGyCfMw "The ServiceNow Discovery application uses the Oracle GLAS Data Collection pattern extensions to discover Oracle GLAS data. This data includes discovered Oracle Database, Middleware, and Java configuration items.")