在新安装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[......]
新安装的XDB组件状态是INVALID的，报下面的错：
SQL> set echo on
SQL> -- @catqm.sql
SQL>
SQL> @?/rdbms/admin/catqm xdbpwd XDB TEMP NO
SQL> Rem
...
...
SQL> declare
2 ACLXSD BFILE := dbms_metadata_hack.get_bfile('acl.xsd.11.2');
3 ACLURL VARCHAR2(2000) := 'http://xmlns.oracle.com/xdb/acl.xsd';
4 begin
5 xdb.dbms_xmlschema.registerSchema(ACLURL, ACLXSD, FALSE, FALSE, FALSE, TRUE,
6 FALSE, 'XDB',[......]
在删除XDB的时候，导致一些sys一些对象失效：
版本为：11.2.0.1 to 11.2.0.2
SQL> select COMP_ID, COMP_NAME, VERSION, STATUS from dba_registry; COMP_ID COMP_NAME VERSION STATUS ------- ------------------------------------ ------------ -------- CONTEXT Oracle Text 11.2.0.2.0 VALID EXF Oracle Expression Filter 11.2.0.2.0 VALID OWM Oracle Workspace Manager 11.2.0.2.0 VALID CATALOG Oracle Database[......]
前段时间一个数据库发现没有安装XDB组件，查了下mos:
注意：在安装前和删除前必须重启数据库。
XDB Removal
The catnoqm.sql script drops XDB.
spool xdb_removal.log
set echo on;
connect / as sysdba
shutdown immediate;
startup
@?/rdbms/admin/catnoqm.sql
spool off;
Some XDB related objects in the SYS schema are not dropped during the removal of XDB. Also, the SYS.KU$_% views will become invalid. Please see the following document for cleaning up these objects:
11g active dataguard 生成的awr信息是主库的awr，而不是dataguard的awr信息，不能生成备库的awr，但是可以生产statspack。
1. Standby Statspack Usage
1.1 Statspack Installation
The perfstat schema and statspack related objects must be present on the primary and standby prior to installing standby statspack.
If the perfstat user does not exist in the primary site then you will need to create the perfstat schema using the following:
sqlplus / as sysdba
SQL> @?/rdbms/admin/spcr[……]