Hi,
I am trying to configure ODBC Agent with oracle to access ORACLE RDB.
I have installed ORACLE RDB ODBC driver and created SYSTEM DSN named
"dcprdb".
My configuration files are as follows
inithsodbc.ora (at E:\oracle\ora81\hs\admin)
HS_FDS_CONNECT_INFO = dcprdb
HS_FDS_TRACE_LEVEL = 0
HS_FDS_TRACE_FILE_NAME = hsodbc.trc
tnsnames.ora (at E:\oracle\ora81\network\ADMIN)
hsodbc =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ip_address)(PORT = 1527))
)
(CONNECT_DATA =
(SID = hsodbc)
)
(HS=)
)
listener.ora (at E:\oracle\ora81\network\ADMIN)
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = hsodbc)
(ORACLE_HOME = E:\oracle\ora81)
(PROGRAM = hsodbc)
)
)
CONNECT_TIMEOUT_LISTENER = 0
I restarted the TNS Listener service. Then, I have created DB link using the following command:
CREATE DATABASE LINK hsodbc
CONNECT TO <user_name> IDENTIFIED BY <password>
USING 'hsodbc';
When I executed the following query, I am getting the following error message:
select * from model@hsodbc;
Error Message:
select * from modl@hsodbc
*
ERROR at line 1:
ORA-02068: following severe error from HSODBC
ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=207.53.38.129)(PORT=
1527)))(CONNECT_DATA=(SID=hsodbc)))
I am using Windows 2000 OS and Oracle8i Enterprise Edition Release 8.1.7.0.0
When I executed "tnsping dcprdb" at E:\oracle\ora81\bin, it works well. (see, below)
E:\oracle\ora81\bin>tnsping dcprdb
TNS Ping Utility for 32-bit Windows: Version 8.1.7.0.0 - Production on 20-JAN-20
04 19:41:06
(c) Copyright 1997 Oracle Corporation. All rights reserved.
Attempting to contact (ADDRESS=(PROTOCOL=TCP)(HOST=ip_address)(PORT=1527))
OK (810 msec)
E:\oracle\ora81\bin>
Thanks in Advance
Thiru