Pb with NLS_SORT parameter
DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: Pb with NLS_SORT parameter

  1. #1
    Join Date
    Sep 2001
    Posts
    34

    Question

    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

  2. #2
    Join Date
    Dec 2001
    Posts
    320
    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

  3. #3
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  4. #4
    Join Date
    Sep 2001
    Posts
    34
    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 ...


  5. #5
    Join Date
    Sep 2001
    Posts
    34
    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 ....

  6. #6
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  7. #7
    Join Date
    Sep 2001
    Posts
    34
    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 ?

  8. #8
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    email: ocp_9i@yahoo.com

  9. #9
    Join Date
    Sep 2001
    Posts
    34
    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 ?

  10. #10
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    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
    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
  •  



Click Here to Expand Forum to Full Width