And maybe also tracert - yes that's what it is called on WINDOWS :)
From: Pande, Rajendra
Sent: Tuesday, December 01, 2015 10:28 AM
To: 'srcdco@xxxxxxx'; Brian.Zelli@xxxxxxxxxxxxxxx; oracle-l
(oracle-l@xxxxxxxxxxxxx)
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Scott Canaan
Sent: Tuesday, December 01, 2015 10:02 AM
To: Brian.Zelli@xxxxxxxxxxxxxxx<mailto:Brian.Zelli@xxxxxxxxxxxxxxx>; oracle-l
(oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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@xxxxxxx<mailto:srcdco@xxxxxxx>)
(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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian
Sent: Tuesday, December 01, 2015 9:27 AM
To: oracle-l (oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>)
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.
Please visit our website at
http://financialservicesinc.ubs.com/wealth/E-maildisclaimer.html
for important disclosures and information about our e-mail
policies. For your protection, please do not transmit orders
or instructions by e-mail or include account numbers, Social
Security numbers, credit card numbers, passwords, or other
personal information.
