Checking failed login attempts & change password of SAPSR3

In my previous post you find that how to unlock SAPSR3. if in some cases this user is locking again & again. it’s better to change the password of SAPSR3 & also change the default limit of failed login attempts.

Procedure to check.

1. go to CMD – “sqlplus / as sysdba”

2. execute statement to check limit of failed login attempts.

SELECT LIMIT FROM DBA_PROFILES
WHERE
PROFILE = ‘DEFAULT’ AND
RESOURCE_NAME = ‘FAILED_LOGIN_ATTEMPTS’;

default limit = 10.

Changing default limit = 10 to unlimited.

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

now it’s time to change the password of SAPSR3.

CMD>brconnect -u / -c -l E -f chpass -o SAPSR3  -password (whatever_you_want)