[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now


NLS_COMP and NLS_SORT Initialization Paramaters

Posted on 2006-03-28
Medium Priority
Last Modified: 2012-05-05
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.

Question by:BrianG
1 Comment
LVL 16

Accepted Solution

RCorfman earned 2000 total points
ID: 16317893
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.

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
Suggested Courses

834 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question