Solution to scott users locked in Oracle 11g

Solution to scott users locked in Oracle 11g

Modify the locked user in Oracle 11g: scott

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

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.

In the cmd command prompt, you can directly log on to oracle and enter the following command:

Sqlplus/as sysdba;

Run the following command:

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.

Modify scott's logon password:

SQL> alter user scott identified by grace;

Show that the user has been changed (grace is the new password)

Now, let's test whether scott/grace can successfully log on.

SQL> conn scott/grace

The connection is displayed.

Summary of Oracle Database beginners:

Enter sqlplus In the cmd command to connect to the database. The format is:

Sqlplus user name/Password

For example, sqlplus scott/tiger;

In SQL Plus, enter conn to connect to the database. The format is:

SQL> conn user name/Password

Example: conn scott/tiger;

Modify the password of a common user in SQL Plus in the following format:

Aler user Username identified by password

For example, alter user scott identified by grace;

Code for locking and unlocking users in Oracle:

SQL> alter user Username account lock; (lock)

SQL> alter user Username account unlock; (unlock)