Component: BC-DB-ORA (Basis Components > Database Interface, Database Platforms > Oracle), Version: 4,
Released On: 2024/10/16

Symptom
The command “R3trans -d” failed with return code 0012.
The “trans.log” file shows following error messages:
4 ETW000 [ dev trc,00000] Connecting as SAPSR3/<pwd>@<SID> on connection 0 (nls 0)

4 ETW000 1017:

[

dev trc,00000]

OCISessionBegin(OCI_DEFAULT) failed with SQL error

4 ETW000 [ dev trc,00000] ORA-01017: invalid username/password; logon denied
Environment
Oracle 11.2 and higher
Secure connection via SSFS
Cause
The password of SAPSR3 is incorrect.

Resolution
1. Change the password of SAP schema user SAPSR3 with command in SQLPlus.
sqlplus /nolog
conn / as sysdba
alter user SAPSR3 identified by <new_password>;
2. Logon to OS with <sid>adm user and then run following command.
rsecssfx put DB_CONNECT/DEFAULT_DB_USER SAPSR3 -plain
rsecssfx put DB_CONNECT/DEFAULT_DB_PASSWORD <new_password>

See Also
1639578 – SSFS as password store for primary database connect
Keywords
OCISessionBegin(OCI_DEFAULT) failed with SQL error 1017, OCISessionBegin(OCI_DEFAULT) failed, ORA-01017,
OCISessionBegin(OCI_DEFAULT) ORA-01017
Attributes

Key	Value
Requires Action	0