Shulou(Shulou.com)06/01 Report--

After installing Oracle11g 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.

1.Scott user is locked

In the cmd command, when logging in with "sqlplus scott/ tiger", it always prompts the following message: ERROR:ORA-28000: the account is locked.

two。 Solution method

You can log in to oracle directly from the cmd command prompt and enter the following command: sqlplus / as sysdba

Then execute the following command: SQL > alteruser scott account unlock; shows that the user has changed, which completes the unlocking operation.

3. Reset password

You can also reset the password for the user scott.

Modify the login password of scott SQL > alter user scottidentified by cloudar

Shows that the user has changed, (cloudar is the new password)

This is OK. Test whether scott/cloudar can log in successfully.

SQL > conn scott/cloudar

Shows that it is connected.

Attached: common basics

Enter sqlplus in the cmd command to connect to the database in the format:

Sqlplus username / password

Such as: sqlplusscott/tiger; (tiger is the default password of the system)

Enter conn in SQLPlus to connect to the database in the following format:

SQL > conn username / password

Such as: connscott/tiger

Modify the password of an ordinary user in SQLPlus in the following format:

Aler user username identified by password

Such as: alteruser scott identified by cloudar

The command format for locking and unlocking users in Oracle:

SQL > alter user username account lock; (locked)

SQL > alter user username account unlock; (unlocked)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.