Skip to content

Container database creation in 19c

You need to download oracle 19c software and setup software installation. After installation, you can able to create a container database with have a pdb.

C:\Users\mazar>set ORACLE_SID=oradb

C:\Users\mazar>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 – Production on Sun Nov 1 15:55:13 2020
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> SELECT NAME, CDB, CON_ID FROM V$DATABASE;

NAME CDB CON_ID


ORADB YES 0

SQL> select pdb_name from dba_pdbs;

PDB_NAME

ORAPDB
PDB$SEED

No comments yet

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

%d bloggers like this: