Hi,
I have installed oracle 11.2 in RHEL 6.3 and tried to add odbc connection from windows 2012 std r2 server. I am getting below error.
Unable to connect
SQLState=08004
[Oracle][ODBC][Ora]ORA-12154:TNS:could not resolve the connect identifier specifed
My tnsping outpu
[oracle@Vcenter-DB ~]$ tnsping orcl
TNS Ping Utility for Linux: Version 11.2.0.1.0 - Production on 02-MAY-2015 08:44:52
Copyright (c) 1997, 2009, Oracle. All rights reserved.
Used parameter files:
/u01/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Vcenter-DB)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl.asicdesigners.com)))
OK (0 msec)
My tnsnames file in windows 2012
LISTENER =
(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = Vcenter-DB.asicdesigners.com)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl)))
below is sceenshot how i am trying
Let know any inputs required.
Thanks,
Vidya Sagar