How to unlock an oracle user

Some users are locked by default after oracle is installed. For example, if Scott user is often lucked, we must first try to give her unluck to use her, this article will introduce how to manually unlock scoot users. Of course, you can also go to the Enterprise Manager Console as a system administrator in Oracle and check the unlock check box!

The specific process is as follows:

Command Line call SQL * Plus

-> Run-> cmd to go to the command line:

Sqlplus/nolog

SQL> conn system/oralce; or connect system/Oracle;

SQL> alter user Scott account unlock; (opposite method: SQL> alter
User Scott account lock)

SQL> alter user Scott identified by tiger;

Then try to log on with Scott User:

Sqlplus Scott/Tiger

Scott has been unlocked;

Unlock directly under SQL * Plus

SQL> Conn/As sysdba;

SQL> alter user test account unlock;

The user has changed. In this way, the Oracle user unlock operation is completed.

In my eyes, the keyboard is the same as the piano key, which can be used to interpret the music that touched the world! From: http://www.cnblogs.com/jiajinwen/archive/2011/11/23/2260272.html