ORA-12705: Cannot access NLS data files or invalid environment specified
来源:互联网 发布:安捷伦数据采集仪 编辑:程序博客网 时间:2024/05/22 00:36
安装oracle 出现的提示:
ORA-12705: Cannot access NLS data files or invalid environment specified
搜索了一下ORA-12705 这个关键字,大概意思就是字符集的配置问题
今天写脚本把oracle的数据同步到mysql,在oracle导出的时候,发现是乱码,然后加了export NLS_LANG=AMERICAN_AMERICA.UTF-8在脚本前,结构脚本连接
oracle数据库时报上面的ORA-12705错误。后来找到原因是和/etc/sysconfig/i18n中的设置不匹配。
拿我的机器作为例子:
[root@oracle01 /]# cat /etc/sysconfig/i18n
LANG="zh_CN.UTF-8"
[root@oracle01 /]#
那我的NSL_LANG的设置应该是这样的:
NLS_LANG='SIMPLIFIED CHINESE_CHINA.AL32UTF8'; export NLS_LANG
也就是说 NLS_LANG的设置/etc/sysconfig/i18n 文件中的设置对应。
类似“SIMPLIFIED CHINESE_CHINA.AL32UTF8” 带空格需要加单引号'',其他的无空格可以不加。
export NLS_LANG="AMERICAN_AMERICN.AL32UTF8" Language Locale ID NLS_LANG
export NLS_LANG="CHINESE_CHINA.ZHS16GBK"
English (American)
en_US.UTF-8
AMERICAN_AMERICA.AL32UTF8
English (American)
en_US.ISO-8859-1
AMERICAN_AMERICA.WE8ISO8859P1
English (American)
en_US.ISO-8859-15
AMERICAN_AMERICA.WE8ISO8859P15
English (Australian)
en_AU.UTF-8
ENGLISH_AUSTRALIA.AL32UTF8
English (Australian)
en_AU.ISO-8859-1
ENGLISH_AUSTRALIA.WE8ISO8859P1
English (Australian)
en_AU.ISO-8859-15
ENGLISH_AUSTRALIA.WE8ISO8859P15
English (British)
en_GB.UTF-8
ENGLISH_UNITED KINGDOM.AL32UTF8
English (British)
en_GB.ISO-8859-1
ENGLISH_UNITED KINGDOM.WE8ISO8859P1
English (British)
en_GB.ISO-8859-15
ENGLISH_UNITED KINGDOM.WE8ISO8859P15
English (Ireland)
en_IE.UTF-8
ENGLISH_IRELAND.AL32UTF8
English (Ireland)
en_IE.ISO-8859-1
ENGLISH_IRELAND.WE8ISO8859P1
English (Ireland)
en_IE.ISO-8859-15
ENGLISH_IRELAND.WE8ISO8859P15
German
de_DE.UTF-8
GERMAN_GERMANY.AL32UTF8
German
de_DE.ISO-8859-1
GERMAN_GERMANY.WE8ISO8859P1
German
de_DE.ISO-8859-15
GERMAN_GERMANY.WE8ISO8859P15
French
fr_FR.UTF-8
FRENCH_FRANCE.AL32UTF8
French
fr_FR.ISO-8859-1
FRENCH_FRANCE.WE8ISO8859P1
French
fr_FR.ISO-8859-15
FRENCH_FRANCE.WE8ISO8859P15
Italian
it_IT.UTF-8
ITALIAN_ITALY.AL32UTF8
Italian
it_IT.ISO-8859-1
ITALIAN_ITALY.WE8ISO8859P1
Italian
it_IT.ISO-8859-15
ITALIAN_ITALY.WE8ISO8859P15
Spanish
es_ES.UTF-8
SPANISH_SPAIN.AL32UTF8
Spanish
es_ES.ISO-8859-1
SPANISH_SPAIN.WE8ISO8859P1
Spanish
es_ES.ISO-8859-15
SPANISH_SPAIN.WE8ISO8859P15
Spanish (Mexico)
es_MX.UTF-8
MEXICAN SPANISH_MEXICO.AL32UTF8
Spanish (Mexico)
es_MX.ISO-8859-1
MEXICAN SPANISH_MEXICO.WE8ISO8859P1
Spanish (Mexico)
es_MX.ISO-8859-15
MEXICAN SPANISH_MEXICO.WE8ISO8859P15
Portuguese (Brazilian)
pt_BR.UTF-8
BRAZILIAN PORTUGUESE_BRAZIL.AL32UTF8
Portuguese (Brazilian)
pt_BR.ISO-8859-1
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1
Portuguese (Brazilian)
pt_BR.ISO-8859-15
BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P15
Japanese
ja_JP.EUC-JP
JAPANESE_JAPAN.JA16EUC
Japanese
ja_JP.UTF-8
JAPANESE_JAPAN.AL32UTF8
Korean
ko_KR.EUC-KR
KOREAN_KOREA.KO16KSC5601
Korean
ko_KR.UTF-8
KOREAN_KOREA.AL32UTF8
Chinese (simplified)
zh_CN.GB18030
SIMPLIFIED CHINESE_CHINA.ZHS32GB18030
Chinese (simplified)
zh_CN.UTF-8
SIMPLIFIED CHINESE_CHINA.AL32UTF8
Chinese (traditional)
zh_TW.BIG5
TRADITIONAL CHINESE_TAIWAN.ZHT16BIG5
Chinese (traditional)
zh_TW.UTF-8
TRADITIONAL CHINESE_TAIWAN
- ORA-00604 and ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified 错误
- ORA-12705: Cannot access NLS data files or invalid environment specified 错误
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ora-12705 Cannot access NLS data files or invalid environment specified
- 错误整理: ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified 错误
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified 另类解决方案
- ORA-12705: Cannot access NLS data files or invalid environment specified
- 22-ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified
- ORA-12705: Cannot access NLS data files or invalid environment specified 错误
- 错误:ORA-12705: Cannot access NLS data files or invalid environment specified
- ORACLE11g-ORA-12705: Cannot access NLS data files or invalid environment specified
- php接口测试 curl实现GET/POST
- 鸟哥私房菜学习笔记六 Bash
- 逆序对 (归并排序)
- html5开发之viewport使用
- MySQL连接之C语言API
- ORA-12705: Cannot access NLS data files or invalid environment specified
- 将Android项目打包成APK文件
- Largest Rectangle in Histogram
- 【BMI指数计算器V4.0】项目实战
- Java进阶(九)正则表达式
- 正则表达式得到图片URL
- 聚簇索引和非聚簇索引
- c语言mysql数据库事务开始、提交、回滚范例
- 30天自制操作系统day27