Installing & Uninstalling XDB in Oracle 11g

Below Steps can be used for installing & uninstalling XDB in Oracle 11g.

Refer Master Doc – (Doc ID 1292089.1)

Pre checks

SYS> SELECT OWNER,COUNT(*) FROM DBA_OBJECTS WHERE STATUS=’INVALID’ GROUP BY OWNER;

SYS>select USERNAME,ACCOUNT_STATUS,CREATED from dba_users where USERNAME=’XDB’;

SYS>SELECT COMP_NAME,VERSION,STATUS,MODIFIED FROM DBA_REGISTRY where COMP_NAME like ‘%XML%’;

Uninstalling XDB

srvctl stop database -d dbname
srvcyl start database -d dbname
connect / as sysdba
@?/rdbms/admin/catnoqm.sql

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:

(Doc ID 1269470.1) XDB Deinstallation script catnoqm.sql leads to Invalid SYS Objects

Installing XDB

connect / as sysdba

CREATE TABLESPACE XDB_TBS DATAFILE ‘+DATA’ size 500M;

create temporary tablespace TEMP_XDB TEMPFILE ‘+DATA’ size 500M;

@?/rdbms/admin/catqm.sql Welcome1 XDB_TBS TEMP_XDB YES

Post checks-

SYS> SELECT OWNER,COUNT(*) FROM DBA_OBJECTS WHERE STATUS=’INVALID’ GROUP BY OWNER;

SYS>select USERNAME,ACCOUNT_STATUS,CREATED from dba_users where USERNAME=’XDB’;

SYS>SELECT COMP_NAME,VERSION,STATUS,MODIFIED FROM DBA_REGISTRY where COMP_NAME like ‘%XML%’;