Error occurred loading library [pmora8.dll] & invalid Win32 application

Are you getting this error when connecting to oracle, while creating a repository?

Database driver event...Error occurred loading library [pmora8.dll].
System error encountered is 193. Error text is %1 is not a valid Win32 application

If so, then most probably you are connecting to a 64 bit database which does not have its 32 bit client installed on your machine. Your informatica is 32 bit and will always use 32 bit client to connect to the database. However you do not have a 32 bit client installed on your machine. Informatica can not find it and therefore could not connect to 64 bit oracle. Result is that you get this error.

Solution is to install Oracle 32 bit client for your version of oracle. Get it from oracle download center. Make sure that the home of this Oracle client should be different from your originally installed oracle 64 bit client & the home-path is listed in PATH environment variable.

You can also get an error when you run sqlplus after install …. the error could be TNS:protocol adapter . Don’t worry and try to check by going to Start > Programs > {Your 64 bit oracle} > sqlplus. It could be that the 32 bit client’s sqlplus got fired up.

For more info on TNS read this post from EdStevens:-

https://forums.oracle.com/forums/thread.jspa?threadID=1982093