-
How to reduce TNS Timed out operation lag
I dont have RAC , but using FALOVER option to route connection.
Got the FAILOVER=ON , LOADBALANCE = OFF in the tnsnames.ora file,
tested with primary's listener down,db down ...takes about extra 1sec to connect, which is fine. but when Node is unreacheable the switch takes 20secs extra.
I am looking to see how.
tried with sqlnet.ora
SQLNET.INBOUND_CONNECT_TIMEOUT = 1
SQLNET.RECV_TIMEOUT = 1
notworking.
please suggest.
-
can your tcp timeouts on the os
-
thanks for the reply,
i tried TcpMaxDataRetransmissions ( Hkey_local_machine\system\currentcontrolset\services\tcpip\parameters) , rebooted , still no luck.
Update : tried with InitialRtt value too...no luck
Last edited by sanju_dba; 01-29-2008 at 01:37 PM.
-
Hi
Can you post your tnsnames.ora file.
I am not sure i understood your question properly though.
regards
Hrishy
-
here it is...
Xx_xxxxx5 =
(description =
(failover = True )
(load_balance = False )
(address_list =
(address = (protocol = Tcp)(host = Xxx.xxx.xx.185)(port = 5000))
(address = (protocol = Tcp)(host = Xxx.xxx.xx.195)(port = 5000))
)
(connect_data =
(sid = Xyz1)
(server = Shared)
)
)
-
Hi
I am not quite sure your tnsnames file is right.
failover = ON
you should also be using service names instead of SID
SERVICE_NAME=
can you please rephrase your question i am still clueless what your original question is.
regards
Hrishy
-
The Description works perfectly ok.
it does a smooth failover in two cases ( case1 when listener is down , case2 when db is down ), it also works in third case with a timedelay of 20seconds ,ie when the primary node is down.
I am trying to cut down the default timeout ( os side or oracle side ) so that the failover should happen immediatly without adding the timeout cushion time.
Lets say....
two databases Adb , Bdb running on Aserver and Bserver respectively.
you make Adb as primary and Bdb as failover.
When Aserver is not available then the client waits for 20seconds and then connects to Bdb.
How can i reduce 20seconds to 1second.( or any lesser value ).
Thanks!
Last edited by sanju_dba; 01-29-2008 at 01:35 PM.
-
Hi
I am not sure 1 sec is feasible.
You might try adding to the tnsnames.ora and see what hapens
(RETRIES=1)(DELAY=1)
regards
Hrishy
-
Thanks for the reply.
thats not working either ( its part of the TAF option goes along with FAILOVER_MODE ).
-
Hi
You should have your tnsnames.ora something like this
Code:
GRID =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = my.db1.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = my.db2.com)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVICE_NAME = grid)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 1)
(DELAY = 1) )
)
)
can you show me your tnsnames like above ?
What version of oracle is ths ?
regards
Hrishy
Last edited by hrishy; 01-30-2008 at 04:03 AM.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|