Hello There, Guest! RegistrateRegister La Hora Current time: 10-26-2014, 04:56 AM

Welcome to ORAERP.com Social Community. A community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. "If we would have new knowledge, we must get a whole world of new questions.
23-09-14: Already Registered Members: Please use 'User Name' for Log-In, due to upgrade of new forum version, we have faced bug which is not allowing to log-in with email
Oracle Forum, Tutorials, eBooks Post a question relating to set-up, development or support
Come and join the Oracle forum - the big Oracle discussion!


Enable AutoConfig on Applications Database Tier
Views 2676
Replies 0
Thread Rating:
  • 11 Vote(s) - 2.55 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Users browsing this thread: 1 Guest(s)
#1

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.

[Image: AAAAABJRU5ErkJggg==]


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


Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Convert 11gR2 non-RAC database to RAC database using rconfig abdulrehman 0 3,155 01-23-2012, 05:11 PM
Last Post: abdulrehman
  VALIDATE DATABASE command admin 0 1,194 12-08-2010, 04:13 AM
Last Post: admin


Users browsing this thread: 1 Guest(s)
Get Oracle Tutorials, Tips! Post a Question!