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
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)