oracle 错误 6 初始化 SQL*Plus
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6013508/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
Error 6 Initializing SQL*Plus
提问by santhoshkrishnan
When i open sqlplus it shows
当我打开 sqlplus 它显示
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
回答by DCookie
Generally speaking, you don't want to set ORACLE_HOME in a Windows environment - it's handled in the registry, and it's given me grief the times I've set it. Here is an Oracle Docon Oracle Homes.
一般来说，您不想在 Windows 环境中设置 ORACLE_HOME - 它是在注册表中处理的，并且在我设置它的时候让我感到悲伤。这是Oracle Homes 上的 Oracle Doc。
How many Oracle installations are on this computer?
这台计算机上有多少 Oracle 安装？
回答by Faruk AZAKLI
If ORACLE_HOME & ORACLE_BASE are all properly set, Make sure that someone does not delete some installation folders/files. I experienced similar problem, in one of my customers, Half of the folders in OraHome had been accidently deleted by the IT Guy.
如果ORACLE_HOME和ORACLE_BASE都设置正确，请确保没有人删除某些安装文件夹/文件。我遇到了类似的问题，在我的一位客户中，OraHome 中的一半文件夹被 IT 专家意外删除。
回答by inanutshellus
Ancient question with hopefully a helpful new answer! Ready?
古老的问题，希望有一个有用的新答案！准备好？
First, as others have said, you must set your ORACLE_HOME(e.g. export ORACLE_HOME=/opt/oracle/instantclient_12_2), but secondly, and oddly, you can't be cd'd into the oracle home when you run sqlplus!
首先，正如其他人所说，您必须设置您的ORACLE_HOME(eg export ORACLE_HOME=/opt/oracle/instantclient_12_2)，但其次，奇怪的是，cd当您运行 sqlplus 时，您无法进入 oracle home！
$ export ORACLE_HOME=/opt/oracle/instantclient_12_2
$ cd $ORACLE_HOME
$ sqlplus
Error 6 initializing SQL*Plus
SP2-0667: Message file sp1<lang>.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
$ cd /
$ sqlplus
SQL*Plus: Release 12.2.0.1.0 Production on Wed Jan 3 11:02:36 2018
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Enter user-name:
Whoaaa mind blown. It's... a feature?
哇哦，脑子进水了。这是……特点？
