SAP Knowledge Base Article - Preview

1576837 - ORA-01017: invalid username/password;

Symptom

There are different symptoms for this issue.

  • The error can occur in Backups when connecting as SYSTEM user and also as the OPS$ user
  • The error is also visible in  R3trans and transaction ST11 ->Developer traces when the OPS$ authentification fails.  

    In the traces you may also see an accompanying error like (ORA-28000, the account is locked).  If the account is locked after too many failed attempts for OPS$ user this is generally a result of an incorrect OPS$ configuration.

Scenario A:
In your Backup logfile the following error occurs when running the backup as SYSTEM user,  please  note->(SYSTEM user can be used to run backups however theOPS$ user is recommended and is mostly used).

BR0301E SQL error -1017 at location db_connect-2, SQL statement:
'CONNECT system/*******'
ORA-01017: invalid username/password; logon denied

Scenario B:
In your backup logfile the following error occurs when running the backup as OPS$ user.   Hint: (OPS$ user is used where you see '-u/' or 'connect /' in the command line)

brbackup -u /.....
BR0051I BRBACKUP 7.00 (18)
BR0055I Start of database backup: bbdzxyz.anf -11-19 05.30.00
BR0280I BRBACKUP time stamp: 2008-11-19 05.30.00
BR0301E SQL error -1017 at location BrDbConnect-2, SQL statement:
'CONNECT /'
ORA-01017: invalid username/password; logon denied

Scenario C:
In your Developer tracefile or Trans.log (output of R3trans -d),  you see errors like

"CONNECT failed with sql error '1017'"
"OCI-call 'OCISessionBegin' failed with rc=1017"


Read more...

Environment

  • SAP release independent
  • Oracle

Keywords

"ORA-01017: invalid username/password; logon denied", "Backup with SYSTEM user fails", "OPS$ connect fails", "R3trans fails", "work processes fail at startup with ORA-01017", "ORA-28000: the account is locked"  "OPS$"  "permissions" MSCS. backup , 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.