ORA-2800: blocking error in qtp

Question

I get the following error when connecting to db to check db time through QTP scripts:

 "Cannot update system time with database time due to error: ERROR: [Oracle][ODBC][Ora]ORA-28000: the account is locked" 

But the SID database and credentials are correct and verified the same in some db client. I'm not sure why its throwing error in QTP ?

Can anyone help me solve the problem?

Answer 1

1) Log in to your Oracle database using administrator privileges:

cmd> sqlplus / as sysdba

or

cmd> sqlplus system/{systemPassword}@{OracleSID}

2) Unlock your account with the following command:

sql> alter user {yourDbUser} account unlock;

3) It is still forbidden to repeat account locks on the SQL * Plus command line:

sql> ALTER PROFILE "DEFAULT" LIMIT PASSWORD_LIFE_TIME UNLIMITED;

sql> ALTER PROFILE "DEFAULT" LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

Edit Comment

The above instructions should solve your problem. I am sending an additional command that I found related to this topic that you can try (I'm not sure if this is the solution):

sql> grant connect, resource to {yourDbUser};

You can also check the status of other blocked users in your database . Your tool may be trying to contact another user who, in addition to the one you are using, still has this problem.

Answer 2

This solution is for Oracle 10g and error ORA-28000: account is locked Enter the SQL command line:

 conn sys as sysdba 

enter password

 alter user system account unlock;