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