记录一次处理oracle数据库JAVAVM 组件状态无效

问题:

执行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