Oracle command line is believed to be familiar to everyone. in the daily work of DBAs, Oracle users are often unlocked; the following describes how to unlock an Oracle user in the Oracle command line. Several Simple unlock statements can be used to unlock the user.
The following describes how to unlock a user using Oracle commands:
Scott users are locked by default, and they can be unlocked first to log on to the land. Use the following statement to unlock scott:
Alter user scott account unlock;
This password may be required after unlocking:
Alter user scott identified by tiger;
Log On again:
Sqlplus scott/tiger
You can log on.
Oracle commands for locking and unlocking users
SQL> conn/as sysdba
Connected.
// Scott cannot log on when the default tieger password is not set.
How to lock a user:
SQL> alter user test account lock;
The user has changed.
------- The test user fails to log on to the database.
C: \> sqlplus test/test
ERROR:
ORA-28000: the account is locked
How to unlock an Oracle user:
SQL> conn/as sysdba
SQL> alter user test account unlock;
The user has changed. In this way, the Oracle user unlock operation is completed.
Oracle queries table space usage
Create tables and indexes in Oracle
Implementation of oracle re-Indexing
Oracle COMMIT statement processing sequence
Use with statements to improve Oracle query efficiency