Shulou(Shulou.com)06/01 Report--

1 the phenomenon of the error is ora-28000 the account is locked, which means that the user cannot log in.

2 reason: the reason for this error is that the user can not log in successfully for many times, which exceeds the number of times allowed to log in to the database, so the user is locked. This mechanism is also a kind of protection to the database and improves the security of the database.

3 the solutions are as follows:

(1) enter the command sqlplus / nolog in the dos window, and the screenshot is as follows:

(2) enter the command conn / as sysdba after clicking enter, and the result is:

(3) enter the command desc dba_profiles to capture the screenshot as follows:

(4) enter the command select resource_name,limit from dba_profiles where resource_name = 'FIELD_LOGIN_ATTEMPTS';' to capture the screenshot as follows:

(5) then unlock the user and execute the command: alter user username account unlock

(6) change the value of the FILED_LOGIN_ATTEMPTS field to unlimited, which will not be locked no matter how many times you enter it. But at this point, the security of the data will be reduced.

You can execute the command: alter profile default limit failed_login_attempts unlimited; screenshot is as follows:

(7) you can check the value of failed_login_attempts at this time. Execute select resource_name,limit from dba_profiles where resource_name = 'FAILED_LOGIN_ATTEMPTS'; screenshot as follows:

(8) so far, the user has been unlocked.

PS: let's take a look at [Oracle11g] ORA-28000: the account is locked's solution.

When you connect to Oracle in PL/SQL with your scott account, you will be prompted to ORA-28000: the account is locked.

Solution:

Step 1: find the sqlnet.ora file in the% ORACLE_HOME%NETWORK\ ADMIN directory, where% ORACLE_HOME% is the oracle installation path.

Mine is: d:\ app\ haojiec\ product\ 11.2.0\ dbhome_1\ NETWORK\ ADMIN, open sqlnet.ora, and add a line between the NAMES.DIRECTORY_PATH and ADR_BASE lines in the file: SQLNET.AUTHENTICATION_SERVICES= (NTS), save.

Step 2: open the DOS window and type sqlplus sys/Oracle11g as sysdba

Where sys is the account and Oracle11g is my password. The success will be shown as follows:

Connect to:

Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL >

Step 3:

SQL > conn sys/Oracle11g as sysdba;Connected.

Step 4:

SQL > alter user scott account unlock;User altered.SQL > commit;Commit complete.SQL > conn scott/tiger / / Please enter the new password and confirm after OKPassword changedConnected.

At this time, go to plsql developer and log in as scott/tiger.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.