SAP Knowledge Base Article - Preview

2713833 - CONNECT failed with sql error '1017'

Symptom

After configuring SSFS as per note 1639578, you get error ORA-01017 in trans.log:

4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with -1=OCI_ERROR 139 0.195731
4 ETW000 [ dev trc,00000] OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017: 152 0.195883
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
4 ETW000 30 0.195913
4 ETW000 [ dbsloci.,00000] *** ERROR => CONNECT failed with sql error '1017' 27 0.195940
4 ETW000 [ dev trc,00000] set_ocica() -> SQL error code 1017 17 0.195957
4 ETW000 [ dev trc,00000] -->oci_get_errmsg (con=0, rc=1017) 24 0.195981
4 ETW000 [ dev trc,00000] OCIErrorGet -> SQL error code: 1017 77 0.196058
4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied

And in trans.log, it shows username as blank:

4 ETW000 [ dev trc,00000] charset='UTF16', ncharset='AL16UTF16', UNI_ASC=FALSE 15 0.147014
4 ETW000 [ dev trc,00000] Connecting as /<pwd>@<SID> on connection 0 (nls 0) ... (dbsl 720 291112, UNICODE[2])


Read more...

Environment

Oracle database

Product

SAP ERP 6.0

Keywords

ORA-01017, SSFS , KBA , BC-DB-ORA , Oracle , Problem

About this page

This 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.