2 Replies Latest reply: Nov 2, 2012 2:58 PM by Pranav S RSS

    Application Failover Fails when rebooting one of the node

    Pranav S
      Hi Gurus,

      I was wondering if anyone can help me with this.

      I have 2 node RAC setup, and few services(TAF) setup.

      When I stop one instance on say Node 1, all new connection gets established to Node 2, but if I reboot Node 1, it does not fail-over to Node 2 automatically.

      Looks like when rebooting, the cluster services does not know, where to fail-over.

      I will provide more info as and when requested.

      Environment:_
      Oracle Clusterware version is 11.2.0.2.0
      Database Database 11g Release 11.2.0.2.0 - 64Bit Production with RAC and ASM
      Windows Server 2008R2 ENT SP1

      Thanks,
      Pranav

      Edited by: Pranav S on Nov 2, 2012 2:45 PM
        • 1. Re: Application Failover Fails when rebooting one of the node
          415289
          Pranav S wrote:
          Hi Gurus,

          I was wondering if anyone can help me with this.

          I have 2 node RAC setup, and few services(TAF) setup.

          When I stop one instance on say Node 1, all new connection gets established to Node 2, but if I reboot Node 1, it does not fail-over to Node 2 automatically.

          Looks like when rebooting, the cluster services does not know, where to fail-over.

          I will provide more info as and when requested.

          Environment:_
          Oracle Clusterware version is 11.2.0.2.0
          Database Database 11g Release 11.2.0.2.0 - 64Bit Production with RAC and ASM
          Windows Server 2008R2 ENT SP1
          Is it configured properly ?
          check
          srvctl config service -d <DB_NAME>
          • 2. Re: Application Failover Fails when rebooting one of the node
            Pranav S
            Hi,

            Below is the output of
            srvctl config service -d <DBNAME>

            Service name: irisapps
            Service is enabled
            Server pool: prod11grac_irisapps
            Cardinality: 2
            Disconnect: false
            Service role: PRIMARY
            Management policy: AUTOMATIC
            DTP transaction: false
            AQ HA notifications: false
            Failover type: NONE
            Failover method: NONE
            TAF failover retries: 0
            TAF failover delay: 0
            Connection Load Balancing Goal: LONG
            Runtime Load Balancing Goal: NONE
            TAF policy specification: BASIC
            Edition:
            Preferred instances: PROD11gR1,PROD11gR2
            Available instances:
            Service name: IRISAPPS_TAF
            Service is enabled
            Server pool: prod11grac_IRISAPPS_TAF
            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: PROD11gR1,PROD11gR2
            Available instances:
            Service name: irisbatch
            Service is enabled
            Server pool: prod11grac_irisbatch
            Cardinality: 1
            Disconnect: false
            Service role: PRIMARY
            Management policy: AUTOMATIC
            DTP transaction: false
            AQ HA notifications: false
            Failover type: NONE
            Failover method: NONE
            TAF failover retries: 0
            TAF failover delay: 0
            Connection Load Balancing Goal: LONG
            Runtime Load Balancing Goal: NONE
            TAF policy specification: NONE
            Edition:
            Preferred instances: PROD11gR2
            Available instances:
            Service name: irisjobs
            Service is enabled
            Server pool: prod11grac_irisjobs
            Cardinality: 1
            Disconnect: false
            Service role: PRIMARY
            Management policy: AUTOMATIC
            DTP transaction: false
            AQ HA notifications: false
            Failover type: NONE
            Failover method: NONE
            TAF failover retries: 0
            TAF failover delay: 0
            Connection Load Balancing Goal: LONG
            Runtime Load Balancing Goal: NONE
            TAF policy specification: NONE
            Edition:
            Preferred instances: PROD11gR1
            Available instances: