cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to up the system as SAPSR3 is getting locked automatically

Former Member
0 Kudos

Hello All,

I am having BI 7.0 on windows with Oracle. We are unable to up the system as SAPSR3 account is locked automatically.

I have changed the password using BRTOOLS, and executed command "Alter user SAPSR3 account unlock;" but when i try to up the sap application server its getting locked again.

could you please suggest me a reason.

Thanks,

Subbu

Accepted Solutions (0)

Answers (3)

Answers (3)

sunny_pahuja2
Active Contributor
0 Kudos

Hi,

Check SAP Note 951167 - ORA-28000: the account is locked

Thanks

Sunny

Former Member
0 Kudos

Hi,

I have applied as per note 400241 and 951167 and the issue has been solved.

Thanks,

Subbu

Former Member
0 Kudos

It looks like there is a process trying to connect to your database with the wrong credentials, causing the account to get locked everytime. Try to find out which process this is, and correct the credentials accordingly.

Former Member
0 Kudos

Hi,

try this one

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

and unlock the user.

No restart of the DB necessary.

Kind regards.