This content has been marked as final. Show 9 replies
I don't understand the question.
You alter instance parameter and then look at database parameters for verification?
Try looking at NLS_INSTANCE_PARAMETERS values instead.
If you really need to change the parameter at the database level, you probably need to create a new db. You might want to review the NLS Territory setting as well.
Edited by: orafad on May 14, 2009 12:40 PM
Do you interpret too much in that, perhaps?
Reference guide description of Parameter descriptions:
SQL> alter system set open_cursors=400; System altered. SQL> alter system set nls_numeric_characters='.'; alter system set nls_numeric_characters='.' * ERROR at line 1: ORA-02096: specified initialization parameter is not modifiable with this option SQL> alter system set nls_numeric_characters='.' **scope=spfile**; System altered. SQL> alter system reset nls_numeric_characters scope=spfile sid='*'; System altered.
Specifies whether the parameter can be changed for the current session (by an ALTER SESSION statement) or for all sessions in the current instance (by an ALTER SYSTEM statement):
. ALTER SESSION overrides the instance-wide setting of the parameter for the current session only. You can restore the instance-wide setting for that session only by issuing another ALTER SESSION statement.
. ALTER SYSTEM can be used to change the value in the server parameter file (SPFILE) of any initialization parameter. Such a change takes effect only in subsequent instances. The parameter descriptions indicate only those parameters that can be modified for the current instance.
Edited by: orafad on May 14, 2009 1:36 PM
You don't need necessarily to change the language part, but territory GERMANY is correct. But keep in mind you also change other properties, refer to
As an alternative define NLS_NUMERIC_CHARACTERS explicitly as environment variable or - even simpler - use 'ALTER SESSION ...' to change the value for the actual session.