How to load java in Oracle Database !!

You need to connect as sys and run following statments.

- To Load Java

connect sys/PASSWD as SYSDBA
set echo off
set verify off
@$ORACLE_HOME/javavm/install/initjvm.sql
@$ORACLE_HOME/xdk/admin/initxml.sql
@$ORACLE_HOME/xdk/admin/xmlja.sql
@$ORACLE_HOME/rdbms/admin/catjava.sql

- To load XDB

Please make sure that you have already set the following path before load XDB, else you may hit following errors during loading.

export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LIBPATH=$ORACLE_HOME/lib

Otherwise you get "ORA-00600: internal error code, arguments: [unable to load XDB library], [], [], [], [], [], [], []"

For More info.( please refer note 225897.1Installation of Oracle XDB Fails with ORA-00600 [unable to load XDB library] )

If you want to remove XDB or reload

@${ORACLE_HOME}/rdbms/admin/catnoqm.sql

I would recommend to restart the database for reloading XDB.