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.
Solution 2:
- Connect as DBA and change the password of SCOTT to LETTER case.
Cheers,
Baig
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
thanks dude, you have saved my day...
ReplyDeleteThanx, it worked for me.
ReplyDeletedespite setting sec_case it didnt work
ReplyDeleteHi,
DeleteThis 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