Monday, May 28, 2012

Bouncing the Oracle Applications in Multi-node environment Configured with LOAD BALANCING,SHARED_APPL TOP and RAC setup


Hi DBAs,
Below are the steps to Bounce the Oracle Applications in SHARED_APPL TOP environment:

Consider we have the application  APPS_TESTAPPS.

Note:This is done in Oracle EBS R12 Environment where we have $ADMIN_SCRIPTS_HOME a common place where you find all the start and stop scripts .

Step1)Stopping the apps listener on node1 and node2
==========================================================
 
a) stop apps listener on node1:

=>APPS_TESTAPPS
node1/product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/admin/scripts >./adalnctl.sh stop

adalnctl.sh version 120.3

Shutting down listener process APPS_TESTAPPS.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/logs/appl/admin/log/adalnctl.txt for more information ...

b)Stop apps listener on node2:

node2 /product/app/TESTAPPS/inst/apps/TESTAPPS1_node2/admin/scripts >./adalnctl.sh stop

adalnctl.sh version 120.3

Shutting down listener process APPS_TESTAPPS.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /product/app/TESTAPPS/inst/apps/TESTAPPS1_node2/logs/appl/admin/log/adalnctl.txt for more information .


Step 2:We stop all the Middle tier or Oracle applications service on node1....
==============================================================================

node1/product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/admin/scripts >./adstpall.sh

Step 3:We stop all the Middle tier or Oracle applications service on node2....
==========================================================================

node2/product/app/TESTAPPS/inst/apps/TESTAPPS2_node2/admin/scripts >./adstpall.sh


step 4): Kill all processes by finding the TESTAPPS processes:
==============================================================

node 1:
ps -ef|grep TESTAPPS

kill -9 pid.

node 2:
ps-ef|grep TESTAPPS

kill -9 pid


Step 5: Start apps listener on node1 and node2
================================================


Node 1:
 node1/product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/admin/scripts >./adalnctl.sh start

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_TESTAPPS.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/logs/appl/admin/log/adalnctl.txt for more information ...

Node 2:

node2 /product/app/TESTAPPS/inst/apps/TESTAPPS1_node2/admin/scripts >./adalnctl.sh start

adalnctl.sh version 120.3

Checking for FNDFS executable.
Starting listener process APPS_TESTAPPS.

adalnctl.sh: exiting with status 0


adalnctl.sh: check the logfile /product/app/TESTAPPS/inst/apps/TESTAPPS1_node2/logs/appl/admin/log/adalnctl.txt for more information ...

If we have started the concurrent managers from the primary node,than make sure they are up on both the nodes and rename the adcmctl.sh script on both the primary and secondary nodes as adcmctl_bk.sh.Now start the middle Tier applications on both the nodes.


Step 6:Start all the middle Tier or Oracle Applications from node1.....
======================================================================================



node1/product/app/TESTAPPS/inst/apps/TESTAPPS1_node1/admin/scripts >./adstrall.sh

Step 7:Start all the middle Tier or Oracle Applications from node2.....
======================================================================================



node2/product/app/TESTAPPS/inst/apps/TESTAPPS2_node1/admin/scripts >./adstrall.sh

Step 8:Verify the applications of TESTAPPS started on both the nodes.
=======================================================


Node 1:

ps -ef|grep TESTAPPS

Node 2:

ps -ef|grep TESTAPPS

Hope it helps...

Enjoy Apps DBA learning....



Best regards,

Rafi.









2 comments:

  1. really its amazing oracledba blog.please keep it up your work.and my blog is
    http://oracledbainsane.blogspot.in/

    ReplyDelete
  2. Thanks Bala for Sharing your views...

    I will check your blog too :)

    Best regards,

    Rafi.

    ReplyDelete