使用Informatica将数据加载到Oracle XE 10 g中时，数据库驱动程序错误 [英] Database driver error when loading data with Informatica into Oracle XE 10 g

问题描述

我正在尝试在Oracle XE 10g数据库中加载。运行Informatica PowerCenter工作流时，出现以下错误：

I'm trying to load within an Oracle XE 10g database. When I run an Informatica PowerCenter Workflow, I get a following error:

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

Powercenter存储库位于SQL Server 2012上。

Powercenter repository is on SQL Server 2012.

推荐答案

从错误消息中，您似乎已经安装了32位Oracle客户端和64位PowerCenter。

From the error message, it appears that you have installed 32-bit Oracle client and 64-bit PowerCenter.

64位PowerCenter仅与64位oracle客户端一起使用。请安装64位Oracle客户端，重新启动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.

对此线程中的讨论的评论很少：

Few comments about the discussion in this thread:

• 确保将％oracle_home％/ bin作为第一个条目添加到PATH变量中。 Informatica建议这样做。


• 更改PATH变量后，Informatica服务需要重新启动才能生效。


• pmora8.dll将可用在％INFA_HOME％/ server / bin
中

• PM_HOME适用于PowerCenter 7.x或更早版本。从8.x开始是INFA_HOME

• 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

这篇关于使用Informatica将数据加载到Oracle XE 10 g中时，数据库驱动程序错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！