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