col NAME format a30;
col VALUE format a10;
SQL> select p.name,p.value from v$parameter p, v$spparameter s where s.name=p.name and p.isdeprecated='TRUE' and s.isspecified='TRUE';
NAME VALUE
------------------------------ ----------
sec_case_sensitive_logon FALSE
NOTE: This parameter is deprecated so no need anymore.
------------------------------ ----------
sec_case_sensitive_logon FALSE
NOTE: This parameter is deprecated so no need anymore.
Now reset the parameter:
alter system reset sec_case_sensitive_logon scope=spfile;
alter system reset sec_case_sensitive_logon scope=spfile;
SQL> shutdown immediate;
SQL> startup;
No comments:
Post a Comment