How To Create Pluggable Database In Oracle 12c

• Kiran Dalvi
• 12 Jan, 2020
• 0 Comments
• 1 Min Read

How To Create Pluggable Database In Oracle 12c

Create Pluggable database in Oracle 12c

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

 

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49

[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

Now Connect to Sqlplus utility, check pdbs.

 

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20

[oracle@node1 bin]$ sqlplus / as sysdba   SQL*Plus: Release 12.2.0.1.0 Production on Wed Nov 2 17:08:10 2022   Copyright (c) 1982, 2016, Oracle.  All rights reserved.     Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production   SQL> SQL> SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDBPRIM                        READ WRITE NO          4 PDB1                           READ WRITE NO SQL>