- 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