11g : Password can be make case sensitive

Scenario,

A database link ILMIS_FND was created on ILPROD database (oracle 9i) to access tables in ERPDBA database (11g R1) using the
connect string FNDDATA,

Link was created successfully but when
select count(*) from tab@ILMIS_FND ;
errored out with message -- Invalid username or Password.

1.tnsping FNDDATA (connect string ) found to be OK.
2.sqlplus fnd_data/****@FNDDATA too found to be ok.


Workaround
--------------------
In 11g version of Oracle Database password can be made case sensitive.
The following init parameter is to be set accordingly.

sec_case_sensitive_logon == (TRUE | FALSE)

On ERPDBA database (which is on 11g R1) the above parameter found tobe set TRUE

05:44:52 erpdb > show parameter sec_case_sensitive_logon

NAME TYPE VALUE
------------------------------------ ----------- ------------
sec_case_sensitive_logon boolean TRUE


The above parametre set to be FALSE then....

05:45:45 erpdb > alter system set sec_case_sensitive_logon=FALSE scope=BOTH;

System altered.

05:46:01 erpdb > show parameter sec_case_sensitive_logon

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
sec_case_sensitive_logon boolean FALSE


Now login was successfull using the db link ILMIS_FND.


one more Feature.......

while creating the password file using orapwd utility do the following
to make password case insensitive ..

orapwd file=orclpwd password=manager ignorecase=y