Installing Oracle TEXT and XML DB Components on New Instance

[lisat76]

I have set up a New Instance or Oracle on a Solaris Unix box that already had Oracle 10g installed.
The instance was created fine, however I need the Oracle Text Component and XML DB Component installed as well.
Those are not installed with this instance. They are installed on the other instance on the box that was setup when oracle was first installed.
How can I add these components to this new instance?
DBCA was not used when the instance was created. The DBA here does not care for this tool.

Thanks

 

[karluk]

The scripts to install Oracle text differ depending on your release level. For Oracle 10g, release 2 (10.2.0.x), you should follow the instructions in Oracle support note 979705.1 - Manual Installation, Deinstallation of Oracle Text 10gR2. The following is a summary of the installation instructions in note 979705.1

Basically you need to have your DBA log in to your database as the sys user and run the script in $ORACLE_HOME/ctx/admin/catctx.sql A sample sql*plus session that does this is

SQL> connect SYS/password@tns_alias as SYSDBA
SQL> spool text102_install.txt
SQL> @?/ctx/admin/catctx.sql CTXSYS SYSAUX TEMP NOLOCK

Then you have to log in as the ctxsys user and execute the script that defines language-specific default preferences. For U.S. English this would be

SQL> connect CTXSYS/ctxsys@tns_alias
SQL> @?/ctx/admin/defaults/drdefus.sql

After you finish the install, you should expire and lock the ctxsys account. At a minimum you should change the ctxsys password - the password defaults to "ctxsys", which is extremely insecure.

Note 979705.1 also contains a script to verify that Oracle text was installed successfully, plus deinstallation instructions. Please log into

http://www.support.oracle.com

and read note 979705.1 for further details.

 

[karluk]

The XML DB installation instructions are in Oracle support note 243554.1 - How to Deinstall and Reinstall XML Database. Since you don't currently have XML DB installed, you should be able to skip the deinstall steps and proceed immediately with the reinstall. The steps are

1. Log in as sys and run the catqm.sql script in $ORACLE_HOME/rdbms/admin supplying as parameters the XDB user password, the XDB user's default tablespace (which you must create prior to running catqm.sql), and the XDB user's temporary tablespace. For example

SQL> set echo on 
SQL> spool xdb_install.log 
SQL>@?/rdbms/admin/catqm.sql XDB XDB TEMP

2. Log in as sys and load the XDB Java library.

SQL>@?/rdbms/admin/catxdbj.sql

3. Set the initialization parameter "dispatchers" and (if necessary) "local_listener". Use the settings of your existing XML DB enabled database as a model.

alter system set dispatchers="(PROTOCOL=TCP) (SERVICE=<SID>XDB)" scope = spfile.

4. Check for invalid objects in the XDB schema. You are looking for a count of zero.

select count(*) from dba_objects where owner='XDB' and status='INVALID';

5. Check the status of the XDB component in dba_registry.

select comp_name, status, version from DBA_REGISTRY where comp_name='Oracle XML Database'

6. Shut down and restart your database and listener.