Question: How to get PDB Datafile information when PDB in different Mode? Case 1 – PDB in mounted Mode PDB Status: SQL> select pdb_id, pdb_name, con_uid,status from dba_pdbs; PDB_ID PDB_NAME CON_UID STATUS ———- ————– ———- ————- 3 [PDB12C] 515133920 NORMAL 2 PDB$SEED 4105546291 NORMAL SQL> select con_id, name, open_mode, restricted from v$pdbs; CON_ID NAME OPEN_MODE […]
Oracle 18c
Oracle Multitenant: How to Create CDB and PDB
Creating a CDB The steps required to create a new CDB, using either DBCA or SQL*Plus, are the same. The first step, as for any database, non-CDB or CDB, consists of configuring an instance with an init.ora parameter file and then starting the instance. The second step is the creation of the CDB using the […]
Beginners Guide to Oracle Database 18c Multitenant Architecture
Challenges Starting with Oracle Database 12c, the multitenant architecture enables you to have many pluggable databases inside a single Oracle Database instance. What is the benefit of using the multitenant architecture in Oracle Database 18c? Currently, many Oracle customers have large numbers of “departmental” applications built on Oracle RDBMS. These applications rarely use a significant […]