Change the nls_Language
643638Aug 6 2009 — edited Aug 7 2009I configured my database 10g release 2 with the next values: nls_language=american, nls_territory=america. I want to change them: nls_language=spanish, nls_territory=mexico.
Then I follow the following steps:
1) sql> create pfile from spfile;
2) sql> shutdown immediate
3) $) Edit initDB.ora and change teh parameters
4) sql> startup pfile='$ORACLE_HOME/dbs/initDB.ora'
5) sql> select * from nls_database_parameters
The output is
PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA
Then I verify the parameters
sql> sho parameter nls_language
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
nls_language string SPANISH
nls_territory string MEXICO
Check the pfile
SQL> sho parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string
My question is why oracle doesnt change the values when I issue select * from nls_database_parameters ???