首页 > 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:


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:

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

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录


  • 博文量
  • 访问量