How to Create Pluggable database Manually-Oracle 12C administration

• Kiran Dalvi
• 10 Jun, 2019
• 0 Comments
• 1 Min Read

How to Create Pluggable database Manually-Oracle 12C administration

Follow the below steps to create pluggable database manually: 

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 50 51 52 53 54 55 56 57 58

[oracle@prim ~]$ sqlplus / as sysdba SQL*Plus: Release 19.0.0.0.0 - Production on Wed Oct 11 14:46:12 2023 Version 19.3.0.0.0 Copyright (c) 1982, 2019, Oracle.  All rights reserved. Connected to an idle instance. SQL> SQL> SQL> startup ORACLE instance started.   Total System Global Area 1744828000 bytes Fixed Size                  9135712 bytes Variable Size             452984832 bytes Database Buffers         1275068416 bytes Redo Buffers                7639040 bytes Database mounted. Database opened. SQL> SQL> SQL> SQL> SQL> select name, open_mode from v$database;   NAME      OPEN_MODE --------- -------------------- TESTDB    READ WRITE SQL> SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDBDB                          MOUNTED          4 ABC                            MOUNTED SQL> SQL> SQL> create pluggable database pdb1 admin user testuser identified by "testuser" default tablespace users datafile '/data/app/oracle/oradata/TESTDB/users02.dbf' size 10M AUTOEXTEND ON FILE_NAME_CONVERT=('/data/app/oracle/oradata/TESTDB/pdbseed','/data/app/oracle/oradata/TESTDB/PDB1');   SQL>   2    3    4    5   Pluggable database created. SQL> show pdbs;       CON_ID CON_NAME                       OPEN MODE  RESTRICTED ---------- ------------------------------ ---------- ----------          2 PDB$SEED                       READ ONLY  NO          3 PDBDB                          MOUNTED          4 ABC                            MOUNTED          5 PDB1                           MOUNTED SQL> SQL> SQL> alter pluggable database pdb1 open; Pluggable database altered. SQL> SQL>

Hope it Helps!