infamatica加载库pmora8.dll错误126,193解决

pmora8.dll是infamatica软件重要组件，大多数infamatica报错都是因为pmora8.dll库加载失败，错误代码126或193，IT猫扑小编特别整理了网上的多个解决方案，供大家参考

pmora8.dll错误原因

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

遇到系统错误是.错误文本时%1不是有效的Win32程序

pmora8.dll报错原文

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

pmora8.dll报错解决

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

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

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

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

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

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

6.重启