How Oracle Unlocks SOCTT users

Completed Oracle 10g database and forgot to unlock the Scott account. This can be in the SQL Plus tool (start | All Programs |<oracle-home>| Application Development | SQL Plus), or you can unlock the Scott account from the console via the command line.

In the first case, log in to SQL Pluswith the SYSTEM account + password you set when you installed it,

Then use the command "alter user Scott account unlock;" To unlock it.

After the solution is finished, use the following command to view: "select Username,account_status from Dba_users;",

You can see that the Scott account has been unlocked, but the status is still "expired" (password expired) meaning.

Never mind, enter the command "alter user Scott identified by Tiger;" and give it a new password.

Exit and log in as Scott/tiger .

In the second case, use Windows's Console (program | run, enter CMD to open). Under command line, enter Sqlplus/nolog, carriage return, the sql> command prompt appears, and then enter the command in the following order:

Sql>conn/as SYSDBA
Sql>alter user Scott account unlock;
Sql>disconnect
Sql>conn scott/[email protected];
The password is now expired, please enter a new password. Then enter two new defined passwords to enter the password separately to confirm that the Scott account is given a new password. Open SQL Plus and log in with your Scott account.

How Oracle Unlocks SOCTT users