ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359

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

ERROR at line 1:
ORA-29516: Aurora assertion failure: Assertion failure at eox.c:359

SQL>

Fix:-

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

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

SQL> ALTER SYSTEM SET java_jit_enabled=FALSE SCOPE=BOTH;

SQL> ALTER SYSTEM SET java_jit_enabled=TRUE SCOPE=BOTH;

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

DBMS_JAVA.LONGNAME('TEST')
----------------------------------
TEST

Advertisement

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s