informatica 数据库驱动程序事件，加载库[pmora8.dll]时出错。

来源：互联网发布：矩阵连乘a1 a2 编辑：程序博客网时间：2024/05/17 09:10

错误：数据库驱动程序事件，加载库[pmora8.dll]时出错。遇到系统错误是193.错误文本时%1不是有效的Win32程序

Error while Loading pmora8.dll. System error encountered is 193. Error text is %1 is not a valid Win32 application.

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

这个错误很常见一般解决步骤如下：

1.建议把重点放在oracle 数据库上，客户端服务器版本并不需要一致，但是为了减少oracle的客户端服务器之间设置问题带来的故障，建议使用版本一致，位数一致的客户端服务。infamatica 64位的服务端要求服务器上安装的客户端必须是64位的。

2.找到了prnora8.dll的目录，添加至环境变量path。

3.检查oracle_home系统变量为安装的新的oracle客户端路径

4. 把oracle的新安装的客户端路径加到系统变量path里面。

5.检查客户端和服务器的TNS连接，tnsping相应的tnsname 是否联通。

6.重启

0 0