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

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


      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    ( 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


      Preferred instances: MIGR1,MIGR2

      Available instances:















                      (FAILOVER_MODE =

                      (TYPE = SELECT)

                      (METHOD = BASIC))




      [applmigr@ebsr12 admin]$ echo $TWO_TASK



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



      SQL*Plus: Release - 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 - 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;




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

      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.



      Firoz Hussain.