ORACLE 11G 安装XDB组件

环境oracle 11R2

注意事项:在安装或者删除XDB前需要重启数据库

安装步骤如下:

  1. 新建XDB默认表空间

    Create tablespace xdb datafile ‘****’ size 400M autoexten off segment space management auto;

  2. 重启数据库
  3. 运行catqm.sql安装XDB组建

    Catqm.sql需要的参数:

    A:XDB用户的密码

    B:XDB用户的默认表空间

    C:XDB默认临时表空间

    D:(YES/NO) XDB repository是否用securefile存储,如果使用securefile则表空间必须使用ASSM

    Ex:

    @?/rdbms/admin/catqm.sql XDB XDB TEMP YES

  4. 运行utlrp.sql


 

安装完成后验证:

spool xdb_status.txt

set echo on;

connect / as sysdba

set pagesize 1000

col comp_name format a36

col version format a12

col status format a8

col owner format a12

col object_name format a35

col name format a25

 

– Check status of XDB

 

select comp_name, version, status

from dba_registry

where comp_id = ‘XDB’;

 

– Check for invalid objects

    
 

select owner, object_name, object_type, status

from dba_objects

where status = ‘INVALID’

and owner in (‘SYS’, ‘XDB’);

spool off;

删除步骤:

  1. 重启实例

2、运行catnoqm.sql

删除后会有sys objects 状态变成INVALID 请参考Doc ID 1269470.1

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>