How To Create Pluggable Database In Oracle 12c

In this blog, We will see How  to create the pluggable database in oracle 12c.

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 16:46:10 2022

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

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area 1912602624 bytes
Fixed Size                  8794168 bytes
Variable Size            1191186376 bytes
Database Buffers          704643072 bytes
Redo Buffers                7979008 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> select name , open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
PRIM      READ WRITE

SQL>
SQL>
SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBPRIM                        MOUNTED
SQL>
SQL>
SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         3 PDBPRIM                        READ WRITE NO
SQL>
[oracle@node1 ~]$ cd $ORACLE_HOME/bin
[oracle@node1 bin]$ ./dbca