Guys,

I am trying to connect with oracle 8.1.7 to sql server 7.0 using HS connectivity but I am having problem to select table from sql server using dblink. i am getting following error message

ORA-28509: unable to establish a connection to non-Oracle system ORA-02063: preceding line from HSODBC

Following are my configration for init.ora, listiner.ora and tnsname.ora

GLOBLE_NAME = FALSE

Listener.ora

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
)
(DESCRIPTION =
(PROTOCOL_STACK =
(PRESENTATION = GIOP)
(SESSION = RAW)
)
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 2481))
)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = e:\oracle\ora81)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME =test1)
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = test1)
)
(SID_DESC =
(GLOBAL_DBNAME = test2)
(ORACLE_HOME = e:\oracle\ora81)
(SID_NAME = test2)
)
(SID_DESC =
(SID_NAME = hsodbc
(ORACLE_HOME = E:\oracle\ora81)
(PROGRAM = hsodbc)
)
)

Tnsname.ora

# TNSNAMES.ORA Network Configuration File: e:\oracle\ora81\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

Test2 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test2)
)
)

INST1_HTTP =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = SHARED)
(SERVICE_NAME = test2)
(PRESENTATION = http://admin)
)
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)

test1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = test1)
)
)

HSODBC =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hsodbc)
)
(HS = OK)
)

Following is my trace file error messages

Redo thread mounted by this instance: 1

Oracle process number: 16

Windows thread id: 764, image: ORACLE.EXE


*** SESSION ID:(15.47609) 2002-04-15 12:39:56.078
*** 2002-04-15 12:39:56.078
HS: Unable to establish RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)))(CONNECT_DATA=(SERVICE_ NAME=hsodbc))), NCR error = 28560
*** 2002-04-15 12:40:33.328
HS: Unable to establish RPC connection to remote Agent...
HS: ... Agent SID = (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=server1)(PORT=1521)))(CONNECT_DATA=(SERVICE_ NAME=hsodbc))), NCR error = 28560

Hoping for valuable input.


Thanks

Minesh