— Wersja Javy nie jest zgodna, sprawdzamy:
— select get_java_property(’java.version’) from dual;
SELECT dbms_java.get_ojvm_property(PROPSTRING=>’java.version’) FROM dual;
ORA-29548: Java system class reported: release of Java system classes in the database (11.2.0.4.190416) does not match that of the oracle executable (11.2.0.4.200714)
ORA-06512: at „SYS.DBMS_JAVA”, line 930
— postinstalla ktos nie zrobil czyli lecimy:
— opatch lsinventory i szukamy ostatniego (np. OJVM)
— Patch 31219953 : applied on Mon Oct 26 17:33:22 CET 2020
— Unique Patch ID: 23638855
— Patch description: „OJVM PATCH SET UPDATE 11.2.0.4.200714”
— Created on 3 Jun 2020, 03:51:57 hrs PST8PDT
— odpalamy:
@/u01/app/oracle/product/11.2.0.4/dbhome_1/sqlpatch/31219953/postinstall.sql
— sprawdzamy
SELECT dbms_java.get_ojvm_property(PROPSTRING=>’java.version’) FROM dual;
DBMS_JAVA.GET_OJVM_PROPERTY(PROPSTRING=>’JAVA.VERSION’)
1.7.0_271