Oracle Database case study-failed to import and export Oracle Data-Database User locked

1.1 symptom Description: Data Import failed. The system displays the following error message:

SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

---- Load weak_password.unl

ORA-28000: the account is locked

1.2 it may be caused by the database user being locked. 1.3 Procedure OracleThe machine on which the user logs on to the database. To SysdbaThe user connects to the database.

% Sqlplus/as sysdba

Unlock the database user.

SQL> alter userUsernameAccount unlock;

Note:

UsernameIs the database user name.

Run the import data script.

After the import is successful, the system prompts the following information:

Import terminated successfully without warnings.

1.4 references

How to fix ORACLE Database User Password Expiration

1. Reset the user password.

SQL> alter userUsername Identified Password;

Note:

UsernameIs the database user name.

PasswordThe Database Password. You can use the old password.

2. Unlock the database user.

SQL> alter user Username Account unlock;

3. Modify the Password Expiration Policy.

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;