12.1 or 12.2
Rajeshwaran, Jeyabal, November 23, 2016 - 11:06 am UTC
November 24, 2016 - 4:10 am UTC
Nice input, and remiss of me not to mention Mike's upgrade blog.
question NLS
A reader, December 07, 2016 - 1:55 pm UTC
hello
do i need to set the ORA_NLS10 variable in 12c?
and what is for? pls elaborate
December 07, 2016 - 2:14 pm UTC
ORA_NLSxx is used to indicate where Oracle RDBMS/client software can locate the definitions of Charactersets (used in NLS_LANG or as NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET), NLS_SORT, NLS_LANGUAGE (or derived/related parameters) or NLS_TERRITORY (or derived/related parameters).
Those definitions are stored in .nlb files who can be found in the ORA_NLSxx directory.
When using 9i or above there is no need to explicit define the ORA_NLSxx parameter unless a different directory setting is needed.
Example?
A reader, December 08, 2016 - 6:52 am UTC
Thank you Connor.
So why xx? And when is 10 or 33 or..?
Since from 9i not required to be defined ..
Could give example when it us required in the parameters environment?
December 10, 2016 - 1:27 am UTC
From 9i upwards, if your characterset definitions are in the default location, then you do not need to set the ORA_NLS.. parameter. 'xx' being representative of *any* value (10, etc)