Case sensitive passwords may cause problems if you run an old version of Oracle Forms (6i in my case) with an Oracle 11g database. The LOGON built-in sends the password to the database un UPPERCASE, so if the passwords doesn’t match, you cannot login to the database.
To disable case sensitive passwords in oracle 11g you have to modify the SEC_CASE_SENSITIVE_LOGON initialization parameter:
SQL> connect sys/oracle as sysdba
SQL> show parameter SEC_CASE_SENSITIVE_LOGON
SQL> sec_case_sensitive_logon boolean
TRUE
SQL>
alter
system
set
sec_case_sensitive_logon=
false
scope=both;
To enable case sensitive passwords again, revert back to true.
No comments:
Post a Comment