ora-12170 TNS:connect timeout occured
420123Jan 8 2009 — edited Jan 9 2009Hi
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