heterogeneous connection to sybase9
998962Mar 25 2013 — edited Mar 26 2013Hi,
i am trying to connect sybase 9 through oracle 11g R2 database by using heterogeneous connection.
I have created a DSN called mig_dsn to sybase database using siebel oracle90 driver....
my initmig_dsn.ora file is as follows
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = mig_dsn
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
my listener.ora file is as follows....
# listener.ora Network Configuration File: D:\app\10604064\product\11.2.0\dbhome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app\10604064\product\11.2.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app\10604064\product\11.2.0\dbhome_1\bin\oraclr11.dll")
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = INFVA05676.vshodc.lntinfotech.com)(PORT = 1521))
)
)
mig_dsn =
(ADDRESS_LIST=
(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=2582))
)
SID_LIST_mig_dsn=
(SID_LIST=
(SID_DESC=
(SID_NAME=mig_dsn)
(ORACLE_HOME=D:\app\10604064\product\11.2.0\dbhome_1)
(PROGRAM=hsodbc)
)
)
ADR_BASE_LISTENER = D:\app\10604064
)
my tnsnames.ora file is as follows......
# tnsnames.ora Network Configuration File: D:\app\10604064\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = INFVA05676.vshodc.lntinfotech.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
MIG_DSN =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA = (SID = mig_dsn))
(HS=OK)
)
I have started the listener successfully and tnsping is also working
I have created a public database link called sample.
But when i query the database it is giving me following error...
Error starting at line 1 in command:
select * from s_prod_defect@sample
Error at Command Line:1 Column:28
Error report:
SQL Error: ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from SAMPLE
28545. 0000 - "error diagnosed by Net8 when connecting to an agent"
*Cause: An attempt to call an external procedure or to issue SQL
to a non-Oracle system on a Heterogeneous Services database link
failed at connection initialization. The error diagnosed
by Net8 NCR software is reported separately.
*Action: Refer to the Net8 NCRO error message. If this isn't clear,
check connection administrative setup in tnsnames.ora
and listener.ora for the service associated with the
Heterogeneous Services database link being used, or with
'extproc_connection_data' for an external procedure call.
please help me.
Thanks
Edited by: 995959 on Mar 25, 2013 6:13 AM