组件失效问题解决-Oracle

故障案例1：JVM INVALID
此故障经常出现在Oracle打补丁升级后，JAVA VM组件失效，状态变为INVALID

以下SQL查询组件状态：
set lines 200 pages 50000
col comp_id format a10
col comp_name format a35
col version format a15
col status format a15
select comp_id,comp_name, version, status from dba_registry;

JVM是一个独立的执行环境平台，其可以直接将JAVA源码编译成机器码，然后在特定的处理器架构或者系统下执行。
修复方法：
   1.set the following init parameters so that JIT and job processes do not start.
   SQL> alter system set java_jit_enabled = FALSE;
   SQL> alter system set "_system_trig_enabled"=FALSE;    -- Keep a Note of original JOB_QUEUE_PROCESSES value before this
   SQL> alter system set JOB_QUEUE_PROCESSES=0;

   2. Now attempt to recreate the jvm in the database without affecting any of
   the user owned Java objects.
   SQL> create or replace java system

   3. Reset modified init parameters
   SQL> alter system set java_jit_enabled = TRUE;
   SQL> alter system set "_system_trig_enabled"=TRUE;
   SQL> alter system set JOB_QUEUE_PROCESSES=32;-- or original JOB_QUEUE_PROCESSES value

   4.Then run below script to recompile any invalid objects:
   SQL> @?/rdbms/admin/utlrp.sql

故障案例2：Spatial and XDB components are INVALID in DBA_REGISTRY
修复方法：
   conn / as sysdba
   GRANT EXECUTE ON UTL_FILE TO XDB;
   GRANT EXECUTE ON DBMS_JOB TO XDB;

   ALTER PACKAGE XDB.DBMS_CLOBUTIL COMPILE;
   ALTER PACKAGE XDB.DBMS_XDBT COMPILE;
   ALTER PACKAGE XDB.DBMS_XDB_ADMIN COMPILE;
   ALTER PACKAGE XDB.DBMS_XMLPARSER COMPILE;
   ALTER PACKAGE XDB.DBMS_XSLPROCESSOR COMPILE;

   @?/rdbms/admin/utlrp.sql--- run it 3- 4 times
   conn / as sysdba
   EXEC DBMS_REGXDB.VALIDATEXDB;

官方文档：
Document 2314631.1-Oracle JVM组件修复
Document 2523682.1-Spatial and XDB components are INVALID in DBA_REGISTRY