Home » RDBMS Server » Server Administration » nls_numeric_characters doesn't change after reboot (Oracle 11g , windows8)
nls_numeric_characters doesn't change after reboot [message #673723] Thu, 06 December 2018 13:30 Go to next message
Andrey_R
Messages: 271
Registered: January 2012
Location: Israel
Senior Member

Hi all,
I have this database on my laptop, in which I am testing the nls_numeric_characters param:

SQL> show user
USER is "SYS"
SQL>
SQL> show parameter nls_numeric_character

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_numeric_characters               string      .,
SQL>
SQL> select 1+'0,1' from dual;
select 1+'0,1' from dual
         *
ERROR at line 1:
ORA-01722: invalid number

So I try to change it with alter system :

SQL> alter system set nls_numeric_characters=',.' scope=both;
alter system set nls_numeric_characters=',.' scope=both
                 *
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option


SQL>

got an error..
So ok, I am just changing in spfile:

SQL> alter system set nls_numeric_characters=',.' scope=spfile;

System altered.

SQL>


Then I reboot and try to see if it changed:

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup
ORACLE instance started.

Total System Global Area 1837244416 bytes
Fixed Size                  2256184 bytes
Variable Size            1157628616 bytes
Database Buffers          671088640 bytes
Redo Buffers                6270976 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL> select 1+'0,1' from dual;
select 1+'0,1' from dual
         *
ERROR at line 1:
ORA-01722: invalid number


SQL>
SQL>
SQL> show parameter nls_numeric_characters

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_numeric_characters               string      .,
SQL>
SQL>
SQL>







It haven't.

Anybody can explain why ??

Thanks in advance.
Andrey

Re: nls_numeric_characters doesn't change after reboot [message #673726 is a reply to message #673723] Thu, 06 December 2018 14:05 Go to previous message
Michel Cadot
Messages: 66037
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
SQL> show user
USER is "SYS"
Read SYS is special.

SQL> show user
USER is "MICHEL"

SQL> alter session set NLS_NUMERIC_CHARACTERS='.,';

Session altered.

SQL> select 1+'0,1' from dual;
select 1+'0,1' from dual
         *
ERROR at line 1:
ORA-01722: invalid number


SQL> alter session set NLS_NUMERIC_CHARACTERS=',.';

Session altered.

SQL> select 1+'0,1' from dual;
   1+'0,1'
----------
       1,1

1 row selected.
Previous Topic: Finding Skip Scan
Next Topic: Table Partitioning
Goto Forum:
  


Current Time: Mon Dec 10 09:33:39 CST 2018