oracle sqlplus 无法启动。想要 *.msb 文件
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/18321283/
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
sqlplus fails to start. wants *.msb files
提问by Randall Stevens
Installed sqlplus from oracle downloads. Unpacked both files instantclient-basic-linux.x64-12.1.0.1.0.zip instantclient-sqlplus-linux.x64-12.1.0.1.0.zip sqlplus fails to start with this error:
从 oracle 下载安装 sqlplus。解压两个文件 Instantclient-basic-linux.x64-12.1.0.1.0.zip instantclient-sqlplus-linux.x64-12.1.0.1.0.zip sqlplus 无法启动，出现以下错误：
Error 6 initializing SQL*Plus SP2-0667: Message file sp1.msb not found SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
错误 6 初始化 SQL*Plus SP2-0667：找不到消息文件 sp1.msb SP2-0750：您可能需要将 ORACLE_HOME 设置为您的 Oracle 软件目录
I assume I don't have to install the whole oracle server for sql client to run. and basic-linux zip is deemed to be everything you need to run OCI apps which sqlplus is.
我假设我不必安装整个 oracle 服务器来运行 sql 客户端。basic-linux zip 被认为是运行 sqlplus 所在的 OCI 应用程序所需的一切。
Where do I get these .msb files?
我从哪里获得这些 .msb 文件？
采纳答案by Alex Poole
You may need to set ORACLE_HOME to your Oracle software directory
您可能需要将 ORACLE_HOME 设置为您的 Oracle 软件目录
You need to set ORACLE_HOME to wherever you've unzippd the files:
您需要将 ORACLE_HOME 设置为解压缩文件的位置：
export ORACLE_HOME=/path/to/instantclient
You probably also want to add that to your PATH, and might need to add it to LD_LIBRARY_PATH. Which is actually all the instructions tell you to do.
您可能还想将其添加到 PATH，并且可能需要将其添加到 LD_LIBRARY_PATH。这实际上是所有指令告诉你去做的。
回答by HSeb72
ensure to have you ORACLE_HOME/sqlplus, ORACLE_HOME/sqlplus/mesg directories allowed for read and execute, and all the ORACLE_HOME/sqlplus/mesg/*.msb files readable too when trying to use sqlplus with a non oracle owner user.
确保您的 ORACLE_HOME/sqlplus、ORACLE_HOME/sqlplus/mesg 目录允许读取和执行，并且在尝试与非 oracle 所有者用户一起使用 sqlplus 时，所有 ORACLE_HOME/sqlplus/mesg/*.msb 文件也是可读的。
回答by Mark Umpenhour
For anyone that is using 12C on up, and you are just setting up a DB for your desktop(not sure about servers). You do not need to have the oracle_home as an environmental variable for your account. If you created one, then just delete and see what happens. I have installed 12C and 19c oracle db, and I'm able to use sqlplus just fine. I did not do anything fancy with the install. I just selected a virtual user and basically clicked next for everything else.
对于任何使用 12C 并且您只是为桌面设置数据库的人（不确定服务器）。您不需要将 oracle_home 作为您帐户的环境变量。如果您创建了一个，那么只需删除并查看会发生什么。我已经安装了 12C 和 19c oracle db，我可以很好地使用 sqlplus。我没有做任何花哨的安装。我刚刚选择了一个虚拟用户，然后基本上点击了下一步。
