Oracle 12c command line create PDB

1. Login CDB to create PDB

sqlplus / as sysdbacreate pluggable database pdb4admin user pdb4 identified by pdb4file_name_convert=(‘/u01/app/oracle/oradata/cdb/pdbseed‘,‘/u01/app/oracle/oradata/cdb/pdb4‘);

2. Concrete steps

<roidb01:cdb:/home/oracle> $sqlplus/as sysdbasql*plus:release 12.1.0.2.0 Production on Sat Jan 12:07:32 2018Cop  Yright (c) 1982, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit productionwith The partitioning, OLAP, Adva nced Analytics and Real application testing optionssql> show Con_namecon_name------------------------------cdb$ Rootsql> Create pluggable Database pdb4 2 Admin user pdb4 identified by PDB4 3 file_name_convert= ('/u01/app/oracle/ Oradata/cdb/pdbseed ', '/u01/app/oracle/oradata/cdb/pdb4 '); Pluggable database created. Sql> show PDBs con_id con_name OPEN MODE RESTRICTED----------------------------------------  --------------------2 pdb$seed Read only NO 3 PDB1 read         WRITE No 4 PDB2 Read Write No 5 PDB3 read Write No      6 PDB4                     Mountedsql> Alter pluggable database all open; Pluggable Database altered.<roidb01:cdb:/u01/app/oracle/oradata/cdb/pdb3> $sqlplus pdb4/[email   Protected]:1521/pdb4sql*plus:release 12.1.0.2.0 Production on Sat Jan 12:11:50 2018Copyright (c) 1982,, Oracle. All rights reserved. Connected to:oracle Database 12c Enterprise Edition Release 12.1.0.2.0-64bit productionwith The partitioning, OLAP, Adva nced Analytics and Real application testing optionssql> show Con_namecon_name------------------------------pdb4sql  >

Oracle 12c command line create PDB