Install database components in a pluggable database
If components are missing, they must be installed manually in the pluggable.
Below an example of the component and the required command.
JAVA
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/******* -n 5 -c '<pdbname>' -e -b jvm_install.log $ORACLE_HOME/javavm/install/initjvm.sql
Oracle XML
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/******* -n 5 -c '<pdbname>' -b xdk_install.log -e $ORACLE_HOME/xdk/admin/initxml.sql
Oracle Spatial
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/******* -n 5 -c '<pdbname>' -b spatial_install.log -e $ORACLE_HOME/md/admin/mdinst.sql
Oracle Multimedia
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -u SYS/******* -n 5 -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/catcon.pl -u SYS/******* -n 5 -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/catcon.pl -u SYS/******* -n 5 -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;
SQL>@?/rdbms/admin/utlrp.sql
ConversionConversion EmoticonEmoticon