Connection of Oracle Form 6i with Oracle 11g

If you are upgrading Oracle Database to Oracle11g and if any application developed using Oracle Form6i then keep in mind, it won't work. you will face problem of
1. ORA-1017 - Invalid username/password; logon denied and
2. FRM-41352 - Failed to create a new session

Reason: When Oracle 11g installed, by default its 'password case sensitive' property is true. That is not supported  by Oracle Forms 6i in-built function OPEN_FORM that is called with 'ACTIVATE' and 'SESSION' arguments.

Solution: Make false the password case sensitive property.
Alter database set SEC_CASE_SENSITIVE_LOGON=false;

Comments