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';
Worked smoothly. Thanks.
ReplyDeletecan we install on oracle standard version 11.2.0.4.0?
ReplyDelete