"Oracle" Oracle account Lock and Unlock

How to unlock an Oracle account (locked)

In Plsql Developer If you are prompted to ora-28000 the account by Scott/tiger login

Locked

Workaround:

After the newly installed oracle10g, with the Scott/tiger test, the following error message will appear:
oracle10g the account is locked
oracle10g the password has expired
Cause: The default oracle10g Scott cannot log in.
Solve:

1. Using Oracle User Login System

2. Perform the following steps:

3, $ sqlplus/nolog

4, sql> Connect/as SYSDBA
Connected.

5, sql> alter user SYSTEM account unlock;

User altered.
Unlock method:
Alter user test account lock;

Lock Account Method

1, sql> alter user SYSTEM account lock;

User altered.

Modify account password

1. sql> ALTER USER system identified by SYSPASSWD;

Enter CMD in DOS mode to enter Sqlplus, log in as System user name, password is just loaded

Oracle when you fill in the password orcl, log in after.

Sql> Conn Sys/sys as SYSDBA; (Semicolons are required but I am logged in as System

This should not be written Conn Sys/sys as SYSDBA should write Conn SYSTEM/ORCL as SYSDBA;)
Connected.
sql> alter user Scott account unlock;
User altered.
Sql> commit;

Source: >

From for notes (Wiz)

"Oracle" Oracle account Lock and Unlock