Oracle 12c Pluggable Database Creation Method 1: using command line

How to Create Oracle Pluggable database

Method 1: Create new PDB from PDB$SEED pluggable database using command line.

Environment Details:

OS: Sun Solaris 5.10

Database Version: 12C

User: oracle

CDB Database Name: CDB1

Root Database Name: CDB$ROOT

Seed Database Name: PDB$SEED (Template database, always in READ ONLY Mode)

PDB Database Name: PDB1

1. Connect to the root database with the user having "CREATE PLUGGABLE DATABASE" system privilege. In this case we have used SYS user.

2. Issue the below to create the pluggable database in the container database.

CREATE PLUGGABLE DATABASE pdb1

ADMIN USER pdbadmin IDENTIFIED BY pdbadmin1 ROLES=(CONNECT)

FILE_NAME_CONVERT =  ('/u01/oradata/ora12c/pdbseed','/u01/oradata/ora12c/pdb1');

3. When the pluggable database is created it is in MOUNTED Mode, we need to OPEN the database to use it.

ALTER PLUGGABLE DATABASE pdb1 OPEN;