SOLVED

ORA-29516: Aurora Assertion Failure: Assertion Failure

Asked by OracleDba11 viewsoracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
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.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
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!
OracleDba

Post Your Solution