SAP Knowledge Base Article - Preview

3531510 - HANA SDA connection to Oracle fails with ORA-01017

Symptom

SDA connection to a remote Oracle Database fails with the error below:

<username>@<servername>:/usr/sap/HAN/HDB00> isql -v ORCL_SDA
[28000][unixODBC][Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

Note:

  • ORCL_SDA is the <TNS_ALIAS> within the tnsnames.ora file


Read more...

Environment

  • SAP HANA DB 2.0
  • Oracle Database 11g
  • Oracle Database 12c
  • Oracle Database 19c

Keywords

ORA-01017,ORA-1017, HANA, Oracle, SDA, Smart Data Access, invalid username/password, logon denied, isql , KBA , HAN-DB-SDA , SAP HANA Smart Data Access , BC-DB-ORA , Oracle , Known Error

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.