Search This Blog

Saturday, March 12, 2016

Change Oracle case sensitivity of database Password

At the time of development , we are facing a problem of case sensitivity of database schema password. To remove  this, please follow the following instruction.

1. Connect to SYS user

  sql> conn sys as sysdba

  sql> alter system set SEC_CASE_SENSITIVE_LOGON=FALSE scope=both;

After that , if you type mix case in your password, it will be accepted by database and your development will be faster.