-
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
-
OLD : nls_sor=binary
SHOULD : nls_sort=binary
-
it is nls_sort=binary in the initPROD1.ora , it was a typo error in this forum
-
Try putting single quotes around that parameter's value.
nls_numeric_characters = '.,'
