Oracle Account lockout workaround

Today into the use of orcle, found in the system, systems account login prompted account is locked, and later looked up data, problem resolution, the method is as follows:

Microsoft Windows [version 5.2.3790]

(C) Copyright 1985-2003 Microsoft Corp.

C:documents and Settingsadministrator>sqlplus/nolog

Sql*plus:release 10.2.0.1.0-production on Wednesday June 24 10:43:39 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Sql> Conn/as SYSDBA

is connected.

sql> alter user SYSTEM account unlock;

The user has changed.

Sql> exit

From Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options Disconnect

C:documents and Settingsadministrator>sqlplus

Sql*plus:release 10.2.0.1.0-production on Wednesday June 24 10:45:26 2009

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Please enter user name: System

Enter Password:

Connect to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0-production

With the partitioning, OLAP and Data Mining options

Sql>

The account was unlocked successfully:)

When the database was created, a password was already set for 4 accounts such as SYS, where SYS and system had administrator privileges to log into the Oracle database using the SYSTEM account in the Sql*plus tool.

1, through the data dictionary dba_users, check the lock status of the Oracle account, as follows: (v wherein, open indicates that the account is unlocked, expired indicates that the account is out of date (need to set a password to dismiss this state); locked indicates that the account is locked. ）

Second, use the ALTER USER statement below to unlock the Scott account:

Sql> ALTER USER Scott account UNLOCK;

Then use the ALTER USER statement to set the password for the Scott account as follows:

Sql> ALTER USER Scott identified by Tiger;

View the current status of the Scott account via the data dictionary dba_users as follows: The results of the query show that the Scott account has been successfully unlocked. When using data dictionary dba_users, be aware that the values of their fields are case-sensitive.