Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

problem with nls_numeric_characters

906964Dec 22 2011 — edited Dec 22 2011

Hi,

can any one give me the solution for the following problem.

i changed nls_numeric_characters value from default to AL16UTF16,again second time i changed to " ,." due to performance problem.

when I am taking export ,getting this error: unable to recognize character set.

Problem description:

Value of nls_numeric_characters set to ”AL16UTF16” from default NULL or Blank :- we have changed this parameter as one of the suggestion provided by our application OEM for performance tuning. This setting was done on 22 nd Oct 2011. No problem reported during after changing the parameter from database side.

Ø Value of nls_numeric_characters set to ” ., ” from ”AL16UTF16” :- after making the previous change, we observed that some small functional problem of object creation from back end started. After reporting it to Dassault Systems(OEM) they suggested to change value of nls_numeric_characters set to ”.,” from ”AL16UTF16”.

Ø We made this change on 13 th Dec 2011. This time problem of object creation got resolved but next day we observed that error “unable to recognize character set” appeared in oracle export dump logs and it failed. From that day export dump is not happening with the same error. We even tried to start the instance with some old pfile (13 th Dec 2011 and before 22 nd Dec 2011) but the same error continued.

Unable to take export dump in Oracle”

Edited by: user8403888 on Dec 22, 2011 3:03 AM