Oracle unlock user and reset user password __oracle

After installing Oracle 10g, you want to open sql*plus to learn, and then follow the steps in the book to connect to the database with Scott users, you can lose several times prompted an error.

Error:the account is locked

Then after checking the internet and found that the user was locked, as to why it was locked, may be the following reasons.

1. Attempting to log on multiple times was unsuccessful. (may not have the correct password)

2. This user is manually locked by the administrator.

3. User password expires. Failed to change password on time.

This user must be unable to log in, then I use system this user login, but logged a half-day did not go in, and go to the Internet, most of the online is about Oracle 9i users and passwords, and then I remember in the installation when prompted to input, with that try on the connection, So the user's password for Oracle 10g system is not the default, but it is set up when installed.

After you log in with system, execute the following command:

sql> alter user Scott account unlock;

The user has changed.

This completes the unlock operation. Next, you can also reset the user's password to Scott.

Modify Scott's login password

Sql> alter user Scott identified by pan;

The user has changed.

OK, you can use Scott and pan to log in!

Sql> Conn Scott/pan

is connected.

When the Oracle 10g is installed, you can log on with System/password, but you cannot log in using the Scott/tiger User:

Conn Scott/tiger Error:oracle 10g the account is locked Oracle 10g the password has expired

Reason: The default Oracle 10g Scott cannot log in. has been disabled.

Workaround:

First confirm that Oracle databases and clients are installed

Execute the following statement under Client DOS:

Note Prompt symbol

C:/sqlplus/nolog sqlp/conn Sys/system@oracle10 as SYSDBA//sys for the current Oracle user system for this user password oracle10 as SID # Alter user so CTT account lock; Lock the Scott user # Alter user Scott account unlock; Unlock the Scott user # Alter user Scott identified by Scott//modify Scott user password to Scott,scott user default password is Tiger

1 DOS input C:/sqlplus/nolog

2 Log on as DBA

Conn Sys/password as SYSDBA;

3 unlock

Alter user Scott account unlock;

4 Pop-up A Change Password dialog box, modify the password

Conn Scott/tiger sql> Conn Sys/sys as SYSDBA; Connected. sql> alter user Scott account unlock; User altered. Sql> commit; Commit complete. Sql> Conn scott/tiger//Please enter a new password and confirm after OK Password changed Connected.