* Check the current status of the CASE Sensitive parameter.
1) Log in to database as SYS or SYSTEM
C:\sqlplus system/password@PIONEERS
SQL> show parameter case;
Output will be like below.
NAME TYPE VALUE
------------------------------------ ----------- ---------
sec_case_sensitive_logon boolean TRUE
* Alter the value and disable the CASE sensitivity.
SQL> alter system set sec_case_sensitive_logon=FALSE;
"System altered." message will be appear.
* Check the new status of the CASE Sensitive parameter as mentioned in the first step.
SQL> show parameter case;
NAME TYPE VALUE
------------------------------------ ----------- -------------
sec_case_sensitive_logon boolean FALSE
1) Log in to database as SYS or SYSTEM
C:\sqlplus system/password@PIONEERS
SQL> show parameter case;
Output will be like below.
NAME TYPE VALUE
------------------------------------ ----------- ---------
sec_case_sensitive_logon boolean TRUE
* Alter the value and disable the CASE sensitivity.
SQL> alter system set sec_case_sensitive_logon=FALSE;
"System altered." message will be appear.
* Check the new status of the CASE Sensitive parameter as mentioned in the first step.
SQL> show parameter case;
NAME TYPE VALUE
------------------------------------ ----------- -------------
sec_case_sensitive_logon boolean FALSE