Cannot access NLS data files or invalid environment specified [message #456144] |
Sat, 15 May 2010 02:58 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
sandy_tp
Messages: 9 Registered: May 2010 Location: india
|
Junior Member |
|
|
Hi,
I exported oracle database from one server in a dmp file. then i imported it in another oracle database server. when i saw the imported data the columns which were storing german data is in rubbish characters.
then i remember that the database from where i exported is having nls language as german. i executed this statement to set the nls on the new server
alter system set nls_lang=german SCOPE=SPFILE
but now my database is not getting started always giving me error -
cannot access NLS data files or invalid environment specified.
i also set the path NLS_LANG=german in the solaris environment.
Regards
Sandy
|
|
|
Re: Cannot access NLS data files or invalid environment specified [message #456147 is a reply to message #456144] |
Sat, 15 May 2010 03:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68676 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
It depends on:
1/ You source database character set
2/ Your export character set (see NLS_LANG at this time)
3/ Your import character set (see NLS_LANG at this time, "german" is NOT a character set but a language, so character set is default one: US7ASCII)
4/ your target database character set
To get it correct: export with source database character set, import with target database character set.
Regards
Michel
|
|
|