Enable AutoConfig on Applications Database Tier

[abdulrehman]

Enable AutoConfig on Applications Database Tier

Steps to Perform On All Oracle RAC Nodes

1> Execute $AD_TOP/bin/admkappsutil.pl on the applications tier to generate an
appsutil.zip file for the database tier.




2> Copy (e.g. via ftp) the appsutil.zip file to the database tier in the 11gR2_ORACLE_HOME

On linux1


On linux2



3> Unzip the appsutil.zip file to create the appsutil directory in the 11gR2_ORACLE_HOME

unzip appsutil (on linux1 and linux2)

4> Copy the jre directory from SOURCE_ORACLE_HOME>/appsutil to
11gR2_ORACLE_HOME>/appsutil.
On linux1


On linux2

5. Create a <CONTEXT_NAME> directory under <11gR2_ORACLE_HOME>/network/admin. Use
the new instance name while creating the context directory. For example, if your database name
is VISRAC, and you want to use "vis" as the instance prefix, create the <CONTEXT_NAME>
directory as vis1_<hostname>.


7. Set the following environment variables:

ORACLE_HOME =<11gR2_ORACLE_HOME>
LD_LIBRARY_PATH = <11gR2_ORACLE_HOME>/lib,
<11gR2_ORACLE_HOME>/ctx/lib
ORACLE_SID = <instance name for current database node>
PATH= $PATH:$ORACLE_HOME/bin;
TNS_ADMIN = $ORACLE_HOME/network/admin/<context_name>

export ORACLE_HOME =
/d01/oracle/app/oracle/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH = $ORACLE_HOME/lib:$ORACLE_HOME/ctx/lib
ORACLE_SID = RACDB1
export PATH= $PATH:$ORACLE_HOME/bin;
export TNS_ADMIN = $ORACLE_HOME/network/admin/racdb1_linux1

8> Copy the tnsnames.ora file from $ORACLE_HOME/network/admin to the $TNS_ADMIN
directory, and edit the aliases for SID=<new RAC instance name>.


9. As the APPS user, run the following command on the primary node to de-register the
current configuration:

SQL>exec fnd_conc_clone.setup_clean;

PL/SQL procedure successfully completed.

10. From the 11gR2 ORACLE_HOME/appsutil/bin directory, create an instance-specific XML
context file by executing the command:

cd $ORACLE_HOME/appsutil/bin

perl adbldxml.pl appsuser=apps appspass=apps

nCopy tnsnames.ora and listener.ora from Source ORACLE Home

cd /d01/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/RACDB_linux1

modify listener.ora as follows


Perform the same on linux2