Home > 11gR2, oracle > How to enable/disable case sensitive passwords in Oracle 11g?
  1. July 12, 2018 at 9:10

    Very useful, thanks.


  2. pinger
    May 6, 2016 at 8:05

    thanks for share this topic, its solve my problem that is database 11g with forms 10g
    forms connect perfectly but reports give message Terminated with error: REP-501: Unable to connect to the specified database


    • May 11, 2016 at 23:23

      You can try this (look at the first entry, copied here): https://community.oracle.com/thread/2511270?tstart=0

      1. Disabled case sensitive login in the 11g database.
      2.Used FORMS_USERNAME_CASESENSITIVE = 1 in ORACLE_HOME/forms/server/default.env.
      3.Checked for zrclient.jar and rwrun.jar in classpath env variable.
      4.Changed Service_name to sid in the tns connect string.
      5.Restarted the whole opmn stack.
      6.Run the form in debug mode and find the username,password and connect string it is throwing to report is OK. I can connect through sqlplus.

      Hope it helps!


  3. Alberto Oliveira
    March 24, 2016 at 8:30

    it is helpful
    Problem solved.


  4. mohamed
    March 6, 2016 at 0:06

    Scope must be both


    • May 4, 2016 at 17:38

      That’s true if you want to make the change permanent when you bounce the database.


  5. Mac
    March 4, 2016 at 12:58

    Not really true. It was introduced in Oracle 10g but in Oracle 11g it is default ‘TRUE’!


  6. October 11, 2015 at 14:46

    Okay I just saw the Press This button after signing in. Thanks buddy


  7. October 11, 2015 at 14:45

    Hello Miquel Coll
    You should have a reblog this with your site 🙂 just a suggestion.



  8. February 17, 2015 at 10:27

    Reblogged this on RememberLINK.


  1. October 11, 2015 at 14:45

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s

%d bloggers like this: