Chinaunix首页 | 论坛 | 博客
  • 博客访问: 57383
  • 博文数量: 9
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 105
  • 用 户 组: 普通用户
  • 注册时间: 2014-05-16 16:45
文章分类
文章存档

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_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>




阅读(3562) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~