2 Replies Latest reply: Oct 14, 2014 2:02 AM by Carlo den Otter RSS

    TAF (Failover configuration) in tnsnames.ora of EBSR12 apps tier

    2648446

      Dear All,

       

      I am trying to do configuration of TAF in tnsnames.ora of EBSR12 apps tier . So , below are the  configuration I have done and my environment details as well.

       

      Environment details :

       

      Apps tier     =       2 nodes   (Shared Appl_top with PCP configuration)

       

      DB tier        =       2 nodes    (11.2.0.3 RAC configured)

       

      TAF configuration in tnsnames.ora of Apps tier :

       

      From db node service MIGRSRV1 configured.

       

      [oramigr@ebsr12 ~]$ srvctl config service -d migr -s MIGRSRV1

      Service name: MIGRSRV1

      Service is enabled

      Server pool: migr_MIGRSRV1

      Cardinality: 2

      Disconnect: false

      Service role: PRIMARY

      Management policy: AUTOMATIC

      DTP transaction: false

      AQ HA notifications: true

      Failover type: SELECT

      Failover method: BASIC

      TAF failover retries: 180

      TAF failover delay: 5

      Connection Load Balancing Goal: LONG

      Runtime Load Balancing Goal: NONE

      TAF policy specification: BASIC

      Edition:

      Preferred instances: MIGR1,MIGR2

      Available instances:

       

      ++++++++++++++++++++++++++++++++++++++++++++++++++

       

      MIGR=

              (DESCRIPTION=

                  (ADDRESS_LIST=

                      (LOAD_BALANCE=YES)

                      (FAILOVER=YES)

                      (ADDRESS=(PROTOCOL=tcp)(HOST=172.22.12.51)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=172.22.12.52)(PORT=1521))

                      (ADDRESS=(PROTOCOL=tcp)(HOST=172.22.12.53)(PORT=1521))

                  )

                  (CONNECT_DATA=

                      (SERVICE_NAME=MIGRSRV1)

                      (FAILOVER_MODE =

                      (TYPE = SELECT)

                      (METHOD = BASIC))

                  )

              )

      ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      [applmigr@ebsr12 admin]$ echo $TWO_TASK

      MIGR

      +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

      [applmigr@ebsr12 admin]$ sqlplus test/test123@MIGR

       

       

      SQL*Plus: Release 10.1.0.5.0 - Production on Mon Aug 11 09:26:07 2014

       

       

      Copyright (c) 1982, 2005, Oracle.  All rights reserved.

       

       

       

       

      Connected to:

      Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

      With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,

      Data Mining and Real Application Testing options

       

       

      SQL> select instance_name,status from v$instance;

       

       

      INSTANCE_NAME    STATUS

      ---------------- ------------

      MIGR1            OPEN

       

       

      SQL> select count(*) from emp;   ---- (After executing this select statement parallely I stopped MIGR1 instance to check TAF , but it's  not worked)

      select count(*) from emp

                           *

      ERROR at line 1:

      ORA-01089: immediate shutdown in progress - no operations are permitted

       

      +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

       

      Please suggest me where I have to do correct configuration to get the feature TAF.

       

      Thank you.

       

      Regards,

      Firoz Hussain.