system@DB01> select schema,comp_name,version,status from dba_registry;
SCHEMA COMP_NAME VERSION STATUS
------------------------------ -------------------------------------------------- ------------------------------
APEX_050000 Oracle Application Express 5.0.3.00.03 VALID
EXFSYS Oracle Expression Filter 11.2.0.4.0 VALID
EXFSYS Oracle Rules Manager 11.2.0.4.0 INVALID
XDB Oracle XML Database 11.2.0.4.0 VALID
WMSYS Oracle Workspace Manager 11.2.0.4.0 VALID
SYS Oracle Database Catalog Views 11.2.0.4.0 VALID
SYS Oracle Database Packages and Types 11.2.0.4.0 VALID
SYS JServer JAVA Virtual Machine 11.2.0.4.0 VALID
SCHEMA COMP_NAME VERSION STATUS
------------------------------ -------------------------------------------------- ------------------------------
APEX_050000 Oracle Application Express 5.0.3.00.03 VALID
EXFSYS Oracle Expression Filter 11.2.0.4.0 VALID
EXFSYS Oracle Rules Manager 11.2.0.4.0 INVALID
XDB Oracle XML Database 11.2.0.4.0 VALID
WMSYS Oracle Workspace Manager 11.2.0.4.0 VALID
SYS Oracle Database Catalog Views 11.2.0.4.0 VALID
SYS Oracle Database Packages and Types 11.2.0.4.0 VALID
SYS JServer JAVA Virtual Machine 11.2.0.4.0 VALID
Find out invalid objects owned by schema 'EXFSYS' which could INVALID the component Oracle Rules Manager,
system@DB01> select object_name,object_type,status
2 from dba_objects
3 where owner='EXFSYS' and status='INVALID';
OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------- -------
/53ad31cb_TagsLocator JAVA CLASS INVALID
/357abd97_XPathFilter JAVA CLASS INVALID
2 from dba_objects
3 where owner='EXFSYS' and status='INVALID';
OBJECT_NAME OBJECT_TYPE STATUS
------------------------------ ------------------- -------
/53ad31cb_TagsLocator JAVA CLASS INVALID
/357abd97_XPathFilter JAVA CLASS INVALID
Check errors of found invalid JAVA CLASSes,
system@DB01> select name,text
2 from dba_errors
3 where owner='EXFSYS' and name in ('/53ad31cb_TagsLocator','/357abd97_XPathFilter');
NAME TEXT
------------------------- ------------------------------------------------------------
/357abd97_XPathFilter ORA-29534: referenced object EXFSYS.oracle/expfil/xpath/TagsLocator could not be resolved
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/DOMParser could not be found
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/XMLParseException could not be found
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/XMLDocument could not be found
2 from dba_errors
3 where owner='EXFSYS' and name in ('/53ad31cb_TagsLocator','/357abd97_XPathFilter');
NAME TEXT
------------------------- ------------------------------------------------------------
/357abd97_XPathFilter ORA-29534: referenced object EXFSYS.oracle/expfil/xpath/TagsLocator could not be resolved
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/DOMParser could not be found
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/XMLParseException could not be found
/53ad31cb_TagsLocator ORA-29521: referenced name oracle/xml/parser/v2/XMLDocument could not be found
Oracle Rules Manager is in INVALID status because the referenced object/names created by installing XDK cannot be resolved/found. EXFSYS (owner of Oracle Rules Manager) JAVA Classes are dependent on XDK. Therefore installing XDK will validate Oracle Rules Manager,
conn / as sysdba
@?/xdk/admin/initxml.sql
@?/rdbms/admin/utlrp.sql
@?/xdk/admin/initxml.sql
@?/rdbms/admin/utlrp.sql
Check component status,
system@DB01> select schema,comp_name,version,status from dba_registry;
SCHEMA COMP_NAME VERSION STATUS
------------------------------ -------------------------------------------------- ------------------------------
APEX_050000 Oracle Application Express 5.0.3.00.03 VALID
EXFSYS Oracle Expression Filter 11.2.0.4.0 VALID
EXFSYS Oracle Rules Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
WMSYS Oracle Workspace Manager 11.2.0.4.0 VALID
SYS Oracle Database Catalog Views 11.2.0.4.0 VALID
SYS Oracle Database Packages and Types 11.2.0.4.0 VALID
SYS JServer JAVA Virtual Machine 11.2.0.4.0 VALID
SCHEMA COMP_NAME VERSION STATUS
------------------------------ -------------------------------------------------- ------------------------------
APEX_050000 Oracle Application Express 5.0.3.00.03 VALID
EXFSYS Oracle Expression Filter 11.2.0.4.0 VALID
EXFSYS Oracle Rules Manager 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
WMSYS Oracle Workspace Manager 11.2.0.4.0 VALID
SYS Oracle Database Catalog Views 11.2.0.4.0 VALID
SYS Oracle Database Packages and Types 11.2.0.4.0 VALID
SYS JServer JAVA Virtual Machine 11.2.0.4.0 VALID
No comments:
Post a Comment