-
Hi everybody !!!
Can you help me...
I've a problem with the NLS_SORT parameter in init.ora.
I want to set this parameter to NLS_SORT = French. But when I change it after restart the DB, when I sort record, nothing is
different. And when I execute the V$NLS_PARAMETERS view, the NLS_SORT Parameter is always set to BINARY (default value).
Have I forget to do something ? Is my problem a bug ?
-----------------------------------------------------
OS Version : Windows NT4
RDBMS Version : Oracle 8.1.7
-
hi PWC,
check that you don't have any spelling mistakes.
try to startup mount pfile=Your_file_path and see what happens.
Best Regards
-
NLS_SORT in your init.ora will be ignored if NLS_LANG is set on the client machine.
Set NLS_SORT on the client.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Thanx,
but I always think that the problem is a spelling mistake. I've already try to write value like 'FRENCH', 'French' , FRENCH, French ....but no difference....
And when I start the DB, I've got no error message ...
So I've no Idea ...
-
NLS_SORT in your init.ora will be ignored if NLS_LANG is set on the client machine.
Set NLS_SORT on the client.
----------------------------------------------------------------------
No DB is installed on my client machine ....
And when I make sort and view v$nls_parameters on the Server Machine (where the DB is running), the result is the same ....
-
Originally posted by PWC
No DB is installed on my client machine ....
There is no need to install a DB on the client machine.
The point is that client libraries send an implicit ALTER SESSION command when the user logs in and thus override all your init.ora NLS_SORT settings.
And when I make sort and view v$nls_parameters on the Server Machine (where the DB is running), the result is the same ....
Is NLS_SORT set to binary? If not then remember that FTSc will be performed when sorting.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
The point is that client libraries send an implicit ALTER SESSION command when the user logs in and thus override all your init.ora NLS_SORT settings.
---------------------------------------------------------------------
Sorry but ....
How can I see the NLS_SORT parameter on the client machine if no DB is installed on it ?
Is NLS_SORT set to binary? If not then remember that FTSc will be performed when sorting.
---------------------------------------------------------------------
Yes the NLS_SORT is set to BINARY .... What is FTS ?
-
Originally posted by PWC
Sorry but ....
How can I see the NLS_SORT parameter on the client machine if no DB is installed on it ?
Via the registry. Do you know how?
Yes the NLS_SORT is set to BINARY .... What is FTS ?
FTS means Full Table Scan.
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
-
Via the registry. Do you know how?
---------------------------------------------------------------
Yes I think....
In the HKEYLOCALMACHINE\SOFTWARE/ORACLE/ORAHOME/ ...
Must I add a reg key like NLS_SORT=French ?
But why, when I set NLS_SORT to French in init on the server, when i look the V$NLS_PARAMETER view, this parameter is always set to BINARY ?
-
Originally posted by PWC
Must I add a reg key like NLS_SORT=French ?
Yes.
But why, when I set NLS_SORT to French in init on the server, when i look the V$NLS_PARAMETER view, this parameter is always set to BINARY ?
What do you get from select * from NLS_DATABASE_PARAMETERS;
Oracle Certified Master
Oracle Certified Professional 6i,8i,9i,10g,11g,12c
email: ocp_9i@yahoo.com
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|