Oracle 11g the account is locked

Oracle 11g the account is locked

Walk_hai's blog: http://blog.csdn.net/walk_hai

(I am using Oracle 11g R1)

The ora-28000 of the account is locked was prompted today when oracle was turned on to log on with a system user. The user is locked.

The reason why the user is locked may be the following.

1. Failed to log on multiple times (the password may be incorrect );

2. the user is manually locked by the Administrator;

3. the user password expires, the password is not modified on time, and so on.

The following is my solution

Bytes ------------------------------------------------------------------------------------------------------------------
SQL> connect sys/sys as sysdba;
Connected.
SQL> alter user system account unlock;

The user has changed.

SQL> commit;

Submitted.

SQL> conn system/OK // enter the new password, and then OK
Password Changed
Connected.
SQL> conn system/OK
Connected.
SQL> show user;
User is "system"

Bytes --------------------------------------------------------------------------------------------------------------------

Account locking method
1. SQL> alter user system account lock;
User altered.
Change account password
1. SQL> alter user system identified by sysPasswd;

Experience in Oracle databases:

1. Input sqlplus under the DOS command to open the SQL plus that comes with Oracle and the logon prompt appears,

If sqlplus/nolog is entered, the logon prompt is not displayed after SQL plus is enabled;

2. Enter Conn in SQL plus to connect to the database. One of the formats is:

SQL> conn username/password, for example, Conn Scott/Tiger

3. Code for locking and unlocking users in Oracle:

SQL> alter User Username account lock; (LOCK)

SQL> alter User Username account unlock; (unlock)