Database driver error when loading data with Informatica into Oracle XE 10 g

Question

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.

Answer 1

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

1.PM_HOME - must point to the directory where informatica is installed
2.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
3.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.