ORA-01017-invalid username/password while running on Oracle 10g/11g/12c/18c

 I recently installed Oracle11g on Windows to work with Oracle developer Forms 10g everything works fine but when i run the form in browser from builder i got error

ORA-01017 Invalid username/password logon denied

i was confused what to do but problem solved...

In Oracle 11g a new parameter called SEC_CASE_SENSITIVE_LOGON which is defaults to TRUE for case sensitive passwords. My SCOTT password was "tiger" is small case and Forms 10g was taking it as "TIGER" on runtime.

Solution 1:

- Connect as sys and change the parameter to false.

alter system set SEC_CASE_SENSITIVE_LOGON = FALSE;

Solution 2:

- Connect as DBA and change the password of SCOTT to LETTER case.

alter user scott identified by TIGER;