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 for Me (Login required).

Search for additional results

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