Component : Oracle -

Solution : https://service.sap.com/sap/support/notes/951167 (SAP Service marketplace login required)

Summary :
When attempting to log on to the Oracle database, users may encounter the ORA-28000 error, indicating an account lock. This is often due to multiple failed logon attempts (ORA-01017), typically caused by incorrect password usage. The failure threshold is set by the FAILED_LOGIN_ATTEMPTS parameter in Oracle's profile settings. Since Oracle version 10.2, the default limit is set to 10 attempts. To resolve, adjust the FAILED_LOGIN_ATTEMPTS setting in the DEFAULT profile to UNLIMITED, or explicitly unlock the user account via the command 'ALTER USER ACCOUNT UNLOCK'. Check for any misconfigurations, particularly within the OPS$ mechanism, that might be causing the incorrect password rejections.

Key words :
alter profile default limit failed_login_attempts unlimited, alter user <username> account unlock, alter user <username> account lock, ora-28000 error occurred due, dba_profileswhere  profile = 'default', avoid similar problems, prevent ora-28000 errors, allowed logon attempts, failed logon attempts, default profile

Related Notes :

1519872	SAP Database User Profile SAPUPROF
700548	FAQ: Oracle authorizations
400241	Problems with ops$ or sapr3 connect to Oracle