ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler

Seems that java component is missing form the Oracle binaries or not working properly.

Error:

ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
ORA-29540: class oracle/aurora/rdbms/DbmsJava does not exist

Solution:

  1. Check the status of JAVAVM in dba_registory
select comp_id, status from dba_registry;

2. Try to run the utlrp.sql to valid all the invalid objects in the database

    @?\rdbms\admin\utlrp.sql

    3. JServer not working properly, run this script as SYS:

    @?\javavm\install\initjvm

    Hopefully initjvm will fix the issue.

    This entry was posted in Oracle on by .
    Unknown's avatar

    About SandeepSingh

    Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

    Leave a Reply