alter system set nls_numeric_characters = ".'" scope = spfile; crashes instance
Hello
I want to explicitly set NLS_NUMERIC_CHARACTERS to ".'",
i.e. the decimal separator should be a point (.) and
the group separator should be a single quote (').
When I do
sqlplus / as sysdba
alter system set nls_numeric_characters = ".'" scope = spfile;
shutdown immediate
startup
the instance comes up, but the nls_numeric_characters parameter
(in 'nls_instance_parameters') is corrupted, e.g. showing a value
of "SWITZERLAND'" (note the single quotation mark)
When I shutdown and start up the instance again I get the error
ORA-01078: failure in processing system parameters
LRM-00121: ',' is not an allowable value for 'RECYCLEBIN'
I want to explicitly set NLS_NUMERIC_CHARACTERS to ".'",
i.e. the decimal separator should be a point (.) and
the group separator should be a single quote (').
When I do
sqlplus / as sysdba
alter system set nls_numeric_characters = ".'" scope = spfile;
shutdown immediate
startup
the instance comes up, but the nls_numeric_characters parameter
(in 'nls_instance_parameters') is corrupted, e.g. showing a value
of "SWITZERLAND'" (note the single quotation mark)
When I shutdown and start up the instance again I get the error
ORA-01078: failure in processing system parameters
LRM-00121: ',' is not an allowable value for 'RECYCLEBIN'
0