1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Connection of Oracle Form 6i with Oracle 11g

Discussion in 'Oracle Forms and Reports' started by jibinsam88, Apr 16, 2015.

  1. jibinsam88

    jibinsam88 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    We have upgraded Oracle Database to Oracle11g and our Front end application is developed using Oracle Form6i . We have the below issues
    1. ORA-1017 - Invalid username/password; logon denied
    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

    But now we have a requirement to enable the password sensitivity as this is a security breach . So now we wanted the system to work without ORA-1017,FRM-41352 Errors after enabling the password case sensitive property. We are also going to upgrade Oracle Forms 6i to Oracle Forms 11gR2,so will this issue be resolved? I await your urgent response.
     
  2. jibinsam88

    jibinsam88 Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Can Somebody help here?