Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

heterogeneous connection to sybase9

998962Mar 25 2013 — edited Mar 26 2013
Hi,
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 23 2013
Added on Mar 25 2013
3 comments
462 views