Unlock and change the password of the system user in Oracle

I learned a few commands when I got in touch with Oracle and changed the password of the system user. After a few days, I forgot + _ + .. The following describes how to unlock and

I learned a few commands when I got in touch with Oracle and changed the password of the system user. After a few days, I forgot + _ + .. The following describes how to unlock and

I learned a few commands when I got in touch with Oracle and changed the password of the system user. After a few days, I forgot + _ + ..

The following describes how to unlock the system user and restore the password.

1. First, use the sys user to enter Oracle AS sysdba.

2. conn sys/as sysdba; enter the password :******;

3. Enter select username, account_status from dba_users where username = 'system ';

4. query the status and User Name of the system user. The password can be queried here, but the password is ciphertext. Therefore, you cannot directly query the password.

5. If system locked is displayed

6. Next, UNLOCK: alter user "SYSTEM" ACCOUNT UNLOCK

7. If the operation is correct, it will show that the user has changed. In this case, the system status is already unlocked.

8. Change the password: alter user system identified by manager; change the password to the default password of system.

9. Switch the user: conn system/manager.

10. show user: show user USER is System.