使用 Informatica 将数据加载到 Oracle XE 10 g 时出现数据库驱动程序错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/15637513/
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
Database driver error when loading data with Informatica into Oracle XE 10 g
提问by JEdward
I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:
我正在尝试在 Oracle XE 10g 数据库中加载。当我运行 Informatica PowerCenter 工作流时，出现以下错误：
CMN_1022 Database driver error...
CMN_1022 [Database driver event...
Error occurred loading library [pmora8.dll].
System error encountered is 193.
Error text is
%1 is not a valid Win32 application.
.]
Any ideas what might be causing this error? My environment is as follows:
任何想法可能导致此错误？我的环境如下：
- Windows Server 2008 R2
- Informatica PowerCenter 9.5
- Oracle XE 10 G
- 视窗服务器 2008 R2
- Informatica PowerCenter 9.5
- 甲骨文 XE 10 G
Powercenter repository is on SQL Server 2012.
Powercenter 存储库位于 SQL Server 2012 上。
回答by Raghav
Well, there are a few variables that need to be set before your informatica runtime environment can be considered ready to run jobs...
好吧，在您的 informatica 运行时环境可以被视为准备好运行作业之前，需要设置一些变量......
- PM_HOME - must point to the directory where informatica is installed
- LIBRARY_HOME or LD_LIBRARY_PATH - depending upon whether you are in windows world or unix (respectively), this variable should include library files from informatica. Typically this should include $PM_HOME/bin
- PATH - this must include the executables from informtica as well as any other subsystems you might be accessing.
- PM_HOME - 必须指向安装 informatica 的目录
- LIBRARY_HOME 或 LD_LIBRARY_PATH - 取决于您是在 windows world 还是 unix（分别），此变量应包含来自 informatica 的库文件。通常这应该包括 $PM_HOME/bin
- PATH - 这必须包括来自 informtica 的可执行文件以及您可能正在访问的任何其他子系统。
Its possible that these variables are not setup/created in windows/unix when you first install the informatica software, don't hesitate in creating them afresh. However, if they already exist (e.g. PATH would exist already), make sure you append (and not replace) the new values.
当您第一次安装 informatica 软件时，这些变量可能没有在 windows/unix 中设置/创建，不要犹豫，重新创建它们。但是，如果它们已经存在（例如 PATH 已经存在），请确保附加（而不是替换）新值。
hth
第
回答by Sadagopan
From the error message, it appears that you have installed 32-bit Oracle client and 64-bit PowerCenter.
从错误消息来看，您似乎已经安装了 32 位 Oracle 客户端和 64 位 PowerCenter。
A 64 bit PowerCenter works only with 64 bit oracle client. Please install 64-bit Oracle client, restart PowerCenter services and check if the session succeeds.
64 位 PowerCenter 仅适用于 64 位 oracle 客户端。请安装 64 位 Oracle 客户端，重新启动 PowerCenter 服务并检查会话是否成功。
Few comments about the discussion in this thread:
关于此线程中的讨论的评论很少：
- Make sure %oracle_home%/bin is added as a first entry in the PATH variable. Informatica recommends so.
- After you change PATH variable, Informatica services needs to be restarted for that to take effect.
- pmora8.dll will be available in %INFA_HOME%/server/bin
- PM_HOME is for PowerCenter 7.x or earlier versions. From 8.x it is INFA_HOME
- 确保将 %oracle_home%/bin 添加为 PATH 变量中的第一个条目。Informatica 建议这样做。
- 更改 PATH 变量后，需要重新启动 Informatica 服务才能生效。
- pmora8.dll 将在 %INFA_HOME%/server/bin 中可用
- PM_HOME 适用于 PowerCenter 7.x 或更早版本。从 8.x 开始，它是 INFA_HOME
