/support/notes/service/sap_logo.png){kind=logo}
SAP Knowledge Base Article - PreviewSymptom
After configuring SAP HANA Smart Data Access (SDA) to Oracle SuperCluster, the unixODBC doesn't work and fails with the following error:
sx000:isql -v xxxx userid
[S1000][unixODBC][Oracle][ODBC][Ora]ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA
[ISQL]ERROR: Could not SQLConnect
The .odbc.ini file is defined like below entry:
[ora12c] Driver=your_install_oracle_driver_folder/instantclient_12_1/libsqora.so.12.1 ServerName=ORCL
Read more...
Environment
SAP HANA, platform edition
Product
SAP HANA, platform edition all versions
Keywords
ORA-12504, supercluster, super cluster, rack, SDA, Smart Data Access ,SERVICE_NAME, CONNECT_DATA, SQLConnect, ORA, TNS, listener , 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.
/support/notes/service/facebook.svg)
/support/notes/service/twitter.svg)
/support/notes/service/youtube.svg)
/support/notes/service/linkedin.svg)
/support/notes/service/instagram2.svg)