2015年(9)
分类: Oracle
2015-05-26 16:34:26
[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_LANG、ORA_NLSxx、ORACLE_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>