使用Informatica将数据加载到Oracle XE 10 g时出现数据库驱动程序错误

neekobn8 于 2022-12-11 发布在 Oracle

关注(0)|答案(2)|浏览(208)

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 repository is on SQL Server 2012.

oracle

来源：https://stackoverflow.com/questions/15637513/database-driver-error-when-loading-data-with-informatica-into-oracle-xe-10-g

2条答案

按热度按时间

y1aodyip1#

Well, there are a few variables that need to be set before your informatica runtime environment can be considered ready to run jobs...

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.
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.
hth

赞(0）回复(0）举报 2022-12-11

bpzcxfmw2#

From the error message, it appears that you have installed 32-bit Oracle client and 64-bit 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:

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

赞(0）回复(0）举报 2022-12-11

我来回答

使用Informatica将数据加载到Oracle XE 10 g时出现数据库驱动程序错误

2条答案

相关问题

热门标签

最新问答