Home » RDBMS Server » Networking and Gateways » Creating db links without configuring oracle gateway (oracle 12c, version 12.2.1.0.1)
Creating db links without configuring oracle gateway [message #675857] Thu, 25 April 2019 04:02 Go to next message
azmi_aj
Messages: 3
Registered: April 2019
Junior Member
Dear all,

Can we create db link from oracle to sql server without configuring the oracle gateway...
Someone were suggesting that we can create the db link without using any oracle gateway with only adding
(HS=OK) in the (CONNECT_DATA =(SERVICE_NAME = SWCUSTOM_PROD))(hs=ok)) of the connection description string.

Rgds
Azmi
Re: Creating db links without configuring oracle gateway [message #675858 is a reply to message #675857] Thu, 25 April 2019 05:14 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
Someone

Who? Link?

Re: Creating db links without configuring oracle gateway [message #675859 is a reply to message #675857] Thu, 25 April 2019 06:53 Go to previous messageGo to next message
EdStevens
Messages: 1376
Registered: September 2013
Senior Member
azmi_aj wrote on Thu, 25 April 2019 04:02
Dear all,

Can we create db link from oracle to sql server without configuring the oracle gateway...
Someone were suggesting that we can create the db link without using any oracle gateway with only adding
(HS=OK) in the (CONNECT_DATA =(SERVICE_NAME = SWCUSTOM_PROD))(hs=ok)) of the connection description string.

Rgds
Azmi
"Someone were suggesting"
And who is that "someone"?


What you suggest for the link connection string is only the first step. That does not bypass the need for the gateway to connect to a non-oracle database.
See https://edstevensdba.wordpress.com/2018/09/19/the-oracle-transparent-gateway/


BTW, aside from any gateway issues, in any db link definition, you do not have to put the connection string in the link definition itself. you can define the link with just a net service name, to be resolved from the tnsnames.ora file.

[Updated on: Thu, 25 April 2019 06:55]

Report message to a moderator

Re: Creating db links without configuring oracle gateway [message #675860 is a reply to message #675858] Thu, 25 April 2019 20:19 Go to previous messageGo to next message
azmi_aj
Messages: 3
Registered: April 2019
Junior Member
Thanks Michel.... I just need a confirmation. That we still need the gateway to establish the link.

Rgds,
Azmi..
Re: Creating db links without configuring oracle gateway [message #675861 is a reply to message #675859] Thu, 25 April 2019 20:21 Go to previous messageGo to next message
azmi_aj
Messages: 3
Registered: April 2019
Junior Member
Thanks Ed.... for the confirmation and the link for the explaination. I just need to confirm that we still need the configure the gateway.

Rgds,
Azmi ... Smile
Re: Creating db links without configuring oracle gateway [message #675862 is a reply to message #675861] Thu, 25 April 2019 22:05 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
azmi_aj wrote on Thu, 25 April 2019 18:21
Thanks Ed.... for the confirmation and the link for the explaination. I just need to confirm that we still need the configure the gateway.

Rgds,
Azmi ... Smile

Either it works or it does not work.
You should not require anything from here to verify working functionality.
Simply test & see what happens.
Error is Oracle's to indicate that a problem exists.
Re: Creating db links without configuring oracle gateway [message #677277 is a reply to message #675862] Mon, 09 September 2019 12:29 Go to previous message
Glenstr
Messages: 6
Registered: July 2015
Location: Canada
Junior Member
IIRC there are two ways to connect to MSSQL from Oracle, one via transparent gateway for MSSQL, the other via gateway for ODBC.

I believe that the transparent gateway is a separately licensed option, while the ODBC gateway is included with Oracle, but I could be mistaken.
Previous Topic: cisco wifi router not working
Next Topic: installing client on network drive/share
Goto Forum:
  


Current Time: Wed Mar 27 00:12:59 CDT 2024