Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2004
    Posts
    14

    Unanswered: Installing DMBS_JAVA Package

    I recently came to discover that one of my client's Oracle 9i database (unix platform) is installed without a DBMS_JAVA package which in turn forbids me to load java stored procedures. Can someone help me or tell me how do i install the package? Bear in mind, the database is the REAL thing not a testing machine. Thanks!

  2. #2
    Join Date
    Nov 2002
    Posts
    833
    you need to install the Oracle JVM

    SQL>set echo on
    SQL>spool jvminst.log
    SQL>@?/javavm/install/initjvm.sql
    SQL>spool off


    ensure your SGA has at least 50MB and your JAVA_POOL_SIZE should be larger than 30MB and within the System's tablespace will be consumed additionally 130 MB rollback needed 100MB

  3. #3
    Join Date
    Nov 2002
    Posts
    833
    you need to install the Oracle JVM

    SQL>set echo on
    SQL>spool jvminst.log
    SQL>@?/javavm/install/initjvm.sql
    SQL>spool off


    ensure your SGA has at least 50MB and your JAVA_POOL_SIZE should be larger than 30MB and within the System's tablespace will be consumed additionally 130 MB rollback needed 100MB

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •