ORA-28000: the account is locked resolved

ORA-28000: the account is locked resolved

In Oracle, if the account fails to log on for ten consecutive attempts, the account will be locked ). When you log on with a locked account, the system reports an error: ORA-28000: the account is locked. This article describes how to solve the secondary error.

1. Log On with the system or sys account. Be sure to log on as an administrator. Find the default Sytem and sys passwords online. This document uses the sys account as an example. The default password of sys is change_on_install.

2. Use commands to unlock users. Command: alteruser usernameaccountunlock, where username is the locked user name.

3. Reset the user password. Command: alter user username identified by password; username is the user name and password is the new password.

4. Use your account to log on again. If all commands are successfully executed, you should be able to log on to the system normally.

ORA-28000: the account is locked user locking troubleshooting