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

3610阅读 0评论2015-05-26 aslo_brook
分类:Oracle




[oracle@nagios bin]$ oerr ora 12705

12705, 00000, "Cannot access NLS data files or invalid environment specified"

// *Cause: Either an attempt was made to issue an ALTER SESSION command

//         with an invalid NLS parameter or value; or the environment

//         variable(s) NLS_LANG, ORA_NLSxx, or ORACLE_HOME was incorrectly

//         specified, therefore the NLS data files cannot be located.

// *Action: Check the syntax of the ALTER SESSION command and the NLS

//          parameter, correct the syntax and retry the statement, or

//          specify the correct directory path/values in the environment

//          variables.

原因:NLS_LANGORA_NLSxxORACLE_HOME 环境变量设定有误

这里少一个字符
NLS_LANG=AMERICAN_AMERICA.AL32UTF8;export NLS_LANG

[oracle@PCQASDG01 dbs]$ source /home/oracle/.bash_profile

异常解决

[oracle@PCQASDG01 dbs]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.2.0 Production on Tue May 26 14:19:52 2015

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

Connected to an idle instance.

SQL>




上一篇:Oracle 手动创建数据库
下一篇:ORA-20011: Approximate NDV failed