NLS_LANG setting in .profile

Shell Programming and Scripting
1

Hi

In my .Profile file initially I had given
export NLS_LANG="BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1"
and later I commented it.

When I connect to sqlplus from shell prompt and query
"select * from nls_session_parameters" it gives

PARAMETER VALUE
------------------------------ ----------------------------------------
NLS_LANGUAGE BRAZILIAN PORTUGUESE
NLS_TERRITORY BRAZIL

but when I connect to sqlplus using sqlplusw from my windows machine and
execute the same query
"select * from nls_session_parameters" it gives
PARAMETER VALUE
------------------------------ ----------------------------
NLS_LANGUAGE AMERICAN
NLS_TERRITORY AMERICA

I would like to know why oracle is behaving differently in the above 2 instances.

Kindly help me.
regards
Rajesh.

2

It's because you've started the instance or the listener (if you're using @service_name) when the NLS_LANG was set to PORTUGUESE_BRAZIL.WE8ISO8859P1 (or you've create d the database with that character set). You can overwrite this value at a session level (that's why on Windows you're seeing a different value, the one from your registry).