Hi all,
I think I messed up the Java Compiler in our 19.18 database.
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)"
sql:
select comp_id, comp_name, version_full from, status dba_registry;
JAVAVM JServer JAVA Virtual Machine 19.18.0.0.0 VALID
dbms_java:
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
output of a formerly uploaded Java 'Hello World' Code:
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