How to check if a database is configured with Oracle Multitenant Architecture

Check whether the database uses Oracle Multitenant Architecture; it is a simple operation. You can check this feature by querying the v$database using the CDB field as in the SQL example below:

 

SQL> select cdb from v$database;
 
CDB
---
YES

 
Additionally, in case your database is a multitenant database, you can visualize it by using the following query:
 


[oracle@techdata ~]$ . oraenv
ORACLE_SID = [oracle] ? cdb1
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@techdata ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 19.0.0.0.0 - Production on Thu Nov 4 16:13:41 2021
Version 19.3.0.0.0

Copyright (c) 1982, 2019, Oracle.  All rights reserved.


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> COLUMN NAME FORMAT A15
COLUMN RESTRICTED FORMAT A10
COLUMN OPEN_TIME FORMAT A30

SELECT NAME, OPEN_MODE, RESTRICTED, OPEN_TIME FROM gV$PDBS;

NAME            OPEN_MODE  RESTRICTED OPEN_TIME
--------------- ---------- ---------- ------------------------------
PDB$SEED        READ ONLY  NO         2021-10-26 13:55:39,004 +02:00
TECHDB          READ WRITE NO         2021-10-26 13:55:43,725 +02:00
TECHDBX         READ WRITE NO         2021-10-26 14:38:36,388 +02:00
TECHDBO         READ WRITE NO         2021-10-26 13:55:43,290 +02:00
TECHDBA         READ WRITE NO         2021-10-26 13:55:44,569 +02:00

 
Published: 08/11/2018
Updated: 12/04/2023

Related posts

Leave a Comment