Database driver event… Error occured loading library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application. – (Solved)


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

Advertisements

8 thoughts on “Database driver event… Error occured loading library [pmora8.dll]. System error encountered is 193. Erorr text is %1 is not valid Win32 application. – (Solved)

  1. 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

    Like

  2. 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

    Like

  3. 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

    Like

  4. 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

    Like

  5. 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

    Like

  6. 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

    Like

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s