ORA-28000 account is locked and unlocked

Source: Internet
Author: User

Now with oracle11g, but over a period of time the user was locked depressed for a long, later on-line query know, the original Oracle has the number of login failures failed_login_attempts limit, more than the specified number of times will be automatically locked

Workaround:

Modify parameter failed_login_attempts=unlimited;

Sql>sqlplus/nolog

Sql>conn Sys/sys as SYSDBA;

First, Unlock:

Sql>alter user username account unlock;

sql>commit;

Second, modify the number of login failures limit:

1. Query the default value of the Failed_login_attempts parameter: (Note: The value of this parameter is unlimited in a 9i environment)

Sql>conn/as SYSDBA

Connected.

sql> desc dba_profiles;
Whether the name is a null type
----------------------------------------- -------- --------------

Profile is not NULL VARCHAR2 (30)
Resource_name not NULL VARCHAR2 (32)
Resource_type VARCHAR2 (8)
LIMIT VARCHAR2 (40)

Sql> Select Resource_name,limit from dba_profiles where resource_name= ' failed_login_attempts ';

Resource_name LIMIT
-------------------------------- ----------------------------------------
Failed_login_attempts 10

The query failed_login_attempts value is 10, which is the number of consecutive login failures that are calculated from the first logon failure. Rather than the number of cumulative failures

2. Modify the value of the failed_login_attempts

sql> alter profile default limit Failed_login_attempts unlimited;

Configuration file has changed

Sql> Select Resource_name,limit from dba_profiles where Resource_name= ' Failed_lo
Gin_attempts ';

Resource_name LIMIT
-------------------------------- ----------------------------------------
Failed_login_attempts UNLIMITED

You can use the Select Name,lcount from user$ statement to query the current number of failures. user$ is the base table for view dba_users, and you can usually query the base table for the view, and Oracle may hide some parameters.

ORA-28000 account is locked and unlocked

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.