How to resolve a locked Scott user in oracle_11g

After installing oracle10g and creating the Oracle database, you want to log in with the user Scott that comes with the database to see if the connection is successful.

Problem:

In the cmd command, when you log in with "Sqlplus Scott/tiger", you are always prompted with the following message: error:ora-28000: The account is locked.

Workaround:

At the cmd command prompt, you can log in directly to Oracle and enter the following command:
1. Log in as Administrator

Sqlplus/as Sysdba;

2. Then execute the following command to unlock the Scott account:

sql> alter user Scott account unlock;

Shows that the user has changed so that the unlocked operation is complete.

Next, you can also reset the password to the Scott user.

3. Change Scott's login password:

Sql> alter user Scott identified by ADMINCSS;

Show that the user has changed (ADMINCSS is the new password)

4. Test if SCOTT/ADMINCSS can log in successfully

Sql> Conn Scott/admincss

The display is connected.

How to resolve a locked Scott user in oracle_11g