Oracle Forgot Password handling method

There may be people who don't use the Oracle database for a long time, and then, in turn, they'll find that they still forget the password ...

Here is a workaround after forgetting your password

First of all, you open the database with the SYS or SYSDBA super Administrator user name login , this time must be aware that the connection must be sysdba or sysoper one of the two can be ,

At this time even if your password is written at random can be logged in successfully, the reason is not specifically elaborated

Write statements after successful login

-- Take the Scott system user as an example -- because it is locked by default, you have to unlock the alter user Scott account unlock first; -- If it is a new user, you can omit the unlock operation -- Modify the user password alter username user name identified by new password; 

This will change the password successfully.

Oracle Forgot Password handling method