connect time out

[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

[julian]

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

[ngwh]

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.

[anandkl]

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

[ngwh]

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

[anandkl]

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.

[ngwh]

i think this narrow down to your firewall policies...hv u doubt chk on that? to allow
port 1521(default) over your server end?

[anandkl]

hi ngwh
I shall re-check for the port on the fire wall