Home » RDBMS Server » Server Utilities » Cannot access NLS data files or invalid environment specified (oracle 10g)
Cannot access NLS data files or invalid environment specified [message #456144] Sat, 15 May 2010 02:58 Go to next message
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
Michel Cadot
Messages: 67946
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
Previous Topic: DIM-00014: Cannot open the Windows NT Service Control
Next Topic: insert data without writing insert statement in oracle
Goto Forum:
  


Current Time: Fri Sep 17 08:40:37 CDT 2021