The Oracle software installed a few months ago suddenly forgot the password you set. Today, I checked how to retrieve it.
After logging on as a user jqz/jqz (a previously created user, fortunately remembered:
SQL> connect/As sysdba
Connected.
SQL> alter user system identified by system;
The user has changed.
The system password is system.
How to solve the following error:
ORA-28000: the account is locked
Step 1: Use PL/SQL. the login name is system, and the database name remains unchanged. When selecting a type, change normal to sysdba;
Step 2: Select myjob to view users;
Step 3: Select system and right-click Edit ";
Step 4: change the password and remove the "account locked" check box;
Step 5: click "application" and then "close ";
Step 6: log on again and you will be able to pass the verification;
Method 2: Unlock
SQL> Conn/As sysdba
Connected.
SQL> alter user system account unlock;
The user has changed.
How can I retrieve the password entered by the System user of oralce? Met the ORA-28000: the account is locked how to unlock?