Create Pluggable Database (PDB) in 12c using SQL Plus

You can create new PDB in your 12c container database with Sql Plus. It will use the SEED PDB as template to create the new PDB.
Here are the steps.

1. Login to the container database with SYSDBA Privilege.

2. Run the "CREATE PLUGGABLE DATABASE" command to create the PDB.
Please remember that, the above command will use Oracle Managed Files (OMF) structure by default to create the datafiles. (If file location is not specified in the CREATE command).

So, if db_create_file_dest parameter is not set and you have not specified any other option for file location, you will get the below error. (Because, db_create_file_dest parameter defines the OMF for data files).

3. To fix the issue, you can either set the db_create_file_dest parameter or provide other option (such as FILE_NAME_CONVERT) for file location.

4. Use the "CREATE PLUGGABLE DATABASE" command to create the new PDB. The PDB will be created in MOUNT mode. You can then open the PDB in READ WRITE mode to complete the integration of the new PDB into the CDB.

This completed the creation of PDB. As per your organisation process, you can register the new PDB in OUD (LDAP) and OEM (For monitoring) etc.

That's all !!