Heterogeneous Connectivity
Hello
I have a need to connect Oracle RDBMS 10g r2 (10.0.2.5.0) to SQL Server 2008 on WIN 64 bit machine.
To achieve this, I have downloaded and Installed Oracle Gateway for ODBC 11G and followed steps outlined below.
However when I create the database link and run a SELECT statement I get following error:
Code:
ORA-12154: TNS:could not resolve the connect identifier specified
Below are details of all files. Not sure what is causing this. I have checked TNSNAMES.ora multiple times and no luck :(
No matter what I do I am getting ORA 12154.
Code:
Below is my TNSNAME.ora entry from Oracle Database server
SSLTMS=(DESCRIPTION=
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=TCP)(HOST=SQLSERVER-DB)(PORT=1521)))
(CONNECT_DATA=(SID=SSLTMS))
(HS=OK)
)
Below is my Listener.ora entry from Gateway server
Code:
LISTENER =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521))
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(SID_NAME=SSLTMS)
(ORACLE_HOME=C:\product\11.2.0\tg_1)
(PROGRAM=dg4odbc)
)
)
And below is the entry of intiSSLTMS.ini file
Code:
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = SSLTMS
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set =
My sqlnet.ora on Oracle DB supports all names as shown below
Code:
NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
AND, for some weird reasons Listener does not show any services running is this normal?
Code:
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 64-bit Windows: Version 11.2.0.3.0 - Produ
ction
Start Date 02-DEC-2011 23:25:34
Uptime 0 days 0 hr. 7 min. 46 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\product\11.2.0\tg_1\network\admin\listener.ora
Listener Log File C:\product\11.2.0\tg_1\diag\tnslsnr\SQLSERVER-DB\listene
r\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=SQLSERVER-DB)(PORT=1521
)))
The listener supports no services
The command completed successfully
Please help :(
