Friday, August 15, 2008

To install Java in Oracle 10g

# a cut-down version of Metalink Note 276554.1

cd $ORACLE_HOME/rdbms/admin
sqlplus '/ as sysdba'
@utlrp
spool java.log
set pagesize 100
select COMP_NAME, status from dba_registry;
select object_type||' '||owner||'.'||object_name from dba_objects where status = 'INVALID' order by object_type, owner;
alter system set java_pool_size = 150M SID='tl01dwh1';
@?/javavm/install/initjvm.sql
@?/xdk/admin/initxml.sql
@?/xdk/admin/xmlja.sql
@?/rdbms/admin/catjava.sql
@?/rdbms/admin/catexf.sql
@?/rdbms/admin/utlrp.sql
select object_type||' '||owner||'.'||object_name from dba_objects where status = 'INVALID' order by object_type, owner;
select COMP_NAME, status from dba_registry;
spool off