Oracle Database Discussions

Hi,

Could you please one tell me how to change *.nls_comp='LINGUISTIC'
parameter value at system or database level. i created pfile from spfile and added
*.nls_comp='LINGUISTIC'
and restarted database with pfile , but ending up
SQL> startup pfile='/tmp/mrpfile.ora';
ORA-12700: invalid NLS parameter value (nls_comp)
error,
could one please suggest me the way of changing
nls_comp parameter value. all these required to do Case-insensitive Comparisons.

and tried at session level but it is not working.. please help me out urgently

SQL> ALTER SESSION SET NLS_COMP='LINGUISTIC';
ERROR:
ORA-12705: invalid or unknown NLS parameter value specified


SQL> show parameter nls_comp

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_comp string

Oracle Database 10g Enterprise Edition Release 10.1.0.3.0

thanks in advance.