Problem: ORA-28000: the account is locked ., Ora-28000locked

Problem: ORA-28000: the account is locked ., Ora-28000locked

Open cmd:

Run

Sqlplus/nolog

Run
Conn/as sysdba

Run

Alter user username account unlock;

ORA-28000 in oracle Database: the account is locked Problem

This user has been locked. Generally, it has to be unlocked because the wrong password has been tried too many times.
Log in with the system or sys user, and then
Alter user username account unlock;

JavasqlSQLException: ORA-28000: the account is locked? Solution

Use a user with DBA permission or a local conn/as sysdba login to unlock
Command: alter user lxy account unlock;
Ora-28000 the account is locked, this occurs because the user is locked,
Generally, this problem occurs because the number of connections to the database is greater than the configured number of connections. follow the steps below to solve the problem.
1. Program connection is greater than the number of oracle connections;
Handling Method: reset the number of connections: Use the Administrator to execute the following script,
Alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS 10; -- set the number of connections
Alter profile DEFAULT limit FAILED_LOGIN_ATTEMPTS UNLIMITED; -- UNLIMITED connections
2. The program connection is larger than the number of connections configured in the connection pool;
Solution: Increase the number of connections in the connection pool;
3. Release the user lock:
Run alter user Username account unlock as the super administrator;