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.重启