This discussion is archived
9 Replies Latest reply: Aug 16, 2011 12:13 PM by jschellSomeoneStoleMyAlias RSS

ORA-29516: Aurora assertion failure

715920 Newbie
Currently Being Moderated
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 Journeyer
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points