Scenario
I am trying to install Informatica Server and client 9.0.1 64bit on my Windows 7 64 bit operating system. I have my Oracle Server 64 bit also on the same system. I try to configure the Power Center Repository Services after the Informatica Server Installation but Im getting the error
Database driver event… Error occured laoding library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application.
Solution
Now in order to configure the Power Center Repository and Integration Services, there are few things we have to make sure. However in order to configure the Power Center Repository Services we should also install Oracle Client 32 bit in the same machine. The reason is Informatica can talk to the server only through the 32 bit Client machine.
So
a. Install Oracle 32 bit client in your system . For the downloadable click below
Oracle Client 11G R2 32 bit
a.1 When installing the client make sure you choose the second option Administrator to get the path to store the tnsnames.
b. After installation copy the tns names. ora from the server to the client.
c. Make sure that the Client path has been set in the PATH Varible in the Environment Variables.
d. Restart the system and Configure the Power Center Repository Services again
Its All About Data - By Jethin Abraham 
could you elaborate on how with pics?
LikeLike
Please install the client and then copy the tnsnames from the server to client if you have both on the same system.
Then make sure after the oracle client 32 bit is installed it is present in the Path Variables
Once these steps are done restart it. I do not have screenshots as of now but still if you have difficulties let me know.
Regards
Jethin
LikeLike
Hi Jethin,
Greetings!
I have similar issue and not able to resolve, can you please help me with navigations and screenshots to do the resolution steps will be highly appreciated.
I'm able to see the TNSNAMES.ORA file in server and have no clue how to copy it to the Client, please provide me with navigations. And also please let me know how to setup the environment variables. I have setup environment variable for INFA_JAVA_OPTS=>value(C:\Informatica\9.01\java\bin) and also observed that another variables are already set 1) INFA_RESOURCES=> value (C:\Informatica\9.01\clients\DeveloperClient\bin); 2) IMF_CPP_RESOURCE_PATH=> value (C:\Informatica\9.01\clients\DeveloperClient\bin); 3) path=> (C:\Informatica\9.0.1\clients\tools\datadirect;C:\Informatica\9.0.1\clients\DeveloperClient\bin;C:\Informatica\9.0.1\tools\datadirect;C:\oraclexe\app\oracle\product\11.2.0\server\bin;;C:\Program Files (x86)\HP SimplePass\x64;C:\Program Files (x86)\HP SimplePass\;;C:\Program Files (x86)\Intel\iCLS Client\;C:\Program Files\Intel\iCLS Client\;%SystemRoot%\system32;%SystemRoot%;%SystemRoot%\System32\Wbem;%SYSTEMROOT%\System32\WindowsPowerShell\v1.0\;C:\Program Files (x86)\Windows Live\Shared;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x86;C:\Program Files (x86)\Intel\OpenCL SDK\3.0\bin\x64;C:\Program Files\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\DAL;C:\Program Files (x86)\Intel\Intel(R) Management Engine Components\IPT;C:\Program Files (x86)\MySQL\MySQL Utilities 1.3.4\)
Thanks in anticipation,
Venkat
cvrk09@gmail.com
LikeLike
Hi Venkat,
When you install Oracle Client make sure you install the Adminstrator option not the simple install(The 3 option). Once you do that you will get the same folder path as that of the server.
The path in the client is C:\appclient\product\11.2.0\client_1\network\admin where you will have to copy paste the tnsnames.ora.
Make sure that the client is set in the environment variable.
Try to do a test connection with the TNS names from the client using Oracel SQL Developer in the client
If everything suceeds just restart the services and you will see the error will be gone.
Hope I have made my self clear. If not please reply to this and I can help you out with this.
Thanks
Jethin
LikeLike
Thanks for your quick response Jethin and appreciate it!
I have installed Oracle 11g Express edition and I don't see any Administrator option and able to query the database using sql developer. Also I have downloaded MySQL and able to query the database and don't see any issues.
I'm on EST, can I call you to discuss further. If not comfortable to share your Tel.No, please forward it my email id (cvrk09@gmail.com) and can call you based on your schedule to get this error fixed.
Thanks, Venkat
LikeLike
Hello Jethin,
As informed earlier I have Oracle 11g Express edition 32 bit installed on my computer and not working, I did not heard back any details from you, I was struck at point just and getting the same error logs as your screenshot, which I have explained earlier. Can you help me please. If you can share your contact details over to my personal email id (cvrk09@gmail.com) can contact you.
Thanks in anticipation, Venkat
LikeLike
Hi Jethin,
I am also facing similar issue while creating repository service. We have Oracle 11g 64 bit server installed on a Linux machine. Informatica 9.1 64 bit is installed on another windows machine. when i try to create repository service it gives an error as
Database driver event…Error occurred loading library
[pmora8.dll].
System error encountered is 126. Error text is The specified module could
not be found. .
Do i have to install oracle 64 bit client on the windows machine having informatica server.
Thanks
LikeLike
I have the same error “Database driver event… Error occured loading library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application.”
*************** BUT
I have Oracle 32bit Server installed and PowerCenter Server is 64bit.. Win7 64bit..
Do you have any solution?
I am currently downloading Oracle Client 32bit to see if that works..
LikeLike