4 Replies Latest reply: Oct 11, 2007 7:39 AM by 571473 RSS

    Installing DBMS_JAVA package

    478411
      Hi All,
      in my database Oracle 9.2.0.6 on solaris DBMS_JAVA package is missing. As i want to install the package so i ran initjvm.sql script and spooled the log. I am pasting the spool file for your reference as it's giving an error and terminates the sqlplus session.


      ****************** LOG FILE***********************************

      SQL> @initjvm.sql
      DOC>#######################################################################
      DOC>#######################################################################
      DOC> If the following :test_for_1335603 := 'x' statement causes
      DOC> a PLS-00553 error, and thereby terminates the sqlplus connection,
      DOC> simply restart the script in a new sqlplus session.
      DOC> This error can occur if the script is run in the same session where
      DOC> the database was started. To avoid this problem, always start a new
      DOC> session to run scripts after starting the database.
      DOC>#######################################################################
      DOC>#######################################################################
      DOC>*/

      PL/SQL procedure successfully completed.


      PL/SQL procedure successfully completed.


      PL/SQL procedure successfully completed.

      create or replace package initjvmaux is
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01653: unable to extend table SYS.IDL_UB2$ by 128 in tablespace SYSTEM



      Warning: Package Body created with compilation errors.

      call initjvmaux.drp('drop table java$rmjvm$aux')
      *
      ERROR at line 1:
      ORA-06576: not a valid function or procedure name


      call initjvmaux.drp('drop table java$rmjvm$aux2')
      *
      ERROR at line 1:
      ORA-06576: not a valid function or procedure name


      call initjvmaux.drp('drop table java$rmjvm$aux3')
      *
      ERROR at line 1:
      ORA-06576: not a valid function or procedure name



      Table created.


      Table created.


      Table created.


      Index created.


      Index created.


      Index created.

      create or replace package rmjvm is
      *
      ERROR at line 1:
      ORA-00604: error occurred at recursive SQL level 1
      ORA-01653: unable to extend table SYS.IDL_UB2$ by 128 in tablespace SYSTEM



      Warning: Package Body created with compilation errors.

      DOC>#######################################################################
      DOC>#######################################################################
      DOC> If the following rmjvm.check_for_rmjvm() statement results in
      DOC> ORA-00028 it means that the database has not been restarted
      DOC> since the rmjvm script was run. If so, restart the database and
      DOC> retry this script.
      DOC>#######################################################################
      DOC>#######################################################################
      DOC>*/
      call rmjvm.check_for_rmjvm()
      *
      ERROR at line 1:
      ORA-06576: not a valid function or procedure name


      Disconnected from Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production

      *************END OF LOG FILE**************************************************

      can somebody suggest me as to what should be done? and how can i install DBMS_JAVA Package?
        • 1. Re: Installing DBMS_JAVA package
          Avi Abrami
          Pranav,
          The SYSTEM tablespace is too small.
          This is what the error message is telling you.
          ORA-01653: unable to extend table SYS.IDL_UB2$ by 128 in tablespace SYSTEM
          Ask your DBA to increase the size of your SYSTEM tablespace.

          Good Luck,
          Avi.
          • 2. Re: Installing DBMS_JAVA package
            478411
            thanks Avi.
            I was able to install dbms_java pack. without any problems i also thought after seeing the spool that it's not able to extned system table but did'nt touced it as it was a little risky. Neways i extended the datafile.
            whcih way do you think is better a) extending the data file b) adding a new datafile to the tablespace?
            • 3. Re: Installing DBMS_JAVA package
              Avi Abrami
              Pranav,
              You asked:
              which way do you think is better
              Since I have no experience in such matters, I can't tell you.
              (Doesn't your DBA know?)

              Good Luck,
              Avi.
              • 4. Re: Installing DBMS_JAVA package
                571473
                Hi Pranav,

                I donot have the script to generate the DBMS_JAVA package. If possible please forward me the script. Please help me in this. URGENT.

                Thanks in advance.

                VJ
                thanks Avi.
                I was able to install dbms_java pack. without any
                problems i also thought after seeing the spool that
                it's not able to extned system table but did'nt
                touced it as it was a little risky. Neways i extended
                the datafile.
                whcih way do you think is better a) extending the
                data file b) adding a new datafile to the tablespace?