Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ora-12170 TNS:connect timeout occured

420123Jan 8 2009 — edited Jan 9 2009
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 6 2009
Added on Jan 8 2009
3 comments
957 views