OraFAQ Forum: Networking and Gateways » Ora-12170 Connection time out

Home » RDBMS Server » Networking and Gateways » Ora-12170 Connection time out (oracle 10g client)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Ora-12170 Connection time out [message #277453]

Tue, 30 October 2007 03:29

rekhau
Messages: 4
Registered: October 2007

Junior Member

Hi,
There are 2 machines on which oracle client is installed.
Both the machines are in LAN & both have no firewall drops.
The strange problem here is one is able to connect to one particular server while the other gets Ora-12170 Connection time out error.
The listener.ora,tnsnames.ora & sqlnet.ora files are same.
Even SQLNET.SEND_TIMEOUT ,sqlnet.inbound_connect_timeout &
SQLNET.RECV_TIMEOUT are also set to high values.
Could someone explain what could be cause.

Report message to a moderator

Re: Ora-12170 Connection time out [message #277460 is a reply to message #277453]

Tue, 30 October 2007 04:03

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Have you tried with IP address instead of host name?

Report message to a moderator

Re: Ora-12170 Connection time out [message #277467 is a reply to message #277460]

Tue, 30 October 2007 04:35

rekhau
Messages: 4
Registered: October 2007

Junior Member

We are using ipnames & not host names

Report message to a moderator

Re: Ora-12170 Connection time out [message #278430 is a reply to message #277453]

Sun, 04 November 2007 01:31

gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen

Senior Member

1)as a first step try PING the server with IP address
2)If it works , metion same IP address in tnsnames.ora and try
3)Make sure firewall is OFF on the target server
4)If possible go to firewal settings are enable all sqlplus connetions , mention port aswel ..

Regards

Report message to a moderator

Previous Topic:	Connection error
Next Topic:	Help! ORA 0040 and 28511

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat May 03 02:24:11 CDT 2025