To check failed login attempts in oracle and change password of schema user

Procedure to check.

Go to “sqlplus / as sysdba”

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.

To Change default limit = 10 to unlimited. Below is the command

ALTER PROFILE DEFAULT LIMIT FAILED_LOGIN_ATTEMPTS UNLIMITED;

To change schema user  SAPSR3 password

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