Reinstall XDB database component !!!

Home »  ORACLE »  Reinstall XDB database component !!!

On July 3, 2017, Posted by , In ORACLE, By ,, , With 2 Comments

In this article, we will see the steps to reinstall XDB database component.

Reference taken from: Master Note for Oracle XML Database (XDB) Install / Deinstall (Doc ID 1292089.1)

======================================================================================================

 

Follow below steps to reinstall XDB component

– Take full database backup

Before proceeding with resinstallation of XDB, it is recommended to take a full database backup either RMAN or cold backup.

 

– Deinstall XDB

To drop or deinstall the XDB component, we need to execute the “catnoqm.sql” script.

Some XDB related objects in the SYS schema are not dropped during the removal of XDB. Also, the SYS.KU$_% views will become invalid. Please follow below document for cleaning up these objects:
(Doc ID 1269470.1) XDB Deinstallation script catnoqm.sql leads to Invalid SYS Objects

======================================================================================================

 

– Verify that xdb is removed and no invalid objects exist under XDB schema.

Check status of XDB

 

Check for invalid objects owned by XDB

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

======================================================================================================

 

– Prerequirements for XDB installation

1. Tablespace free space size should be 500MB for XDB installation.

If you are using secure_file=yes; in this case tablespace extent size must be equal to or greater than 1MB (please review this).

 

2. Ensure that the SHARED_POOL_SIZE and JAVA_POOL_SIZE is set to at least 250 MB (if applicable).

 

3. Before installing or upgrading XDB, make sure the LD_LIBRARY_PATH / LIBPATH / SHLIB_PATH environment variable is set correctly.
That is, the first directory referenced should be $ORACLE_HOME/lib. This environment variable is used to resolve the location of the shared library “libxdb.so”.

Set LD_LIBRARY_PATH (LIBPATH for AIX or SHLIB_PATH for HP) as follows:

csh: setenv LD_LIBRARY_PATH $ORACLE_HOME/lib:
ksh: export LD_LIBRARY_PATH=$ORACLE_HOME/lib:

 

4. XDB must have execute permissions on the DBMS_LOB and UTL_FILE packages. XDB automatically has these privileges because they are granted to PUBLIC by default. If these privileges have been revoked from PUBLIC for security reasons, errors will be reported during the installation / upgrade of XDB and many XDB objects will become invalid, making the component itself invalid. Therefore, it is recommended to be sure that these packages be granted to PUBLIC before installing / upgrading XDB. Then after the install / upgrade, grant execute permissions on these packages directly to XDB.

======================================================================================================

 

– Install XDB

To install XDB component, we need to execute “catqm.sql” script.

The syntax to run catqm.sql is as following,
SQL> catqm.sql A B C D

Where,

A. XDB user password

B. XDB user default tablespace
(Any tablespace other than SYSTEM, UNDO and TEMP can be specified.
The specified tablespace must already exist prior to running the script.)

C. XDB user temporary tablespace

D. YES or NO
(If YES is specified, the XDB repository will use SecureFile storage.
If NO is specified, LOBS will be used.
To use SecureFiles, compatibility must be set to 11.2.
The tablespace specified for the XDB repository must be using
Automatic Segment Space Management (ASSM) for SecureFiles to be used.)

Install XDB component as shown below,

======================================================================================================

 

– Verify XDB Installation

Check status of XDB

 

Check for invalid objects

 

This completes the reinstallation of XDB component.

======================================================================================================

2 Comments so far:

  1. Ivan says:

    Hello,

    I have Oracle Multimedia installed in CDB. How can i install it in PDB?

    • TJ says:

      Hi Ivan,

      The above article was not for 12c version. What you are asking is for Oracle 12c.
      If you have installed components in CDB using catcon.pl script then those components are reflected in the PDBs you create. But if you don’t use catcon.pl for script executions during component installations then you may get the component installed in CDB but not in the PDB. So you can try to reinstall Oracle Multimedia in CDB using catcon.pl script and check

      Hope this helps you and sorry for the late reply.

      Thanks,
      TJ

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">