Search This Blog

Wednesday, July 6, 2016

Oracle Account locked ORA-28000

After Someone type the wrong password in the application, the user been locked in Oracle Database.


SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jul 2 11:35:54 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.

ERROR:
ORA-28000: the account is locked


To unlock the Account:

$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jul 2 11:36:01 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

SQL> alter user account unlock;


Permanent Disable Account lock function.


$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Sat Jul 2 11:36:01 2016

Copyright (c) 1982, 2010, Oracle. All Rights Reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, Data Mining and Real Application Testing options

SQL> ALTER PROFILE "DEFAULT" LIMIT failed_login_attempts unlimited;

No comments:

Post a Comment