Hi,
I'm trying to connect via sqlplus from a Windows Server 2012 64bit, with Oracle Client 11.2.0.3 installed, to a Oracle Database 11.2.0.3.
I'm getting the error in te topic:
C:\Users\serveruser>sqlplus dispatch@evort
SQL*Plus: Release 11.2.0.3.0 Production on Mon Sep 15 16:36:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
ERROR:
ORA-12170: TNS:Connect timeout occurred
This is the tnsnames.ora:
EVORT =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = EVORT)
)
)
(Copied from a working production server)
This is the sqlnet.ora:
SQLNET.AUTHENTICATION_SERVICES= (NONE)
NAMES.DIRECTORY_PATH= (TNSNAMES, EZCONNECT)
ORACLE_HOME and TNS_ADMIN env var are correctly set up (if I try a sqlplus with a wrong SID I get the "ORA-12154: TNS:could not resolve the connect identifier specified")
The telnet to xxx.xxx.xxx.xxxx:1521 successes.
What can it be?
The Windows Firewall seems to be completely off.
Is there anything else I should check?
Thanks in advance,
Samuel