Pages

Thursday, January 23, 2020

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.

No comments:

Post a Comment