DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 12

Thread: How to reduce TNS Timed out operation lag

  1. #1
    Join Date
    Jan 2002
    Posts
    59

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    can your tcp timeouts on the os

  3. #3
    Join Date
    Jan 2002
    Posts
    59
    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.

  4. #4
    Join Date
    Jan 2001
    Posts
    2,828
    Hi

    Can you post your tnsnames.ora file.

    I am not sure i understood your question properly though.

    regards
    Hrishy

  5. #5
    Join Date
    Jan 2002
    Posts
    59

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

  6. #6
    Join Date
    Jan 2001
    Posts
    2,828
    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

  7. #7
    Join Date
    Jan 2002
    Posts
    59
    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.

  8. #8
    Join Date
    Jan 2001
    Posts
    2,828
    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

  9. #9
    Join Date
    Jan 2002
    Posts
    59
    Thanks for the reply.
    thats not working either ( its part of the TAF option goes along with FAILOVER_MODE ).

  10. #10
    Join Date
    Jan 2001
    Posts
    2,828
    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
  •  


Click Here to Expand Forum to Full Width