Ext.: http://database.51cto.com/art/200910/158576.htm
In the daily work of the DBA, the operations that are unlocked for the Oracle user are often encountered, and this article gives an operation method for unlocking the Oracle user under the command line, which can be accomplished with a few simple unlocking statements. Here are the specific procedures:
The default Scott user is locked out and can be logged on by unlocking it first. Use the following statement to unlock Scott:
Alter user Scott account unlock;
You may be asked for this password after unlocking:
Alter user Scott identified by Tiger;
Re-login:
Sqlplus Scott/tiger
We can land.
Oracle lock and Unlock commands for users
Sql> Conn/as SYSDBA
is connected.
Scott user does not log on when Tieger default password is not set
How to lock a user:
sql> ALTER user test account lock;
The user has changed.
-------test user logged into the database and failed.
C:\>sqlplus test/test
ERROR:
Ora-28000:the account is locked
Ways to unlock Oracle users:
Sql> Conn/as SYSDBA
sql> alter user test account unlock;
The user has changed. This completes the user unlock operation for Oracle.
Oracle lock and Unlock commands for users