SAPSR3DB Password changed in ABAP but need to all the concern area of ABAP and JAVA

[mohammadwahidullah]

Dear Concern,

I have have changed the Database password of ID SAPSR3DB in ABAP+JAVA stack (SAP PI-> NW 7.11) system by brconnect and successfully changed. After that I kept it in secure store of config tool password filed (jdbc/pool/PIP/Password) and successfully accepted by system.

Problem is in DB level the id is becoming locked in spite of unlock it by alter user command in oracle level. Oracle profile param set as FAILED_LOGIN_ATTEMPTS = 5.

Can you please help me to resolve the problem?

Regards

Wahid

[sunny_pahuja2 · Accepted solution]

Have you restarted the system after changing the password? If not, please stop the system then

change the database password in Java secure storage, the Java application server must be stopped.

Thanks,

Sunny

[Arif1]

Hi,  System restart is required as you have changed the password.  Thanks,  Arif

[mohammadwahidullah]

Hi Everybody,

The problem has been resolve after system restart.

Thank you all for your prompt support.

Regards

Wahid

[Reagan]

You can set the Oracle profile limit for FAILED_LOGIN_ATTEMPTS to unlimited.

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

Restart the Java stack and check whether it is working fine.

Check whether there is a system which is configured with the SAPSR3DB password to connect to the system.

I suspect this should be from Solution Manager system for monitoring purposes.

Regards

RB

[Former Member]

Hi,

Please check this thread...

http://scn.sap.com/thread/1963954

Thanks,

Sreeni.