How to Create Pluggable database Manually-Oracle 12C administration

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarKiran 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: 



[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!