| HS Gateway software in windows 2012 [message #644587] |
Tue, 10 November 2015 05:44  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
Kindly some one guide me, whether windows 2012 supports Heterogeneous Gateway 11 version to be installed to connect to SQL Server.
I tried but failed.
If not possible, then what version supports windows 2012 OS.
Regards
Muktha
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: HS Gateway software in windows 2012 [message #644719 is a reply to message #644717] |
Mon, 16 November 2015 00:26  |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
Kindly help me for connecting from oracle to sql server through Gateway.
I am facing a problem of TNS Protocol error.
Here is the details.
Oracle DB Home:
C:\Oracle\ORA12C
Oracle Gateway Home:
C:\Ora_Gateway12
Gateway Entries:
---------------
init***dsn.ora
===============
HS_FDS_CONNECT_INFO=***DSN
HS_FDS_TRACE_LEVEL=0
HS_FDS_RECOVERY_ACCOUNT=RECOVER
Listener Entries:
=================
***DSN =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = <HOSTANAME>)(PORT = 1522))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522))
)
)
SID_LIST_***DSN =
(SID_LIST =
(SID_DESC =
(SID_NAME = ***DSN)
(ORACLE_HOME = C:\Ora_Gateway12)
(PROGRAM = dg4msql)
)
)
ADR_BASE_***DSN = C:\Ora_Gateway12
TNSNAMES:
=========
***DSN=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST= <local machine IP>)(PORT=1522))
(CONNECT_DATA=(SID=***DSN))
(HS=OK)
)
DB Entries:
-----------
Tnsnames.ora
=============
***DSN=
(DESCRIPTION=
(ADDRESS=(PROTOCOL=tcp)(HOST= <Local Machine IP>)(PORT=1522))
(CONNECT_DATA=(SID=***DSN))
(HS=OK)
)
Basic Checkup:
-------------
C:\Ora_Gateway12>lsnrctl status ***dsn
LSNRCTL for 64-bit Windows: Version 12.1.0.2.0 - Production on 16-NOV-2015 11:49:34
Copyright (c) 1991, 2014, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<local machine hostname>)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias ***DSN
Version TNSLSNR for 64-bit Windows: Version 12.1.0.2.0 - Production
Start Date 16-NOV-2015 11:02:22
Uptime 0 days 0 hr. 47 min. 12 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File C:\Ora_Gateway12\product\12.1.0\tghome_1\network\admin\listener.ora
Listener Log File C:\Ora_Gateway12\diag\tnslsnr\<local hostname>\***dsn\alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<local hostname>)(PORT=1522)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1522ipc)))
Services Summary...
Service "***DSN" has 1 instance(s).
Instance "***DSN", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
TNSPING:
========
C:\Ora_Gateway12>tnsping ***dsn
TNS Ping Utility for 64-bit Windows: Version 12.1.0.2.0 - Production on 16-NOV-2015 11:52:04
Copyright (c) 1997, 2014, Oracle. All rights reserved.
Used parameter files:
C:\Ora_Gateway12\product\12.1.0\tghome_1\network\admin\sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION= (ADDRESS=(PROTOCOL=tcp)(HOST= <IP Address>)(PORT=1522)) (CONNECT_DATA=(SID=***DSN)) (HS=OK))
OK (0 msec)
But when I try to connect, I am getting the below error message:
TNS-12560: TNS:protocol adapter error
Thanks and Regards
Muktha
|
|
|
|
| Re: HS Gateway software in windows 2012 [message #644721 is a reply to message #644719] |
Mon, 16 November 2015 00:47 |
muktha_22
Messages: 527
Registered: December 2009
|
Senior Member |
|
|
Hi All,
And I forgot to inform, that I am using ODBC connection where the DSN name is "***DSN".
And I have installed Oracle Gateway for sql server. (I guess there is another one available with the name of Oracle Gateway for ODBC).
Regards
Muktha
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
