问题:
执行JAVAVM 相关功能的sql后报错:
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 INVALID
ORA-29548: Java 系统类报告: could not identify release specified in classes.bin
排查:
--查询确认状态处于无效的组件,确认为JAVAVM
SELECT * FROM dba_registry d ORDER BY comp_name;
select * from dba_registry_history;
处理:
根据文档:Doc ID 2314363.1 步骤,验证处理成功
alter system set java_jit_enabled = FALSE;
alter system set "_system_trig_enabled"=FALSE;
-- Keep a Note of original JOB_QUEUE_PROCESSES value before this
alter system set JOB_QUEUE_PROCESSES=0;
create or replace java system
/
alter system set java_jit_enabled = true;
alter system set "_system_trig_enabled"=TRUE;
alter system set JOB_QUEUE_PROCESSES=10;
@?/rdbms/admin/utlrp.sql