ITPub博客

首页 > Linux操作系统 > Linux操作系统 > how to create the dbms_java package

how to create the dbms_java package

原创 Linux操作系统 作者:liyijie78 时间:2011-01-19 17:15:29 0 删除 编辑
 if you create a set of scripts using the dbca then there should be one
looking basically like this:

@?/javavm/install/initjvm.sql;
@?/xdk/admin/initxml.sql;
@?/xdk/admin/xmlja.sql;
@?/rdbms/admin/catjava.sql;
@?/rdbms/admin/catexf.sql;

Ok, this is for 10g, but I think it was pretty similar for 9i.

After these scripts have run (connect / as sysdba and have the DB for
yourself without users logged in) you should have the dbms_java package.
You can check that with the sqlplus describe command.

Don't forget to set java_pool_size and (I think) large_pool_size to
something like 150M each during installation. Also bounce the instance
after installation and run ?/rdbms/admin/utlrp.
 
 
The scripts you have to run as sys for oracle 9.2 are:
@$ORACLE_HOME/javavm/install/initjvm.sql
@$ORACLE_HOME/xdk/admin/initxml.sql
@$ORACLE_HOME/xdk/admin/xmlja.sql
@$ORACLE_HOME/rdbms/admin/catjava.sql

As Paul says you have to increase the java_pool_size (one of the
scripts hangs if it is small).
 - THE END -

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11417069/viewspace-684275/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2011-01-07

  • 博文量
    93
  • 访问量
    277160