ORA-28000: the account is locked in SAP

 ORA-28000: the account is locked in SAP

Error :
 Output of R3trans -d shows ORA-28000: the account is locked

Resaon :

  Schema User expired or password has been locked out.

Solution :

   

SQL> select username,ACCOUNT_STATUS from dba_users where username='SAPSR3';

                USERNAME                                         ACCOUNT_STATUS

                --------------------------                          --------------------------------

                 SAPSR3                                                 LOCKED(TIMED)

SQL> alter user SAPSR3 account unlock;

User altered.

SQL> select username,ACCOUNT_STATUS from dba_users where username='SAPSR3';

                USERNAME                                         ACCOUNT_STATUS

                --------------------------                          --------------------------------

                 SAPSR3                                                 OPEN

Now run the command so that the password of the user never expires again

SQL> alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited;

            Profile altered.

SQL> alter profile DEFAULT limit PASSWORD_LIFE_TIME  unlimited;

             Profile altered.