ORA-29516: Aurora Assertion Failure: Assertion Failure

Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
Breadcrumb Abstract Shape
  • User AvatarANKUSH THAVALI
  • 03 Dec, 2023
  • 0 Comments
  • 44 Secs Read

ORA-29516: Aurora Assertion Failure: Assertion Failure

Problem :

 
select dbms_java.longname('TEST') from dual;
select dbms_java.longname('TEST') from dual
*
ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359
Uncaught exception Root of all Java exceptions: java.lang.UnsatisfiedLinkError
sun.net.PortConfig.getLower0
ORA-06512: at "SYS.DBMS_JAVA", line 139

If the java component is corrupted, you may get this error.

Solution :

Follow the below Steps :

SQL>execute sys.dbms_registry.loaded('JAVAVM');

PL/SQL procedure successfully completed.

SQL>execute sys.dbms_registry.valid('JAVAVM');

PL/SQL procedure successfully completed.

SQL> alter system set "_system_trig_enabled" = false scope=memory;

alter system set java_jit_enabled=false;

System altered.

System altered.

SQL>create or replace java system 

/

Java created.

Now check :

SQL>

select dbms_java.longname('TEST') from dual;

DBMS_JAVA.LONGNAME('TEST')

---------------------------------------------------

TEST


Hope it Helps!