sqlplus 启动不了,提示sp2-0750
来源:互联网 发布:asp.net 获取域名 编辑:程序博客网 时间:2024/06/05 08:04
Sometimes when SQL*Plus is run, you see the error:
Message file sp1<Lang>.msb not found
Error 6 initializing SQL*Plus
This occurs when SQL*Plus was unable to find a message file during program initialization. The most common cause is that ORACLE_HOME has not been set. This prevents the message files being found and SQL*Plus would be unable to display error messages or text required for normal operation. Other causes are when the message file is corrupt or cannot be read.
Make sure that all the environment variables or registry entries needed to run SQL*Plus are set. The variables are platform specific but may include ORACLE_HOME, ORACLE_SID, NLS_LANG, ORA_NLS33, and LD_LIBRARY_PATH.
Also check that the file sp1XX.msb is present in the $ORACLE_HOME/sqlplus/mesg or %ORACLE_HOME%sqlplusmesg directory. The "XX" stands for the country prefix associated with your NLS_LANG environment variable. SQL*Plus reads only one of the sp1XX.msb files. For example sp1ja.msb is read if NLS_LANG is JAPANESE_JAPAN.JA16EUC. If NLS_LANG is not set, then the default (English language) sp1us.msb is used. Check that the appropriate file is of non-zero size and that the file permissions allow you to read it. Note the ".msb" files are binary. The contents may be meaningless when viewed or printed. If you are unsure which language file is being used, try unsetting NLS_LANG and run SQL*Plus to verify it can read the sp1us.msb file.
The error message has changed in SQL*Plus Release 9.0.1 to be more informative:
Error 6 initializing SQL*Plus
Message file sp1<Lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
Message file sp1<Lang>.msb not found
Error 6 initializing SQL*Plus
This occurs when SQL*Plus was unable to find a message file during program initialization. The most common cause is that ORACLE_HOME has not been set. This prevents the message files being found and SQL*Plus would be unable to display error messages or text required for normal operation. Other causes are when the message file is corrupt or cannot be read.
Make sure that all the environment variables or registry entries needed to run SQL*Plus are set. The variables are platform specific but may include ORACLE_HOME, ORACLE_SID, NLS_LANG, ORA_NLS33, and LD_LIBRARY_PATH.
Also check that the file sp1XX.msb is present in the $ORACLE_HOME/sqlplus/mesg or %ORACLE_HOME%sqlplusmesg directory. The "XX" stands for the country prefix associated with your NLS_LANG environment variable. SQL*Plus reads only one of the sp1XX.msb files. For example sp1ja.msb is read if NLS_LANG is JAPANESE_JAPAN.JA16EUC. If NLS_LANG is not set, then the default (English language) sp1us.msb is used. Check that the appropriate file is of non-zero size and that the file permissions allow you to read it. Note the ".msb" files are binary. The contents may be meaningless when viewed or printed. If you are unsure which language file is being used, try unsetting NLS_LANG and run SQL*Plus to verify it can read the sp1us.msb file.
The error message has changed in SQL*Plus Release 9.0.1 to be more informative:
Error 6 initializing SQL*Plus
Message file sp1<Lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
- sqlplus 启动不了,提示sp2-0750
- 执行sqlplus提示SP2-1503错误的问题解决
- Linux下Oracle-运行sqlplus问题(ORA-01031、ORA-12162、SP2-0667、SP2-0750、ORA-01034)及启动监听、实例和测试检索SELECT语句
- SQL SERVER 2008 升级到 SP2后,启动不了
- oracle for windows cmd登录sqlplus之SP2-0750
- dbms_application_info包 (sqlplus登陆数据库提示:访问程序包 DBMS_APPLICATION_INFO 时出错 sp2-0575)
- 电脑启动不了 错误提示0xc000000e
- android模拟器启动不了,出现乱码提示
- oracle 9.2.0.1升级补丁,安装完patch set后,oracle服务启动不了,提示“1053:服务没有及时响应启动或控制请求”,sqlplus连接提示“无法定位动态连接库orageneric9.dll”
- 常见问题:IIS“默认网站”启动不了,提示“发生意外错误ox8ffe2740"
- 迅雷启动不了,提示Atl71.dll文件丢失
- eclipse 启动不了,提示adt版本过低
- CentOS 7:firewalld启动不了 提示 Active: failed (Result: timeout)
- sqlplus as sysdba 进不了
- Tomcat 启动不了 进入服务启动时提示"windows不能在本地计算机启动Apache Tomcat...."
- Tomcat 启动不了 进入服务启动时提示"windows不能在本地计算机启动Apache Tomcat...."
- ORACLE启动SQLPLUS时提示TNS: 协议适配器错误(转载)
- sqlplus启动问题
- Java 获取客户端代码大全
- 用WINDBG看了一下QvodTerminal
- Div+CSS常见的十种错误总结
- asmlinkage
- [USACO 1.5.2] Prime Palindromes
- sqlplus 启动不了,提示sp2-0750
- JVM类加载机制(ClassLoader)源码解析(3)
- Java学习之路 --The Road Of Java Study
- 一步一步写算法(之静态查找)
- 中关村回收贩曝黑幕:翻新一部iPhone4可赚2000元
- proguard.cfg
- 常见处理器大小端
- 如何实现android中监听来电并生成悬浮窗体提示
- 半个小时移植Flash游戏到Android平台