Try to connect via B4HANA using SDA to remote source Oracle.
Getting below error on HANA studio when try to connect:
"SAP DBTech JDBC: : internal error: Cannot get remote source objects: [Oracle][ODBC][Ora]ORA-12514: TNS:listener does not currently know of service requested in
If changing the datasource name like XXXXX in the studio then it throw error:
"SAP DBTech JDBC: : 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
SAP HANA DB 2.0
KBA , HAN-DB-SDA , SAP HANA Smart Data Access , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.