Posts Tagged ‘ORA-00604’

ORA-00604 and ORA-29516 while dropping user accounts.

Lately, I was trying to drop a user account in one of my database. During this operation I came across the following errors:
ORA-00604: error occurred at recursive SQL level 1 and ORA-29516: Aurora assertion failure: Assertion failure.
It was obvious that the the real problem was the second error: ORA-29516. I quickly figured out that the JAVA component was corrupted – you can check this by executing java related packages:

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

and then you’ve got the following error:

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
ORA-06512: at “SYS.DBMS_JAVA”, line 139

The solution is relatively simple, just follow below steps:

execute sys.dbms_registry.loaded('JAVAVM');
execute sys.dbms_registry.valid('JAVAVM');
alter system set "_system_trig_enabled"=false scope=memory;
alter system set java_jit_enabled=false;
create or replace java system 

and now you can check :

select dbms_java.longname(‘TEST’) from dual;


That’s all.