Home » RDBMS Server » Networking and Gateways » Ora-12170 Connection time out (oracle 10g client)
Ora-12170 Connection time out [message #277453] Tue, 30 October 2007 03:29 Go to next message
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.
Re: Ora-12170 Connection time out [message #277460 is a reply to message #277453] Tue, 30 October 2007 04:03 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Have you tried with IP address instead of host name?
Re: Ora-12170 Connection time out [message #277467 is a reply to message #277460] Tue, 30 October 2007 04:35 Go to previous messageGo to next message
rekhau
Messages: 4
Registered: October 2007
Junior Member
We are using ipnames & not host names
Re: Ora-12170 Connection time out [message #278430 is a reply to message #277453] Sun, 04 November 2007 01:31 Go to previous message
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
Previous Topic: Connection error
Next Topic: Help! ORA 0040 and 28511
Goto Forum:
  


Current Time: Fri Dec 02 21:08:39 CST 2016

Total time taken to generate the page: 0.07635 seconds