How to check the default profile parameters for Oracle database users:
SELECT profile, resource_name, limit FROM dba_profiles WHERE profile='DEFAULT';
The output from the query should look similar to this:
Failed_login_attempts 10
Password_grace_time 7 (days)
Password_life_time 180
Password_lock_time 1 (days)
Password_reuse_max Unlimited
Password_reuse_time Unlimited
To modify any of these parameters, use the following statement:
ALTER PROFILE DEFAULT LIMIT
FAILED_LOGIN_ATTEMPTS 5
PASSWORD_LIFE_TIME UNLIMITED;