5.1b kit 4 TruCluster clusteralias resolution question

From: jeffrey.s.horvath@census.gov
Date: Fri Aug 06 2004 - 11:02:15 EDT

• Next message: Michael W: "San Performance on tru64 5.1b"
• Previous message: Adametz, Bluejay: "UPDATE[2]: KZPAC/SWXCR with V5.1B pk4"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

Have a Oracle RAC 9.2.0.4 configuration under 5.1b kit 4 two node cluster.
TAF (Transparent application failover) works fine when one listener goes
down. Problem is when NODE goes down, the clusteralias subsystem takes
74-75 sec to route listener connection . How can I shorten this routing
interval?

Here is tnsnames.ora file . Listener uses 1527 socket. the
/etc/clua_services has no entry meaning default of in_single is used.
Don't believe this requires adjustment. SImple put, listener connection
tries csbt05 service on 1527, when connection fails csbt06 gets tried and
succeeds but after 75 sec when csbt05 node is down.

Any suggestions on speeding up the connection failover? Thanks

hrpsy1 =
  (DESCRIPTION =
    (FAILOVER=ON)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = csbt05.csvd.census.gov)(PORT =
1527))

    )
    (CONNECT_DATA =
      (ORACLE_SID = hrpsy1)
      (FAILOVER_MODE=(BACKUP=hrpsy2)(TYPE=select)(METHOD=preconnect))
    )
  )

hrpsy =
  (DESCRIPTION =
    (FAILOVER=ON)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = csbt05.csvd.census.gov)(PORT =
1527))
      (ADDRESS = (PROTOCOL = TCP)(HOST = csbt06.csvd.census.gov)(PORT =
1527))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = hrpsy.world)
    )
  )

hrpsy2 =
  (DESCRIPTION =
    (FAILOVER=ON)
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = csbt06.csvd.census.gov)(PORT =
1527))
    )
    (CONNECT_DATA =
      (ORACLE_SID = hrpsy2)
      (FAILOVER_MODE=(BACKUP=hrpsy1)(TYPE=select)(METHOD=preconnect))
    )
  )

Found SUN parameters on Metalink but do these translate into Tru64
parameters and would adjusting these help?

tcp_ip_abort_cinterval 1000 (was 180000)
tcp_rexmit_interval_initial 200 (was 3000)
tcp_rexmit_interval_max 5000 (was 60000)

• Next message: Michael W: "San Performance on tru64 5.1b"
• Previous message: Adametz, Bluejay: "UPDATE[2]: KZPAC/SWXCR with V5.1B pk4"
• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]

This archive was generated by hypermail 2.1.7 : Sat Apr 12 2008 - 10:50:06 EDT