bash 从 UNIX 运行 sql*loader 时出现消息 2100
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/10413553/
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
Message 2100 when run sql*loader from UNIX
提问by May12
I have .sh file with the next content:
我有包含下一个内容的 .sh 文件：
#!/bin/bash
echo -------- uploader.sh v 0.1 --------
ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1/bin/
export ORACLE_HOME
PATH=$ORACLE_HOME
export PATH
sqlldr userid=PR/0611@database control=control_file.ctl LOG=fb_log.log errors=100
So, i want to run sql loader and upload data. When i run uploader.sh i receive the next message from unix:
所以，我想运行 sql loader 并上传数据。当我运行 uploader.sh 时，我收到来自 unix 的下一条消息：
Message 2100 not found; No message file for product=RDBMS, facility=ULMessage 2100 not found; No message file for product=RDBMS, facility=UL
找不到消息 2100；没有产品=RDBMS 的消息文件，设施=ULMessage 2100 未找到；没有产品=RDBMS、设施=UL 的消息文件
I've read about it and made conclusion that the problem is in the enviroment variables. Could you help me with desision of this mistake?
我已经阅读并得出结论，问题出在环境变量中。你能帮我解决这个错误吗？
回答by Satya
change this line
改变这一行
ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1/bin/
to
到
ORACLE_HOME=/opt/app/oracle/product/10.2.0/db_1
and see it
看到它
also check if you have ORAUS.MSB on your system
还要检查您的系统上是否有 ORAUS.MSB
回答by Marcelo Lima
Declare the environment variables inside the shell that will be executed and which makes the call in sqlldr. It worked for me.
在 shell 中声明将被执行并在 sqlldr 中进行调用的环境变量。它对我有用。
Example:
例子：
#!/bin/bash
set +vx
LD_LIBRARY_PATH=/oracle/app/oracle/product/11.2.0/client_1/lib
ORACLE_HOME=/oracle/app/oracle/product/11.2.0/client_1
PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin:$LD_LIBRARY_PATH:$ORACLE_HOME/rdbms/mesg
export LD_LIBRARY_PATH
export ORACLE_HOME
export PATH
sqlldr userid=USER/PWD@BANK control=control_file.ctl LOG=fb_log.log errors=100
回答by user3811820
Late to the party but I had a similar issue on Windows today, found lots of posts referring to ORAUS.MSB, but I already had that. To resolve I copied ULUS.MSB from another machine - might help someone.
聚会迟到了，但我今天在 Windows 上遇到了类似的问题，发现了很多关于 ORAUS.MSB 的帖子，但我已经有了。为了解决这个问题，我从另一台机器复制了 ULUS.MSB - 可能对某人有帮助。
