Home » RDBMS Server » Networking and Gateways » ora-12170 TNS:connect timeout occured (Oracle 10g client on Vista)
ora-12170 TNS:connect timeout occured [message #379901] Thu, 08 January 2009 05:14 Go to next message
Karen99
Messages: 1
Registered: November 2006
Junior Member
Hi

I have Oracle 10g database on a XP pc and it is working fine. Now I have installed Oracle 10g client on a Vista pc. When I try to connect to the database on the XP pc from the Vista (client) pc, I get the following error : Ora-12170 TNS:connect timeout occured.

I added the following parameters to my listener.ora on the XP (database) pc : INBOUND_CONNECT_TIMEOUT_LISTENER=300
I also addes the following parameter to my sqlnet.ora on both pc's : SQLNET.INBOUND_CONNECT_TIMEOUT=360

If I telnet the xp (databasis) pc, every thing works fine.

If I telnet the vista (client) pc, I get the following error : could not open connection to the host, on port 1521

I added port 1521 to my windows firewall as an exception on the vista (client) pc. Still does not want to work. So I just switched the firewall completely off. Still does not want to work.

If I tnsping the xp listener from vista pc, it sees it and works fine. So it sees the listener.

What now? Any suggestions?

Karen
Re: ora-12170 TNS:connect timeout occured [message #380077 is a reply to message #379901] Fri, 09 January 2009 01:01 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

Verify that your hosts file "win/system32/driver/etc/" has the entry

your_server_ip_address your_server_full_name
Re: ora-12170 TNS:connect timeout occured [message #380081 is a reply to message #380077] Fri, 09 January 2009 01:04 Go to previous message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Quote:
If I tnsping the xp listener from vista pc, it sees it and works fine. So it sees the listener.



>>your_server_ip_address your_server_full_name

Are you sure it's related to IP or server name problem?


Babu


Previous Topic: ora-01017
Next Topic: directory service exception
Goto Forum:
  


Current Time: Fri Dec 02 22:35:02 CST 2016

Total time taken to generate the page: 0.13771 seconds