Scribd
Upload
21 views2 pages

Install Oracle XML Database 11G

This document outlines the steps to manually install an XML database in Oracle 11g. It involves confirming the XML DB does not already exist, creating the XDB user and granting it privileges, running a script to perform the initial installation, granting additional permissions to XDB, installing missing components from a bug, recompiling objects, and verifying the XML DB was successfully installed.

Uploaded by

aggarwallokesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
21 views2 pages

Install Oracle XML Database 11G

This document outlines the steps to manually install an XML database in Oracle 11g. It involves confirming the XML DB does not already exist, creating the XDB user and granting it privileges, running a script to perform the initial installation, granting additional permissions to XDB, installing missing components from a bug, recompiling objects, and verifying the XML DB was successfully installed.

Uploaded by

aggarwallokesh
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Steps to Manually install XML Database(11G)

1. Confirm that XML DB does not exist.


SQL> SELECT username FROM DBA_USERS where username = 'XDB';
no rows selected
SQL> DESCRIBE RESOURCE_VIEW
ERROR:
ORA-04043: Object RESOURCE_VIEW does not exist

2.

Creating the XMLDB user in the database


DROP USER XDB CASCADE;
CREATE USER XDB
IDENTIFIED BY xdb
DEFAULT TABLESPACE SYSAUX
TEMPORARY TABLESPACE TEMP
PROFILE DEFAULT
ACCOUNT UNLOCK;
-- 2 Roles for XDB
GRANT RESOURCE TO XDB;
GRANT JAVAUSERPRIV TO XDB;
ALTER USER XDB DEFAULT ROLE ALL;
-- 10 System Privileges for XDB
GRANT CREATE PUBLIC SYNONYM TO XDB;
GRANT UNLIMITED TABLESPACE TO XDB;
GRANT CREATE OPERATOR TO XDB;
GRANT DROP PUBLIC SYNONYM TO XDB;
GRANT ALTER SESSION TO XDB;
GRANT CREATE SESSION TO XDB;
GRANT CREATE INDEXTYPE TO XDB;
GRANT QUERY REWRITE TO XDB;
GRANT CREATE VIEW TO XDB;
GRANT CREATE LIBRARY TO XDB;
-- 6 Object Privileges for XDB
GRANT EXECUTE ON SYS.CHECK_UPGRADE TO XDB;
GRANT EXECUTE ON SYS.DBMS_REGISTRY TO XDB;
GRANT EXECUTE ON SYS.DBMS_RLS TO XDB;
GRANT EXECUTE ON SYS.DBMS_SYS_SQL TO XDB;
GRANT EXECUTE ON SYS.SET_TABLESPACE TO XDB;
GRANT SELECT ON [Link]$ TO XDB;

3. As SYS, perform the XML DB installation - Note: this will not be a complete build due to
Oracle Bug 9818995:
SQL>@$ORACLE_HOME/rdbms/admin/[Link] xdb sysaux temp yes

4. As SYS, grant the relevant permissions to the XDB user:


SQL> GRANT EXECUTE ON utl_file TO xdb;
Grant succeeded.

Ankesh Barode([Link])

SQL> GRANT EXECUTE ON dbms_lob TO xdb;


Grant succeeded.
5. As SYS, install the missing contents caused by Oracle Bug 9818995:
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP UPGRADE
SQL>@$ORACLE_HOME/rdbms/admin/[Link]
SQL>SHUTDOWN IMMEDIATE;
SQL>STARTUP OPEN
6. Recompile the objects from SYS:
SQL>@$ORACLE_HOME/rdbms/admin/[Link]

7. Verify XML DB is installed Execute below script as SYS or user with DBA
privilege.
select comp_name, version, status
from dba_registry;
COMP_NAME
------------------------------------Oracle Text
Oracle XML Database
Oracle Database Catalog Views
Oracle Database Packages and Types
JServer JAVA Virtual Machine
Oracle Database Java Packages
Oracle XDK

VERSION
STATUS
------------------------------ -------[Link].0
[Link].0
[Link].0
[Link].0
[Link].0
[Link].0
[Link].0

VALID
VALID
VALID
VALID
VALID
VALID
VALID

Ankesh Barode([Link])

You might also like