RE: ora-12170
Date: Tue, 1 Dec 2015 18:50:09 +0000
Message-ID: <DM2PR12MB0314DF2254F1213C724C660BF40F0_at_DM2PR12MB0314.namprd12.prod.outlook.com>
Is there anything special about Windows 10 that I need to worry about? I follow the instructions for loading the instant client form the oracle site, adding the ODBC connection and creating a network/admin directory in the instant client directory and include a tnsnames and sqlnet file. I click on installing the odbc in the instant client directory as well. With other OS's such as windows 7 or 8 this works no problem. I also modify the environment variables on the pc by creating an oracle_home and tns_admin entry. I also add the ORACLE_HOME path to the PATH variable as well.
Brian
From: rajendra.pande_at_ubs.com [mailto:rajendra.pande_at_ubs.com] Sent: Tuesday, December 01, 2015 10:28 AM To: srcdco_at_rit.edu; Zelli, Brian; oracle-l_at_freelists.org Subject: RE: ora-12170
I would also be interested in seeing output of a simple ping of the db host from the pc client Can you then also test a telnet/ssh connection
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Scott Canaan Sent: Tuesday, December 01, 2015 10:02 AM To: Brian.Zelli_at_RoswellPark.org<mailto:Brian.Zelli_at_RoswellPark.org>; oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: RE: ora-12170
In our case, 99% of the time it's simply that the PCs IP isn't in the firewall to access the database.
Scott Canaan '88 (srcdco_at_rit.edu<mailto:srcdco_at_rit.edu>)
(585) 475-7886 - work (585) 339-8659 - cell"Life is like a sewer, what you get out of it depends on what you put into it." - Tom Lehrer
From: oracle-l-bounce_at_freelists.org<mailto:oracle-l-bounce_at_freelists.org> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zelli, Brian Sent: Tuesday, December 01, 2015 9:27 AM To: oracle-l (oracle-l_at_freelists.org<mailto:oracle-l_at_freelists.org>) Subject: ora-12170
I have a user who wants to connect from Access to Oracle. We created the System DSN for the connection. I am using the instant client for 12 on this machine. But when we test the connection or try and open it thru Access, we get ORA-12170 error, TNS: Connect timeout occurred. I've used this setup several times before without issue so what could be holding up this one pc? I googled and keep getting This may be a result of network or system delays; or this may indicate that a malicious client is trying to cause a Denial of Service attack on the server type messages......
Brian
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
This email message may contain legally privileged and/or confidential information. If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited. If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Dec 01 2015 - 19:50:09 CET