Linking Oracle features

To turn Real Application Testing (RAT) ON, I need to re-link oracle executables with "rat_on" option/flag.

Here are the quick steps -

1. Shutdown Instance
2. Shutdown Listener and EM
3. Run the make file in $ORACLE_HOME/rdbms/lib/

# ls -l *.mk
-rw-r--r--   1 oracle   oinstall  107073 Nov  7  2008 env_rdbms.mk
-rw-r--r--   1 oracle   oinstall   27158 Nov  7  2008 ins_rdbms.mk

# /usr/ccs/bin/make -f ins_rdbms.mk rat_on ioracle

The make file will save the existing version in $ORACLE_HOME/bin appending a 'O' at the end (could be deleted later if there is a disk space pressure) -

# ls -l oracle*
-rwsr-s--x   1 oracle   oinstall 129141416 Dec  1 06:05 oracle
-rwsr-s--x   1 oracle   oinstall 129141416 Nov 17 04:05 oracleO

4. Start Instance and other services.

That's it!

There is another thing with 'relink' that might be needed in the following circumstances -

* New installation failed in relinking phase
* After OS upgrade
* Changes made to the OS system libraries
* Oracle patch applied with explicit relink instruction

"relink" command is available from $ORACLE_HOME/bin and "relink" takes the following parameters values -

all, oracle, network, client, client_sharedlib, interMedia, precomp, utilities, oemagent


From Oracle - 
http://download.oracle.com/docs/cd/B19306_01/server.102/b15658/cnfg_prd.htm#CHDECBHC


This is a sophisticated one, it could damage Oracle installations if not done properly!

***