Home » RDBMS Server » Networking and Gateways » ORA-28511: lost RPC connection to heterogeneous remote agent using (ORACLE 11G,linux)
ORA-28511: lost RPC connection to heterogeneous remote agent using [message #633122] Wed, 11 February 2015 04:31 Go to next message
zeeshan047
Messages: 99
Registered: June 2010
Location: PAKISTAN
Member

hello,

I have use oracle11g r2 gateway for linux 64 bit and mysql-connector-odbc-5.1.13-1.rhel5.x86_64 and created dblink to access mysql database from oracle 11gr2, I am facing below error.


ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=ORA-28511: lost RPC connection to heterogeneous remote agent using
SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.168.20.33)(PORT=3306))(CONNECT_
DATA=(SID=prayertimings)))
ORA-02063: preceding line from DBLINK
Process ID: 52680
Session ID: 11 Serial number: 4854


odbc.ini
*********
[ODBC Data Sources]
demo = MySQL ODBC Driver 5.1


[demo]
Driver = /usr/lib64/libmyodbc5.so
DATABASE = prayertimings
DESCRIPTION = MySQL ODBC 5.1.5 Connector Sample
PORT = 3306
SERVER = 10.168.20.218
# UID = demo
# PWD = demo
CHARSET = latin1
TRACEFILE = /tmp/myodbc-demodsn.trc
TRACE = OFF
**********************************************

initprayertimings.ora
************************
HS_FDS_CONNECT_INFO=demo
HS_FDS_TRACE_LEVEL=0
HS_FDS_SHAREABLE_NAME=/usr/lib64/libmyodbc5.so
HS_LANGUAGE=AMERICAN_AMERICA.WE8ISO8859P15
# HS_NLS_NCHAR=AL32UTF8
#
# ODBC specific environment variables
#
set ODBCINI=/etc/odbc.ini
set LD_LIBRARY_PATH=/usr/lib64/


#
# Environment variables required for the non-Oracle system
#
set HOME=/u01/app/oracle/product/11.2.0/dbhome_1

Listener1
***********
LSNRCTL> status listener1
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.168.20.33)(PORT=3306)))
STATUS of the LISTENER
------------------------
Alias listener1
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 11-FEB-2015 13:21:23
Uptime 0 days 0 hr. 18 min. 58 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/11.2.0/grid/network/admin/listener.ora
Listener Log File /u01/app/grid/diag/tnslsnr/racnode2/listener1/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=10.168.20.33)(PORT=3306)))
Services Summary...
Service "prayertimings" has 1 instance(s).
Instance "prayertimings", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully


[Edit MC: fix code tags]

[Updated on: Wed, 11 February 2015 05:07]

Report message to a moderator

Re: ORA-28511: lost RPC connection to heterogeneous remote agent using [message #633123 is a reply to message #633122] Wed, 11 February 2015 04:56 Go to previous message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
You need close the "code" tags with [/code] in future.

HTH
-g
Previous Topic: The application not reading the data fast enough
Next Topic: OID for Oracle TNSNAMES.ora
Goto Forum:
  


Current Time: Thu Mar 28 09:26:25 CDT 2024