Srini Chavali wrote:You can set NLS_LANG But it will not be permanent Solution .
Pl post exact OS and database versions. The solution provided above is incorrect and irrelevant. Recreating the database will not solve your issue.
The NLS_LANGUAGE parameter is derived based on the NLS_LANG value.
Set NLS_LANG appropriately - http://www.oracle.com/technetwork/database/globalization/nls-lang-099431.html
really shows the string 'AMERICAN_AMERICA.KO16MSWIN949'. If this is true, then somebody manually modified the SYS.PROPS$ table, which is strictly forbidden. Such value should never come up as the result of this particular query. It would be valid only from the query:
SELECT VALUE FROM nls_database_parameters WHERE PARAMETER = 'NLS_LANGUAGE';
A database returning 'AMERICAN_AMERICA.KO16MSWIN949' from NLS_DATABASE_PARAMETERS must be repaired with help of Oracle Support before it can be considered valid and supported.
SELECT USERENV('LANGUAGE') FROM DUAL;