Oracle XDB Install/DeInstall

1. Deinstall XDB:

SQL> spool xdb_removal.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
SQL> startup
SQL> @?/rdbms/admin/catnoqm.sql
SQL> spool off;


2. Reinstall XDB -- Specify a default tablespace that is using ASSM such as SYSAUX:

select tablespace_name, extent_management, segment_space_management
from dba_tablespaces
where tablespace_name in ('SYSTEM', 'SYSAUX');

TABLESPACE_NAME      EXTENT_MANAGEMENT  SEGMENT_SPACE_MANAGEMENT
--------------------------------- ------------------------------------ -------------------------------------------------
SYSAUX                           LOCAL                                AUTO
SYSTEM                           LOCAL                                MANUAL

## IMPORTANT: You must shutdown and restart the database between removal and reinstall ##

SQL> spool xdb_install.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
SQL> startup;
SQL> @?/rdbms/admin/catqm.sql xdb sysaux temp yes
SQL> spool off


3. Run utlrp.sql to validate any remaining invalid objects and verify the XDB installation:

spool xdb_status.txt
connect / as sysdba
set echo on;
set pagesize 10000
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

SQL> @?/rdbms/admin/utlrp.sql

select comp_name, version, status
from dba_registry;

select owner, object_name, object_type, status
from dba_objects
where status = 'INVALID'
and owner in = 'XDB';

spool off;