Database Error Messages

ORA-39384

Warning: User string has been locked and the password expired.

Cause

Oracle Data Pump displayed this message while importing users because it determined that a user was created with a password version that is no longer supported. See the documentation for PASSWORD_VERSIONS in the system view DBA_USERS for more information.


Action

Connect AS SYSDBA and unlock the account and set a password for the user. This can be done by issuing an "ALTER USER username ACCOUNT UNLOCK;" command followed by an "ALTER USER username IDENTIFIED BY password;" command. See the documentation for the SQLNET.ORA parameter SQLNET.ALLOWED_LOGON_VERSION_SERVER which explains how to control which password versions will be created when the password for the user is reset.