Client delay using MC/SG RAC

[Brian Tierney_1]

Running HP/SG A.11.16 on HP-UX 11.11 (pa-risc) with RAC using Oracle DB 9.2.0 on a two
node (rp4440's) cluster. We are not using the Oracle Failsafe product or Oracle TAF. We
are unsatisfied with a delay (consistantly 22 seconds) that incurs during a client
connection to the Oracle database under a certain condition. The condition exists when we shutdown the package that runs on the first server defined within the tnsnames.ora file and make an attempt to connect to the oracle database. The connection succeeds to the secondary node after 22 seconds. I believe everything is working as defined but I want to know how to cut the 22 seconds down to a much lower number.

What I believe is occurring is that the communication between the client and the network (?) just takes 22 seconds to determine that the ip is not available and for the client to use the second defined location (ip) within the tnsnames.ora.

The package controls both the startup of the database instance and the listener. We used
HPs purchased SG toolkit to help define the package. The ip assigned to the package does
not move to a surviving node since this is a RAC cluster and the package does not move to
a surviving node.

I modified tcp_ip_abort_cinterval (from 75000 to 1000), tcp_rexmit_interval_initial (from
3000 to 200) and tcp_rexmit_interval_max (from 60000 to 5000) on the server that has the package shutdown. The 22 second delay still existed.

When I add the ip of the package that is down to the second node defined within tnsnames.ora the 22 second delay is gone and we are within our acceptable range.

I am thinking about modifying the serviceguard package to make the ip float between the hosts only for the first defined server within the tnsnames.ora.

Do you have any suggestions on how to reduce the delay other than modifying the existing
serviceguard packages?

[Julio Yamawaki]

Hi,

It seems that you have a problem in configuring your client.
Can you send your client's tnsnames.ora?

[Brian Tierney_1]

Here is the tnsnames.ora:

################
LISTENER_IPSHR.DC2=
(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=IPSHR1.dc2.companyx.com)(PORT=1532))
(ADDRESS=(PROTOCOL=TCP)(HOST=IPSHR2.dc2.companyx.com)(PORT=1542))
)
)
################
IPSHR.DC2.companyx.COM=
(DESCRIPTION=
(LOAD_BALANCE=ON)
(FAILOVER=ON)
(ADDRESS_LIST=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR1.dc2.companyx.com)
(PORT=1532)
)
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR2.dc2.companyx.com)
(PORT=1542)
)
)
(CONNECT_DATA=
(SERVICE_NAME=IPSHR.DC2.companyx.COM)
)
)
################
IPSHR1.DC2.companyx.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR1.dc2.companyx.com)
(PORT=1532)
)
(CONNECT_DATA=
(SERVICE_NAME=IPSHR.DC2.companyx.COM)
(INSTANCE_NAME=IPSHR1)
)
)
################
IPSHR2.DC2.companyx.COM=
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR2.dc2.companyx.com)
(PORT=1542)
)
(CONNECT_DATA=
(SERVICE_NAME=IPSHR.DC2.companyx.COM)
(INSTANCE_NAME=IPSHR2)
)
)
################
LISTENER_IPSHR1.DC2.companyx.COM =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR1.dc2.companyx.com)
(PORT=1532)
)
)
################
LISTENER_IPSHR2.DC2.companyx.COM =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR2.dc2.companyx.com)
(PORT=1542)
)
)
################
LISTENER_IPSHR1.DC2 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR1.dc2.companyx.com)
(PORT=1532)
)
)
################
LISTENER_IPSHR2.DC2 =
(DESCRIPTION=
(ADDRESS=
(PROTOCOL=TCP)
(HOST=IPSHR2.dc2.companyx.com)
(PORT=1542)
)
)