on 10-29-2013 8:38 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, System restart is required as you have changed the password. Thanks, Arif
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
76 | |
9 | |
8 | |
7 | |
6 | |
5 | |
5 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.