Saturday, January 23, 2010

Oracle Forms 10g ORA-01017-invalid username/password while running on Oracle 11g

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;

Cheers,
Baig

4 comments:

  1. thanks dude, you have saved my day...

    ReplyDelete
  2. despite setting sec_case it didnt work

    ReplyDelete
    Replies
    1. Hi,
      This solution for specific use case there could be 100 other reasons for Invalid username and password error. Try to connect user directly through SQL developer.

      Regards,
      Zeeshan

      Delete