Home » RDBMS Server » Networking and Gateways » Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed (SAP HANA2.0,Oracle Gateway 11g/12c/18c,SuseLinux 12.5)
Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682277] Thu, 15 October 2020 04:44 Go to next message
superblood
Messages: 4
Registered: October 2020
Junior Member
hi guys,


We have one hana database that version 02.05.0105 in SuseLinux.
I try to create dblink through Oracle gateway 11g/12c/18c,but all failed.

did you someguys success connect to SAP HANA Version 2.0 database through Oracle Gateway success?

Vincent Chen
Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682291 is a reply to message #682277] Thu, 15 October 2020 07:31 Go to previous messageGo to next message
EdStevens
Messages: 1266
Registered: September 2013
Senior Member
superblood wrote on Thu, 15 October 2020 04:44
hi guys,


We have one hana database that version 02.05.0105 in SuseLinux.
I try to create dblink through Oracle gateway 11g/12c/18c,but all failed.

did you someguys success connect to SAP HANA Version 2.0 database through Oracle Gateway success?

Vincent Chen
"but all failed" is not found in any error message reference.
Show us your gateway configuration and the exact error messages you receive.

And read this post about configuring the gateway.

Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682292 is a reply to message #682291] Thu, 15 October 2020 07:42 Go to previous messageGo to next message
superblood
Messages: 4
Registered: October 2020
Junior Member
hiļ¼ŒEdStevens

when I execute sql from sqlplus face the below error.

SQL> select * from DUMMY@PRDOTG;
select * from DUMMY@PRDOTG
*
ERROR at line 1:
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=sapsbxapp)(PORT=1521))(CONNECT_DAT
A=(SID=dg4odbc)))
ORA-02063: preceding line from PRDOTG
Process ID: 18356
Session ID: 380 Serial number: 48225


also please see the gateway trace log in the attachment,

Vincent Chen
Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682293 is a reply to message #682292] Thu, 15 October 2020 07:44 Go to previous messageGo to next message
superblood
Messages: 4
Registered: October 2020
Junior Member
This is gateway configfile

initdg4odbc.ora

  1. This is a sample agent init file that contains the HS parameters that are
  2. needed for the Database Gateway for ODBC
  1. HS init parameters
#
HS_DB_NAME = PRD
HS_FDS_CONNECT_INFO = PRD
HS_FDS_TRACE_LEVEL = DEBUG
#HS_FDS_SHAREABLE_NAME = /usr/lib64/libodbc.so
HS_FDS_SHAREABLE_NAME = /usr/local/unixODBC/lib/libodbc.so
#HS_LANGUAGE=AMERICAN_AMERICA.UTF8
HS_LANGUAGE = AMERICAN_AMERICA.WE8ISO8859P1
HS_NLS_NCHAR = UCS2
HS_FDS_TRANSACTION_MODEL= READ_ONLY
HS_LONG_PIECE_TRANSFER_SIZE = 1024
HS_FDS_SQLLEN_INTERPRETATION = 32
HS_RPC_FETCH_REBLOCKING = OFF
HS_FDS_FETCH_ROWS = 1
HS_FDS_TIMESTAMP_MAPPING = CHAR
HS_FDS_DATE_MAPPING = CHAR
HS_KEEP_REMOTE_COLUMN_SIZE = LOCAL
HS_NLS_LENGTH_SEMANTICS = CHAR


#
  1. ODBC specific environment variables
#
set ODBCINI= /etc/unixODBC/odbc.ini


#
  1. Environment variables required for the non-Oracle system
#
set ORACLE_HOME=/oracle/TST/18.0.0
set ORACLE_BASE=/oracle

odbc.ini

[ODBC]
DEBUG = 1
Trace = Yes
TraceFile = /tmp/odbctrace.out

[PRD]
Driver = /usr/sap/PRD/hdbclient/libodbcHDB.so
ServerNode = eccsbx:30047
ServerDB = PRD

unixODBC version is 2.3.9,latest version.


Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682296 is a reply to message #682293] Thu, 15 October 2020 07:55 Go to previous messageGo to next message
superblood
Messages: 4
Registered: October 2020
Junior Member
Hi,EdStevens

I have know how to configure oracle gateway,but the sticky thing is source database is sap hana 2.0,seems dg4odbc can not handle sqlcommand to hana 2.0 database.
but i have not find any offical ducoment about it,so this is very weird situation.
Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682298 is a reply to message #682296] Thu, 15 October 2020 08:34 Go to previous messageGo to next message
BlackSwan
Messages: 26747
Registered: January 2009
Location: SoCal
Senior Member
https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.03/en-US/66a4169b84b2466892e1af9781049836.html
Re: Oracle DBLink through Oracle Gateway connect to SAP HANA 2.0 Failed [message #682329 is a reply to message #682296] Fri, 16 October 2020 08:03 Go to previous message
EdStevens
Messages: 1266
Registered: September 2013
Senior Member
superblood wrote on Thu, 15 October 2020 07:55
Hi,EdStevens

I have know how to configure oracle gateway,but the sticky thing is source database is sap hana 2.0,seems dg4odbc can not handle sqlcommand to hana 2.0 database.
but i have not find any offical ducoment about it,so this is very weird situation.
dg4odbc doesn't know anything about target (not source) database, regardless of it's flavor. . dg4odbc simply calls an odbc driver, and all odbc drivers present the same interface to the calling program, dg4odbc in our case. Tell dg4odbc to call a odbc driver for mssql, and it will talk to mssql. Tell it to call an odbc driver for MySQL, and it will talk to MySQL. Tell it to call a driver for SAP HANA, and it will talk to SAP HANA. That's what ODBC is all about.

You've been provided a link for the proper odbc driver.
Previous Topic: ORA-12541: TNS:no listener". (.Net SqlClient Data Provider) (2 merged)
Goto Forum:
  


Current Time: Fri Oct 23 23:08:51 CDT 2020