9 Replies Latest reply: Aug 16, 2011 2:13 PM by jschellSomeoneStoleMyAlias RSS

    ORA-29516: Aurora assertion failure

    715920
      Dear all,
      I tried to execute a java code in PL/SQL via SQLplus. What I did before run the code, were:
      1. Created and compile the code.
      2. Loaded the the class
      3. Created PL/SQL function, which is a wrapper to the java function.
      All the steps were successfully executed, however when I tried to run the PL/SQL function I got:
      SQL> EXEC DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt'))
      BEGIN DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt')); END;
      
      *
      ERROR at line 1:
      ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
      Uncaught exception System error:   java/lang/UnsupportedClassVersionError
      ORA-06512: at "HR.FDELETE", line 1
      ORA-06512: at line 1
      What is the problem?
      SQL> select * from v$version;
      
      BANNER
      --------------------------------------------------------------------------------
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE     11.2.0.1.0     Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production
      
      oracle@firefly]$ java -version
      java version "1.6.0_26"
      Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
      Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)
      [oracle@firefly]$ java -jar ojdbc5.jar
      Oracle 11.2.0.1.0 JDBC 3.0 compiled with JDK5
      [oracle@firefly]$ java -jar ojdbc6.jar
      Oracle 11.2.0.1.0 JDBC 4.0 compiled with JDK6
      Please help,
      best regards,
      Val
        • 1. Re: ORA-29516: Aurora assertion failure
          836548
          Valerie Debonair wrote:
          Dear all,
          I tried to execute a java code in PL/SQL via SQLplus. What I did before run the code, were:
          1. Created and compile the code.
          2. Loaded the the class
          3. Created PL/SQL function, which is a wrapper to the java function.
          All the steps were successfully executed, however when I tried to run the PL/SQL function I got:
          SQL> EXEC DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt'))
          BEGIN DBMS_OUTPUT.PUT_LINE (fdelete('/home/oracle/some_file.txt')); END;
          
          *
          ERROR at line 1:
          ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
          Uncaught exception System error:   java/lang/UnsupportedClassVersionError
          ORA-06512: at "HR.FDELETE", line 1
          ORA-06512: at line 1
          What is the problem?
          SQL> select * from v$version;
          
          BANNER
          --------------------------------------------------------------------------------
          Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
          PL/SQL Release 11.2.0.1.0 - Production
          CORE     11.2.0.1.0     Production
          TNS for Linux: Version 11.2.0.1.0 - Production
          NLSRTL Version 11.2.0.1.0 - Production
          
          oracle@firefly]$ java -version
          java version "1.6.0_26"
          Java(TM) SE Runtime Environment (build 1.6.0_26-b03)
          Java HotSpot(TM) 64-Bit Server VM (build 20.1-b02, mixed mode)
          [oracle@firefly]$ java -jar ojdbc5.jar
          Oracle 11.2.0.1.0 JDBC 3.0 compiled with JDK5
          [oracle@firefly]$ java -jar ojdbc6.jar
          Oracle 11.2.0.1.0 JDBC 4.0 compiled with JDK6
          Please help,
          best regards,
          Val
          Similar issue was reported earlier:

          ORA-29516: Bulk load of method failed; insufficient shm-object space
          • 2. Re: ORA-29516: Aurora assertion failure
            715920
            hi,
            the link that gave me has different error:
            insufficient shm-object space
            while mine having the following error:
            Uncaught exception System error:   java/lang/UnsupportedClassVersionError
            Any other ideas?
            • 3. Re: ORA-29516: Aurora assertion failure
              Kayaman
              Looks like the class is for a too high version.

              You can check the version by following these instructions: http://thiamteck.blogspot.com/2007/11/determine-java-class-file-version.html
              • 4. Re: ORA-29516: Aurora assertion failure
                715920
                How can I check which class that oracle looks at?
                is it set by CLASSPATH environment variable?

                I set CLASSPATH into the library location of jdk 1.6.0 update 26 (which is installed in my machine), but this didn't solve the problem. Did I miss anything?
                • 5. Re: ORA-29516: Aurora assertion failure
                  Kayaman
                  Hmm, you could test compiling your class with the target flag, setting the classfile to be 1.5 compliant. I.e. "javac -target 1.5 <whatever>". I'm not at all familiar with this Java running inside of Oracle thing, but it's worth a try.
                  • 6. Re: ORA-29516: Aurora assertion failure
                    715920
                    Ok, that worked! phew...! A very simple matter but crucial... Apparently the 11g is loaded with 1.5 but not 1.6...

                    many thanks [thumbs up]!
                    I wonder how to make oracle uses 1.6 though......

                    Edited by: Valerie Debonair on Aug 15, 2011 5:28 AM
                    • 7. Re: ORA-29516: Aurora assertion failure
                      YoungWinston
                      Valerie Debonair wrote:
                      I wonder how to make oracle uses 1.6 though......
                      I wouldn't bother. Since Java 1.7 has just come out, I suspect that'll be the one they aim at. It may also explain why they haven't bothered with 1.6 compliance.

                      Winston
                      • 8. Re: ORA-29516: Aurora assertion failure
                        715920
                        Just figured it out though, just for kicks, I upgraded JDBC driver for JDK 1.6.

                        That worked fine with my current JDK 1.6

                        thanks again guys.....
                        • 9. Re: ORA-29516: Aurora assertion failure
                          jschellSomeoneStoleMyAlias
                          YoungWinston wrote:
                          Valerie Debonair wrote:
                          I wonder how to make oracle uses 1.6 though......
                          I wouldn't bother. Since Java 1.7 has just come out, I suspect that'll be the one they aim at. It may also explain why they haven't bothered with 1.6 compliance.
                          I doubt they will update 11 regardless of version.