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

蔚落 2022-08-21 14:42 12阅读 0赞

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>