-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|