在新安装XDB后，一些对象为失效
SQL> select comp_name, version, status from dba_registry;
COMP_NAME VERSION STATUS
---------------------------------- ----------------------- ----------
Oracle XML Database 11.2.0.2.0 INVALID
Oracle Database Catalog Views 11.2.0.2.0 VALID
Oracle Database Packages and Types 11.2.0.2.0 VALID
JServer JAVA Virtual Machine 11.2.0.2.0 VALID
Oracle XDK 11.2.0.2.0 VALID
Oracle Database Java Packages 11.2.0.2.0 VALID
SQL> select object_type,object_name, owner from dba_objects
where status ='INVALID' and
owner in ('SYS','SYSTEM','XDB')
order by owner, object_name, object_type;
OBJECT_TYPE OBJECT_NAME OWNER
------------------- ------------------------------ --------
PACKAGE BODY DBMS_METADATA SYS
PACKAGE BODY DBMS_NETWORK_ACL_ADMIN SYS
PACKAGE BODY DBMS_XS_PRINCIPAL_EVENTS_INT SYS
PACKAGE BODY XS$CATVIEW_UTIL SYS
PACKAGE BODY DBMS_CSX_INT XDB
PACKAGE BODY DBMS_RESCONFIG XDB
PACKAGE BODY DBMS_XDB XDB
PACKAGE BODY DBMS_XDBRESOURCE XDB
PACKAGE BODY DBMS_XDBUTIL_INT XDB
PACKAGE BODY DBMS_XDBZ0 XDB
PACKAGE BODY DBMS_XMLDOM XDB
PACKAGE BODY DBMS_XMLPARSER XDB
PACKAGE BODY DBMS_XMLSCHEMA XDB
PACKAGE BODY DBMS_XSLPROCESSOR XDB
PACKAGE BODY XIMETADATA_PKG XDB
15 rows selected.
SQL> select owner, schema_url
from dba_xml_schemas
order by 1,2;
OWNER SCHEMA_URL
-------- ----------------------------------------------------------
XDB http://xmlns.oracle.com/xdb/XDBResource.xsd
XDB http://xmlns.oracle.com/xdb/XDBSchema.xsd
2 rows selected.
SQL> select any_path from resource_view;
ERROR:
ORA-01002: fetch out of sequence
MOS:
SOLUTION
To implement the solution, please execute the following steps:
– Disable "password complexity verification" feature
drop function verify_function;
ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION null;
– Grant execute permissions on DBMS_SQL, DBMS_LOB, UTL_FILE to PUBLIC or XDB user
grant execute on dbms_sql to xdb;
grant execute on dbms_lob to xdb;
grant execute on utl_file to xdb;
– Reload (using xdbrelod.sql) or Reinstall (deinstall and install) XML DB following the steps from Note 1292089.1
– Finally, if required, run utlrp.sql:
XML DB and all SYS objects are valid now:
COMP_NAME VERSION STATUS
———————————- ———————– ———-
Oracle XML Database 11.2.0.2.0 VALID
Oracle Database Catalog Views 11.2.0.2.0 VALID
Oracle Database Packages and Types 11.2.0.2.0 VALID
JServer JAVA Virtual Machine 11.2.0.2.0 VALID
Oracle XDK 11.2.0.2.0 VALID
Oracle Database Java Packages 11.2.0.2.0 VALID
SQL> select object_type,object_name, owner from dba_objects
where status ='INVALID' and
owner in ('SYS','SYSTEM','XDB')
order by owner, object_name, object_type;
no rows selected.