Home » RDBMS Server » Networking and Gateways » HS Gateway software in windows 2012 (Oracle 12c, windows 2012)
HS Gateway software in windows 2012 [message #644587] Tue, 10 November 2015 05:44 Go to next message
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 #644677 is a reply to message #644587] Thu, 12 November 2015 22:04 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,

please anyone help me.

Regards
Muktha
Re: HS Gateway software in windows 2012 [message #644678 is a reply to message #644677] Thu, 12 November 2015 22:15 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
submit Service Request
Re: HS Gateway software in windows 2012 [message #644680 is a reply to message #644678] Fri, 13 November 2015 00:44 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Blackswan,

Thanks,

Regards
Muktha
Re: HS Gateway software in windows 2012 [message #644683 is a reply to message #644587] Fri, 13 November 2015 02:05 Go to previous messageGo to next message
John Watson
Messages: 8738
Registered: January 2010
Location: Global Village
Senior Member
You say you are using 12c (though you didn't say what release). Using the Heterogeneous Gateway to talk to SQL Server should be fine,
https://docs.oracle.com/database/121/OTGIS/configsql.htm#OTGIS900
what's the problem?
Re: HS Gateway software in windows 2012 [message #644717 is a reply to message #644683] Mon, 16 November 2015 00:10 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi John, Blackswan

No, the Gateway 11g version dont support in windows 2012 version.
I had downloaded Gateway12 version from oracle site and installed.

Thanks and Regards
Muktha
Re: HS Gateway software in windows 2012 [message #644719 is a reply to message #644717] Mon, 16 November 2015 00:26 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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
Re: HS Gateway software in windows 2012 [message #644722 is a reply to message #644719] Mon, 16 November 2015 01:47 Go to previous message
John Watson
Messages: 8738
Registered: January 2010
Location: Global Village
Senior Member
Should this
      (PROGRAM = dg4msql)
not be a full path?
Previous Topic: Fatal NI connect error 12547
Next Topic: ORA-01017 OS Authentication Fails
Goto Forum:
  


Current Time: Sat Aug 13 21:53:59 CDT 2022