NLS_COMP and NLS_SORT Initialization Paramaters

I have tried setting the initialization parameters in the SPFile for NLS_COMP=ansi and NLS_SORT=binary_ci.  I apply and recycle the server and the parameters are set.  However, when I perform a query from SQLPLUS, the database is still case sensitive.  If I do SHOW PARAMETER NLS_COMP, the proper values are set.  I can run ALTER SESSIONS and set the parameters to get the query to be case insensitive, but that is not ideal.

I am running Oracle 10gR2.

Thanks,
Brian
BrianGAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

RCorfmanCommented:
I would think that it would work if the sessions showt that. run this and see what it shows...
select * from nls_session_parameters where parameter in ('NLS_COMP','NLS_SORT');
to assure they really are set in the session.

If they aren't it sounds like it miht be a bug of some sort, but I'm not sure what all can affect a session logging in like that. I'm primarily a developer.

At a minimum, to fix this, you could use a login trigger. I use these quite a lot now to assure that the nls parameters are the way I want them and also for setting the schema and I've been using an application context so I set that there too. Anyway, I suspect you already new this... running the alter session in a login trigger is probably the easiest fix... if not a complete answer.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.