Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change NLS_TERRITORY in oracle 11gr2

MoonlightJan 7 2015 — edited Jan 8 2015

Hello,

We need to chnage NLS_TERRITORY for our new database oracle 11.2.0.2.0 - 64bit

So, we have used this commande :

> alter system set nls_territory = 'FRANCE' scope=spfile;

system altred

> shutdown immediate;

> startup mount;

> ALTER DATABASE OPEN

ORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instance ORACLE
instance started.

when I check dictionary, I fint that NLS_TERRITORY was be changed in nls_instance_parameters, but neither in nls_database_parameters nor in nls_session_parameters.

Please, any one know how can be change this parametre in our database.

Thank you in advance.

Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 5 2015

Added on Jan 7 2015

#database-key-features, #globalization-support

3 comments

13,030 views