DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: nls_numeric_characters help

  1. #1
    Join Date
    Sep 2001
    Posts
    76
    Hi friends,

    I get ora -12700: Invalid NLS parameter value(nls_numeric_characters)
    when i start the 8.1.7 database on sun solaris 2.6

    in my initPROD.ora the parameter settings are
    nls_territory= america
    nls_language=american
    nls_numeric_characters = .,
    nls_date_format=DD-MON-RR
    nls_sor=binary

    if I comment out nls_numeric_characters ,the database starts

    what should i put that as,what change shouldi make?
    thanks

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    OLD : nls_sor=binary

    SHOULD : nls_sort=binary

  3. #3
    Join Date
    Sep 2001
    Posts
    76
    it is nls_sort=binary in the initPROD1.ora , it was a typo error in this forum

  4. #4
    Join Date
    Apr 2001
    Posts
    118
    Try putting single quotes around that parameter's value.

    nls_numeric_characters = '.,'

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