Oracle unlocks the Scott/tiger user

Oracle unlocks the Scott/tiger user

1, verify the current system for Scott user status:

SELECT * from Dba_users where upper (username) = ' SCOTT ';

Account_status:expired & LOCKED

2. Release the lock for Scott User:

Conn Sys/bitservice@ttonline as SYSDBA;

Alter user Scott account unlock;

SELECT * from Dba_users where upper (username) = ' SCOTT ';

Account_status:expired

3, connect Scott User:

Conn Scott/tiger@ttonline to indicate that the user has expired, please re-enter the new password: Tiger

Conn Scott/tiger@ttonline, this user can be connected properly this time.

4, view the status of Scott User:

Conn Sys/bitservice@ttonline as SYSDBA;

SELECT * from Dba_users where upper (username) = ' SCOTT ';

Account_status:open