Connecting Oracle to MS SQL

[maddave]

Help! Im getting thoroughly confused and irate!

I am trying to connect an oracle 9i database which is running on Linux Red Hat Enterprise 4, to a MS SQL database which is running on Windows Server 2000.

I have read the following document

https://metalink.oracle.com/metalin...k_frame,p14_font:NOT,231458.1,1,1,1,helvetica

But I am confused as to where each configuration file sits.

I installed the oracle 10g tgm4sql OTG on the windows 2000 server as it was readily available and configured the following files as follows:

tnsnames.ora:

TG4MSQL.domain.name =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = tCP)
(HOST = <IP_ADDRESS>)
(PORT=1521) )
(CONNECT_DATA =
(SID = tg4msql))
(HS=OK)
)

Listener.ora

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = extproc))
(SID_DESC =
(SID_NAME = tg4msql)
(ORACLE_HOME = D:\oracle\product\10.2.0\tg_1)
(PROGRAM = tg4msql)
(ENVS=LD_LIBRARY_PATH=D:\oracle\product\10.2.0\tg_1\LIB)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IPADDRESS)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
)

inittg4msql.ora
HS_FDS_CONNECT_INFO="SERVER=<IP_ADDRESS>;database=<MS SQL DATABASE NAME"
HS_FDS_TRACE_LEVEL=0
HS_FDS_RECOVERY_ACCOUNT=RECOVER
HS_FDS_RECOVERY_PWD=RECOVER
HS_FDS_TRACE_LEVEL=OFF

Then on the Linux server I have the following tnsnames.ora:

TG4MSQL.DOMAIN.NAME =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = <MS SQL IP ADDRESS>)(PORT = 1521))
)
(CONNECT_DATA =
(SID = tg4msql))

I then created a database link on the Linux Oracle server:

create database link tg4msql connect to "sa" 
               identified by "password" using 'tg4msql';

I then tried a:

select * from all_catalog@tg4msql;

and get:

Ora-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NEWTORK/NCR message 12571
ORA-02063: preceeding 2 lines for TG4MSQL

I feel I have done everything I have read but its not very clear where everything has to be put or how it all ties together.

Any help would be useful!
Thanks.