oracle 11g ora nls10,ORACLE11g-ORA-12705: Cannot access NLS data files or invalid environment specif...

ORA-12705: Cannot access NLS data files or invalid environment specified .

解决方法：正确设置如下两个环境变量

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

export ORA_NLS10=/u01/app/oracle/product/11.2.0/dbhome_1/nls/data

这连个导出后立马就生效了。

可以执行sqlplus了。

下面是结果

[oracle@lizq data]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Thu May 5 04:03:39 2016

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

Connected to an idle instance.  蓝色的字代表链接到一个空实例

SQL>

正常的情况下应该是

Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit .....

这个时候在执行以下：Startup启动以下实例就可以了。

SQL> startup

ORACLE instance started.

Total System Global Area  776646656 bytes

Fixed Size   2217384 bytes

Variable Size 478153304 bytes

Database Buffers 289406976 bytes

Redo Buffers   6868992 bytes

Database mounted.

Database opened.

SQL> select * from v$version;

BANNER

--------------------------------------------------------------------------------

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production

PL/SQL Release 11.2.0.1.0 - Production

CORE11.2.0.1.0Production

TNS for Linux: Version 11.2.0.1.0 - Production

NLSRTL Version 11.2.0.1.0 - Production

SQL>