Wednesday, April 6, 2011

Install XDB on Oracle Database 11gR2

We have prepared below steps to install XDB on our Oracle Database 11gR2.
For details please follow MOS Note:ID 1292089.1.

1. install XDB

SQL> spool xdb_install.log
SQL> set echo on;
SQL> connect / as sysdba
SQL> shutdown immediate;
SQL> startup;
SQL> @?/rdbms/admin/catqm.sql welcome SYSAUX TEMP NO
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off

2. verify

- Check status of XDB

select comp_name, version, status
from dba_registry
where comp_id = 'XDB';

- Check for invalid objects owned by XDB

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