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 useraccount 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