Install XDB on 11.2.0.4 database

Posted: December 21, 2014 in Database General
Tags: , ,

Below are steps to install the XDB on a 11.2.0.4 database. XDB is a essential component with 11g onwards as it’s required for e-mail functionality to work from database. You need to create network ACL list for sending e-mails from database that i will be covering in another post. This post is limited to installation of XDB only. Prior to install the XDB or upgrade a database having XDB installed, look out for any objects that needs to be dropped. Follow the doc 1573175.1 on Oracle support to run the script for checking same. Follow the doc 1292089.1 on Oracle support for detailed information with respect to different versions of database. This installation is done on 11.2.0.4 and pre-install script as per doc 1573175.1 didn’t return any error.

Create a tablespace exclusively for XDB objects.

create tablespace XDB_DATA datafile '/u04/oradata/TESTDB/xdb_data01.dbf' size 1024M;

Now, run the catqm.sql script with parameters as below:

@$ORACLE_HOME/rdbms/admin/catqm.sql A B C D

where:

A : XDB user password
B : XDB Default tablespace
C : XDB user temporary tablespace
D : YES or NO (Yes will use secure File storage and No will use LOB’s)

@$ORACLE_HOME/rdbms/admin/catqm.sql xdb XDB_DATA TEMP NO

In 12c version Oracle XML DB is a mandatory component which cannot be uninstalled and if Oracle XML DB is not already installed in database prior to an upgrade to 12c, then it is automatically installed.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s