0

THIS IS NOT A DUPLICATE!!!

I am receiving the below:

ORA-12170: TNS:Connect timeout occurred when trying to connect to a database using sqlplus from one server to another.

tnsping for the connect alias works, no issues.

telnet using the cluster alias and the listener port in the tns entry works fine.

Just trying to actually connect via sqlplus results in a time out

I don't suspect the firewall, because like I say, telnet works.

This is a 3 node RAC.

Any ideas what might be stopping the connection?

(I have searched this site and others and there is no suitable identical similar question / answer)

Scouse_Bob
  • 600
  • 7
  • 26
  • Possible duplicate of [ORA-12170: TNS:Connect timeout occurred](https://stackoverflow.com/questions/23970158/ora-12170-tnsconnect-timeout-occurred) – Ken White Mar 20 '19 at 02:09
  • Thanks but this is definitely different – Scouse_Bob Mar 20 '19 at 02:31
  • 1
    Does the listener log show anything? Given the debugging you've done so far, I'd suggest you do a sqlnet client trace. Set the proper parameters in the client-side sqlnet.ora. See the relevent SQLNET Admin Guide for details. – EdStevens Mar 20 '19 at 14:38

0 Answers0