Crear un PDB en modo silent, puede ser una alternativa muy útil, sobretodo en circunstancias en las que, por seguridad no te permiten tener el entorno grafico X11 u otro habilitado.

–Seteamos variables de entorno:
[oracle@fcrac05 ~]$ env | grep ORA
ORACLE_SID=CDBMOV1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/12.2.0/dbhome_1

–Nos logeamos al Container database y vemos los PDBs disponibles:
[oracle@fcrac05 ~]$ !sqlp
sqlplus ‘/as sysdba’
SQL*Plus: Release 12.2.0.1.0 Production on Tue Apr 24 22:32:41 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 – 64bit Production

SQL> show pdbs

CON_ID CON_NAME  OPEN MODE    RESTRICTED
———– ——————–  ———————– ———-
2              PDB$SEED   READ ONLY       NO
3              SMWDB       READ WRITE     NO
4              ZTELBS        READ WRITE     NO

–Creamos el nuevo Pluggable Database:
[oracle@fcrac05 ~]$ dbca -silent -createPluggableDatabase -sourceDB CDBMOV -pdbName GMCDB -pdbAdminPassword “Claro2018$”
Creating Pluggable Database
2% complete
6% complete
11% complete
20% complete
46% complete
Completing Pluggable Database Creation
53% complete
Executing Post Configuration Actions
100% complete

Look at the log file “/u01/app/oracle/cfgtoollogs/dbca/CDBMOV/GMCDB/CDBMOV.log” for further details.

–Revisamos el log de creación:
[oracle@fcrac05 ~]$ tail -50 /u01/app/oracle/cfgtoollogs/dbca/CDBMOV/GMCDB/CDBMOV.log
[ 2018-04-24 22:39:10.196 PET ] Creating Pluggable Database
DBCA_PROGRESS : 2%
DBCA_PROGRESS : 6%
DBCA_PROGRESS : 11%
DBCA_PROGRESS : 20%
DBCA_PROGRESS : 46%
[ 2018-04-24 22:39:29.839 PET ] Completing Pluggable Database Creation
DBCA_PROGRESS : 53%
[ 2018-04-24 22:39:30.866 PET ] Executing Post Configuration Actions
DBCA_PROGRESS : 100%
[ 2018-04-24 22:39:30.866 PET ] Pluggable database “GMCDB” plugged successfully.

 

–Validamos el acceso al nuevo Pluggable database:
SQL> show pdbs

CON_ID CON_NAME  OPEN MODE RESTRICTED
———– ——————– ——————– —————–
2             PDB$SEED    READ ONLY       NO
3             SMWDB        READ WRITE     NO
4             ZTELBS         READ WRITE     NO
5             GMCDB         READ WRITE     NO

SQL> alter session set container=GMCDB;
Session altered.

SQL> show con_name

CON_NAME
——————————
GMCDB

 

Ya tenemos nuestro nuevo Pluggable Database listo para ser usado!! 🙂