Oracle User System Unlock

1. First enter the SQL Plus window (see previous article)

2. Enter after: Enter select Username,account_status from dba_users where username= ' SYSTEM ';

3. Query the system user's status and user name, here can query out the password, but the password is ciphertext, so can not directly check.

4. If the SYSTEM LOCKED is displayed

5. Next unlock: Alter user "SYSTEM" account UNLOCK

6. If the correct action should be displayed: the user has changed. The status of the system is now unlocked (OPEN).

7. Change password at this time: Alter user system identified by manager; Change the password to the system default password.

8. Switch user at this time: Conn System/manager

9.show user:show User User is System.

Oracle User System Unlock