3131736 - Connection issue with B4HANA using SDA to Oracle

Symptom

Try to connect via B4HANA using SDA to remote source Oracle.

Getting below error on HANA studio when try to connect:

"SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in

connect descriptor"

If changing the datasource name like XXXXX in the studio then it throw error:

"SAP DBTech JDBC: [403]: internal error: Cannot get remote source objects: [unixODBC][Driver Manager]Data source name not found, and no default driver specified"

If maintain ORCL as defined in the odbc.ini file, this picks the oracle data source name rightly picked up. It looks, that tnsnames.ora file not picking up rightly to connect with the oracle, but is placed in <SAP INSTANCE SID> HOME directory

Environment

SAP HANA DB 2.0

Product

SAP HANA, platform edition 2.0

Keywords

KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.