Solution to the scott user locked in Oracle_11g, oracle_11gscott

Solution to the scott user locked in Oracle_11g, oracle_11gscott

After installing Oracle10g and creating an oracle database, you can log on to the database using scott to check whether the connection is successful.

Problem:

When you log on with sqlplus scott/tiger in the cmd command, the following message is always prompted: ERROR: ORA-28000: the account is locked.

Solution:

In the cmd command prompt, you can directly log on to oracle and enter the following command:
1. Log On As an administrator

Sqlplus/as sysdba;

2. Run the following command to unlock the scott account:

SQL> alter user scott account unlock;

The user has been changed to complete the unlock operation.

Next, you can set a new password for scott.

3. Modify scott's logon password:

SQL> alter user scott identified by admincss;

The user has been changed. (admincss is the new password)

4. Test whether scott/admincss can log on successfully.

SQL> conn scott/admincss

The connection is displayed.