Skip to Content
0
Former Member
Oct 29, 2012 at 08:28 AM

Delete parameter nls_length_semantics

156 Views

Dear all,

How can I delete nls_length_semantics from my instance ?

SQL> show parameter nls_length_semantics;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_length_semantics string BYTE

SQL> alter system reset nls_length_semantics scope=spfile sid='*';
alter system reset nls_length_semantics scope=spfile sid='*'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE


SQL> alter system reset nls_length_semantics scope=spfile sid='QAS';
alter system reset nls_length_semantics scope=spfile sid='QAS'
*
ERROR at line 1:
ORA-32010: cannot find entry to delete in SPFILE

They indeed do not exist in my spfile, but are set somehow in the sytem.

Same is for log_archive_dest_state_2. No idea how.


Thanks for advices,

Jordan