Install database components in a pluggable database

If a pluggable database is created by means of a clone of the PDB $ SEED, all components included in the PDB $ SEED will naturally also go along. If, however, components are missing, they must be installed in the pluggable.

Below an overview of the component and the required statement.


$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -c '<pdbname>' -e -b jvminstall.log $ORACLE_HOME/javavm/install/initjvm.sql

Oracle XML

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -c '<pdbname>' -b install_xdk.log -e $ORACLE_HOME/xdk/admin/initxml.sql

Oracle Spatial

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -c '<pdbname>' -b install_spatial.log -e $ORACLE_HOME/md/admin/mdinst.sql

Oracle Multimedia

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -c '<pdbname>' -b install_media2.log -e $ORACLE_HOME/ord/im/admin/catim.sql

Oracle Text

$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -d $ORACLE_HOME/ctx/admin -b ctxinstlog -c '<pdbname>' catctx.sql --p'ctxsys' --p'SYSAUX' --p'TEMP' --p'nolock'
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/ -u SYS/xxxxxxx -n 8 -d $ORACLE_HOME/rdbms/admin -b xdbprivslog -c '<pdbname>' $ORACLE_HOME/rdbms/admin/dbmsxdbt.sql


Validate installed components

SELECT comp_name, status, substr(version,1,10) AS version FROM dba_registry;
SELECT object_name, object_type, status FROM dba_objects WHERE status != 'VALID' ORDER BY object_type,object_name;

30 januari 2019|12c, 18c, Multitenancy|

Leave A Comment