CODEWITHSUNDEEP
databaseoracle-databasedatabase-schema
prashant1988
prashant1988

Reputation: 282

ORA-28000: account is locked error in expdp

I'm getting ORA-28000: account is locked error during oracle export utility. Issuing the below command:

expdp user/password tables=MY_TABLE directory=TABLE_EXPORT dumpfile=myexport.dmp CONTENT=DATA_ONLY COMPRESSION=ALL

I changed our database user account password and oracle export utility is not working ever since this password change. It locks the user account every time we try to run it. As all my other jobs are working good with the same username and password, it has nothing to do with wrong username and password in expdp command.

It looks like some configuration or password syncs are required in some database files. Has anyone got any idea of solution to this weird situation?

Upvotes: 2

Views: 5665

Answers (2)

ArifMustafa
ArifMustafa

Reputation: 4965

It happens due to multiple test connection or login attempts done with wrong parameters (aka user-name or password combinations).

Failure -Test failed: ORA-28000: the account is locked

Now, how to unlock that particular user in Oracle.

A privileged user (system, sysdba, or database administrator) must logon to the standby and unlock the account there.

ALTER USER locked_user_name ACCOUNT UNLOCK;

COMMIT;

Upvotes: 1

pygator
pygator

Reputation: 121

Does the new password have special characters that could cause the shell script to behave differently?

May be helpful to know the account_status: select username,account_status from dba_users;

This would tell us if the account is getting locked due to too many failed logins or is someone running "alter user account lock".

Upvotes: 1

Related Questions