I created a profile
create profile two_wrong limit failed_login_attempts 2;
alter user scott profile two_wrong;
SQL> conn scott/tige
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
My concern is why it is automatically log out to oracle instead showing errors on two times
based on the profile created..