Technology Stack - EBS (MOSC)

MOSC Banner

result of "show parameter" for some nls parameters got changed to upper case

edited Feb 9, 2016 2:50AM in Technology Stack - EBS (MOSC) 2 commentsAnswered

Hi,

I have a question regarding the pfile for DB(EBS environment).

The result of "show parameter" for some nls parameters got changed to upper case from 11gR2 like below:

11.1.0.7 and lower:

show parameter

nls_comp       binary

nls_language   american

nls_sort       binary

nls_territory  america

11.2.0.2 and higher:

show parameter

nls_comp       BINARY

nls_language   AMERICAN

nls_sort       BINARY

nls_territory  AMERICA

*Regardless of DB version, it always returns the value as upper case for standalone DB(Not EBS environment).

but depends on the DB version, the result of "show parameter" are different as mentioned above.

We have a program which checks the result of "show parameter" and it distinguishes between upper- and lower-case,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center