Skip to Main Content
  • Questions
  • Invalid Java Class oracle/aurora/rdbms/Compiler

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Frank.

Asked: March 17, 2023 - 6:28 am UTC

Last updated: March 22, 2023 - 2:52 pm UTC

Version: 19.18.0.0.0

Viewed 1000+ times

You Asked

Using loadjava to upload a Java source results in:

ORA-29547: Java system class not available: oracle/aurora/rdbms/Compiler
ORA-06512: at line 1


This usually indicates that you either have not installed the Java Virtual machine or you did not properly apply the latest OJVM PSU patch. However, latest patch was applied and the Java Virtual machine is actually running:

opatch lsinventory:
Patch 34786990 : applied on Mon Jan 23 10:39:29 CET 2023
Unique Patch ID: 25032666
Patch description: "OJVM RELEASE UPDATE: 19.18.0.0.230117 (34786990)"


select comp_id, comp_name, version_full from, status dba_registry;
JAVAVM JServer JAVA Virtual Machine 19.18.0.0.0 VALID



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


SELECT dbms_java.get_jdk_version JDK_Version FROM dual;
JDK_VERSION
--------------------------------------------------------------------------------
1.8.0_361


And formerly uploaded Java 'Hello World' Code works perfectly:
SQL> select helloworld() from dual;
HELLOWORLD()
--------------------------------------------------------------------------------
Hello world


So to summarize, the Java VM ins installed, valid and actually running.
It is just the compiler which isn't working.
And in fact the respective Java Class ins invalid:

select owner, object_name, object_type, status from dba_objects where object_name = 'oracle/aurora/rdbms/Compiler';
SYS oracle/aurora/rdbms/Compiler JAVA CLASS INVALID


Trying to resolve the Java Class results in a segfault:

SQL> alter java class "oracle/aurora/rdbms/Compiler" resolve;
alter java class "oracle/aurora/rdbms/Compiler" resolve
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
Process ID: 1239513
Session ID: 578 Serial number: 75


Alert Log:
ORA-07445: exception encountered: core dump [kglPinMask()+6] [SIGSEGV] [ADDR:0xA0] [PC:0x4BA9C26] [Address not mapped to object] []


So I am wondering what happened and how to solve this issue.
Is there some way to get the Compiler working again?
Do I have to follow the instructions to remove and reinstall the Java VM?
Or does this not solve the Compiler issue?

Any ideas are appreciated!
Thanks in advance and all the best,
Frank

and Chris said...

ORA-07445 => internal error => something has gone seriously wrong!

It looks like something's gone wrong with your Java installation; I don't know what though. This is something you need to take up with support.

Rating

  (1 rating)

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

DBMS_JAVA

More on PL/SQL routine DBMS_JAVA here