connect time out
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 8 of 8

Thread: connect time out

  1. #1
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Lightbulb

    Hi
    I am trying to connect to one of the servers in usa having win 2000 server running oracle 8.1.7. from india running same version of oracle on win nt.I have configured the listener file and the tnsnames.But when ever i tried to connect to the usa server i get an error connect time out.I hava also set the connect_timeout_interval parameter in the listener file to 0.Could any one help me on this i would really appericate it.

    thanks in advance

    regards
    anandkl

    anandkl

  2. #2
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Originally posted by anandkl
    Hi
    I am trying to connect to one of the servers in usa having win 2000 server running oracle 8.1.7. from india running same version of oracle on win nt.I have configured the listener file and the tnsnames.But when ever i tried to connect to the usa server i get an error connect time out.I hava also set the connect_timeout_interval parameter in the listener file to 0.Could any one help me on this i would really appericate it.

    thanks in advance

    regards
    anandkl

    CONNECT_TIMEOUT_listener_name sets the number of seconds that the listener waits for the server process to get a valid query after session startup. Setting it to 0 sounds odd to me. Why 'connect_timeout_interval'? I assume your listener is not called 'interval' :-)




  3. #3
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    i think this is a common connection prob.

    there are a few steps u need to take to verify juz IP connectivity.

    1)Firewall (ensure the listener port that u are using are opened)
    2)Chk ur TNSNAMES.ora on client as well as listener.ora on server end (make
    sure u start up the correct listener on the server)
    3)perform an equivalent PING using oracle's TNSPING on the remote server assumming
    the normal OS PING has +ve reply from the remote server.
    4)Chk on the listener trace log on server end
    5)chk on the sqlnet log file on client end.

    if u follow thru' the above steps, u shld be able to solve ur prob.
    ngwh,
    Singapore.

  4. #4
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Lightbulb

    hi ngwh,
    Thanks for your reply,i have checked all the steps you have mentioned and i have done them but still i have the same problem,operation time out.Even the tnsping says operation time out
    anandkl

  5. #5
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    how abt your OS PING?? if that is ok u doubt chk on your
    firewall make sure the required port is OPENED ...i sincerely believe
    it has somethg to do with your configuration and listener probably started.
    How do u setup ur listener? it's safer to do it thru the netassist ..ie
    ngwh,
    Singapore.

  6. #6
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840

    Lightbulb

    Hi ngwh
    the os ping is replying.But the tnsping is timing out.I have configured the listener through net assistant and my listener is runing sucessfully.
    anandkl

  7. #7
    Join Date
    Jul 2001
    Location
    Singapore(Asia)-WebCentre business company
    Posts
    456
    i think this narrow down to your firewall policies...hv u doubt chk on that? to allow
    port 1521(default) over your server end?
    ngwh,
    Singapore.

  8. #8
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    hi ngwh
    I shall re-check for the port on the fire wall
    anandkl

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