InstantForum.NET v4.1.4FranklinFaces.com - Oracle & SQL Server Database Forums for all IT Professionalshttp://www.franklinfaces.com/no-reply@FranklinFaces.comFri, 10 Feb 2012 23:37:48 GMT20http://www.franklinfaces.com/Topic110-55-1.aspxI'm getting the following ora error message:<P>ERROR:<BR>ORA-12705: Cannot access NLS data files or invalid environment specified</P><P>When logging into oracle using sqlplus:</P><P>sqlplus '/ as sysdba';</P><P><BR>Message 133 not found; product=SQLPlus; facility=SP2<BR>: Release 9.2.0.6.0 - Production on Tue Apr 7 14:20:15 2009</P><P>Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.</P><P>ERROR:<BR>ORA-12705: Cannot access NLS data files or invalid environment specified</P><P>oerr ora 12705 shows the following:</P><P>12705, 00000, "Cannot access NLS data files or invalid environment specified"<BR>// *Cause: Either an attempt was made to issue an ALTER SESSION command<BR>// with an invalid NLS parameter or value; or the environment<BR>// variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly<BR>// specified, therefore the NLS data files cannot be located.<BR>// *Action: Check the syntax of the ALTER SESSION command and the NLS<BR>// parameter, correct the syntax and retry the statement, or<BR>// specify the correct directory path/values in the environment<BR>// variables.<BR></P><P>In my case this was very easy. My ORACLE_HOME was set to /u01/oracle/product/9.2.0.6 instead of /u01/oracle/product/10.2.0.3. Once I corrected that it went through just fine. But that may not be the only cause of this error. </P><P>Check that any of the following is true:</P><P>NLS_LANG parameter is correct or any other ORA_NLSxx is correct.</P><P>ORACLE_HOME parameter is set correct.</P><P>Check to see that you are in the correct $ORACLE_HOME during migration etc..</P><P>You can use the unset command in unix to unset your parameter or simply set/export them again.</P><P><BR> Tue, 07 Apr 2009 14:45:57 GMTAdmin