Home » Server Options » Multitenant » nls_database_parameters CDB and PDB (Oracle 12c on Windows 2012 R2)
nls_database_parameters CDB and PDB [message #644813] Wed, 18 November 2015 04:59 Go to next message
sarrus
Messages: 5
Registered: November 2015
Junior Member
Can anyone explain why nls_database_parameters changes when creating PDB's?
My CDB shows :
NLS_RDBMS_VERSION;12.1.0.2.0 NLS_NCHAR_CONV_EXCP;FALSE NLS_LENGTH_SEMANTICS;BYTE NLS_COMP;BINARY NLS_DUAL_CURRENCY;$ NLS_TIMESTAMP_TZ_FORMAT;DD-MON-RR HH.MI.SSXFF AM TZR NLS_TIME_TZ_FORMAT;HH.MI.SSXFF AM TZR NLS_TIMESTAMP_FORMAT;DD-MON-RR HH.MI.SSXFF AM NLS_TIME_FORMAT;HH.MI.SSXFF AM NLS_SORT;BINARY NLS_DATE_LANGUAGE;AMERICAN NLS_DATE_FORMAT;DD-MON-RR NLS_CALENDAR;GREGORIAN NLS_NUMERIC_CHARACTERS;., NLS_NCHAR_CHARACTERSET;AL16UTF16 NLS_CHARACTERSET;AL32UTF8 NLS_ISO_CURRENCY;AMERICA NLS_CURRENCY;$ NLS_TERRITORY;AMERICA NLS_LANGUAGE;AMERICAN
When I create the a simple PDB, the nls_database_parameters shows:
NLS_RDBMS_VERSION;12.1.0.2.0 NLS_NCHAR_CONV_EXCP;FALSE NLS_LENGTH_SEMANTICS;BYTE NLS_COMP;BINARY NLS_DUAL_CURRENCY;Kr. NLS_TIMESTAMP_TZ_FORMAT;DD.MM.RRRR HH24.MI.SSXFF TZR NLS_TIME_TZ_FORMAT;HH24.MI.SSXFF TZR NLS_TIMESTAMP_FORMAT;DD.MM.RRRR HH24.MI.SSXFF NLS_TIME_FORMAT;HH24.MI.SSXFF NLS_SORT;NORWEGIAN NLS_DATE_LANGUAGE;NORWEGIAN NLS_DATE_FORMAT;DD.MM.RRRR NLS_CALENDAR;GREGORIAN NLS_NUMERIC_CHARACTERS;, NLS_NCHAR_CHARACTERSET;AL16UTF16 NLS_CHARACTERSET;AL32UTF8 NLS_ISO_CURRENCY;NORWAY NLS_CURRENCY;kr NLS_TERRITORY;NORWAY NLS_LANGUAGE;NORWEGIAN
I want the nls_database_parameters to be the same as the CDB, is there a way to do this?

Re: nls_database_parameters CDB and PDB [message #644817 is a reply to message #644813] Wed, 18 November 2015 05:47 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
Please use codes to show your parameters. Hurt my eyes Smile

You create de PDB or you plugin a PDB from other CDB?
Re: nls_database_parameters CDB and PDB [message #644818 is a reply to message #644817] Wed, 18 November 2015 05:51 Go to previous messageGo to next message
sarrus
Messages: 5
Registered: November 2015
Junior Member
Hi.
SELECT * FROM NLS_DATABASE_PARAMETERS;

In the CBD database NLS_LANGUAGE is American.
When i do CREATE PLUGGABLE DATABASE nnn ...

And Alter session set container=nnn
SELECT * FROM NLS_DATABASE_PARAMETERS;

Shows that NLs_language is Norwegian.




Re: nls_database_parameters CDB and PDB [message #644819 is a reply to message #644818] Wed, 18 November 2015 05:53 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
Ok, but you create this pdb from SEED or from another CDB?
You have any config ENV in your OS user?

[Updated on: Wed, 18 November 2015 06:22]

Report message to a moderator

Re: nls_database_parameters CDB and PDB [message #644822 is a reply to message #644819] Wed, 18 November 2015 06:43 Go to previous messageGo to next message
sarrus
Messages: 5
Registered: November 2015
Junior Member
From SEED. Only have one CDB. Also NLS_TERRITORY, NLS_ISO_CURRENCY, NLS_DUAL_CURRENCY, NLS_DATE_LANGUAGE and so on, is different from the CDB.
Re: nls_database_parameters CDB and PDB [message #644825 is a reply to message #644822] Wed, 18 November 2015 07:54 Go to previous messageGo to next message
sarrus
Messages: 5
Registered: November 2015
Junior Member
I have read the document Doc ID 241047.1 section C.

C) The Database Parameters - NLS_DATABASE_PARAMETERS.

SQL>select * from NLS_DATABASE_PARAMETERS;

This are the NLS setting that where used during database creation time
If there were parameters set in the init.ora during database creation you see them here.
These are always defaulting to AMERICAN AMERICA if there were no parameters explicitly set in the init.ora during database creation time (!).


But when creating the PDB form SEED which init.ora file is in use?

Re: nls_database_parameters CDB and PDB [message #644834 is a reply to message #644825] Wed, 18 November 2015 08:33 Go to previous messageGo to next message
scapy
Messages: 12
Registered: November 2015
Location: Portugal
Junior Member
Normaly the pdb use the cdb character set. So if you create from seed I think it would use the same as the cdb.
In CDB you have one spfile/init to all environment (CDB/PDB's)

Connect to CDB and then in you PDB and make the following query:

select parameter,value from v$nls_parameters ;

and then

select parameter,value from nls_database_parameters ;

Use CODE please http://www.orafaq.com/forum/t/197794/

[Updated on: Wed, 18 November 2015 08:39]

Report message to a moderator

Re: nls_database_parameters CDB and PDB [message #644855 is a reply to message #644834] Thu, 19 November 2015 00:53 Go to previous message
sarrus
Messages: 5
Registered: November 2015
Junior Member
From CDB
select parameter,value from v$nls_parameters;

NLS_LANGUAGE;AMERICAN
nls_territory;AMERICA
nls_currency;$
nls_iso_currency;AMERICA
nls_numeric_characters;.,
nls_calendar;GREGORIAN
nls_date_format;DD-mon-rr
nls_date_language;AMERICAN
nls_characterset;AL32UTF8
nls_sort;BINARY
nls_time_format;HH.mi.ssxff am
nls_timestamp_format;DD-mon-rr hh.mi.ssxff am
nls_time_tz_format;HH.mi.ssxff am tzr
nls_timestamp_tz_format;DD-mon-rr hh.mi.ssxff am tzr
nls_dual_currency;$
nls_nchar_characterset;AL16UTF16
nls_comp;BINARY
nls_length_semantics;BYTE
nls_nchar_conv_excp;FALSE

select parameter,value from nls_database_parameters;

PARAMETER;VALUE
nls_rdbms_version;12.1.0.2.0
nls_nchar_conv_excp;FALSE
nls_length_semantics;BYTE
nls_comp;BINARY
nls_dual_currency;$
nls_timestamp_tz_format;DD-mon-rr hh.mi.ssxff am tzr
nls_time_tz_format;HH.mi.ssxff am tzr
nls_timestamp_format;DD-mon-rr hh.mi.ssxff am
nls_time_format;HH.mi.ssxff am
nls_sort;BINARY
nls_date_language;AMERICAN
nls_date_format;DD-mon-rr
nls_calendar;GREGORIAN
nls_numeric_characters;.,
nls_nchar_characterset;AL16UTF16
nls_characterset;AL32UTF8
nls_iso_currency;AMERICA
nls_currency;$
nls_territory;AMERICA
nls_language;AMERICAN

**************
From PDB

select parameter,value from v$nls_parameters;

PARAMETER;VALUE
nls_language;AMERICAN
nls_territory;AMERICA
nls_currency;$
nls_iso_currency;AMERICA
nls_numeric_characters;.,
nls_calendar;GREGORIAN
nls_date_format;DD-mon-rr
nls_date_language;AMERICAN
nls_characterset;AL32UTF8
nls_sort;BINARY
nls_time_format;HH.mi.ssxff am
nls_timestamp_format;DD-mon-rr hh.mi.ssxff am
nls_time_tz_format;HH.mi.ssxff am tzr
nls_timestamp_tz_format;DD-mon-rr hh.mi.ssxff am tzr
nls_dual_currency;$
nls_nchar_characterset;AL16UTF16
nls_comp;BINARY
nls_length_semantics;BYTE
nls_nchar_conv_excp;FALSE

select parameter,value from nls_database_parameters;

PARAMETER;VALUE
nls_rdbms_version;12.1.0.2.0
nls_nchar_conv_excp;FALSE
nls_length_semantics;BYTE
nls_comp;BINARY
nls_dual_currency;Kr.
nls_timestamp_tz_format;DD.mm.rrrr hh24.mi.ssxff tzr
nls_time_tz_format;HH24.mi.ssxff tzr
nls_timestamp_format;DD.mm.rrrr hh24.mi.ssxff
nls_time_format;HH24.mi.ssxff
nls_sort;NORWEGIAN
nls_date_language;NORWEGIAN
nls_date_format;DD.mm.rrrr
nls_calendar;GREGORIAN
nls_numeric_characters;,
nls_nchar_characterset;AL16UTF16
nls_characterset;AL32UTF8
nls_iso_currency;NORWAY
nls_currency;kr
nls_territory;NORWAY
nls_language;NORWEGIAN


Spfile CDB showing:

*.nls_language='AMERICAN'
*.nls_territory='AMERICA'


So why does PDB NLS_DATABASE_PARAMETERS differs from the CDB?
Previous Topic: How to gather various statistics with respect to CDB and PDB in 12c?
Next Topic: APEX in a multitenant database
Goto Forum:
  


Current Time: Thu Nov 23 08:34:42 CST 2017

Total time taken to generate the page: 0.03045 seconds