Hi all !
I have 2 subnets with MS SQL Servers and it's not possible to create direct link between them.
And I have 2 proxy servers between this subnets with install Oracle CMAN in first, and CMAN and dg4msql in second (2 independent listeners).
The first MS SQL Server with install Oracle Client with oledb driver and created linked server over him.
The connect string in tnsnames.ora in first MS SQL Server:
CB56-DB1_GW =
(DESCRIPTION =
(SOURCE_ROUTE = YES)
(ADDRESS = (PROTOCOL = TCP)(HOST = UGE-DBGW.severstal.severstalgroup.com)(PORT = 1520))
(ADDRESS = (PROTOCOL = TCP)(HOST = KHP-DBGW.severstal.severstalgroup.com)(PORT = 1520))
(ADDRESS = (PROTOCOL = TCP)(HOST = KHP-DBGW.severstal.severstalgroup.com)(PORT = 1521))
(CONNECT_DATA =
(SID = dg4msqlCB56-DB1)
)
(HS=OK)
)
tnsping is working, but linked server test calls error "ORA-12564: TNS:connection refused"