If the java component is corrupted, then while executing java related packages, you may face below error.

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

Solution:

Follow 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

   

SEE ALSO: