Hi,
Please read the content.it is little big but I tried to explain the issue in detail for better response.
I am trying to install Informatica MDM in a server for which there is a step to set up the database store. Informatica provides a script which has to be run for installing hub store which does following
1) creates a schema on an existing database
2) Import objects in the schema from a standard database dump file which informatica provides
3) Run some jar files using loadjava command. Jar files are provided by informatica.
The first 2 step ran fine for me. But in the 3rd step I am getting error
Command run
HOST loadjava -verbose -force -resolve -oracleresolver -user <<schema_name>>/<<password>>@connection_string informatica_file.jar
Error:
Error while connecting with oci8 driver to orcl: oracle.aurora.server.tools.load.java.ToolsException: The JDBC oci8 driver is not installed properly, use -thin to try the JDBC Thin driver : D:\app\product\11.2.0\client_1\bin\ocijdbc11.dll
Can't load IA 32-bit .dll on a AMD 64-bit platform
On searching for this error in informatica forum I found an article which says there is problem with Oracle JDBC driver. Also the prerequisite says there has to be Oracle JDBC driver 11.2.0.3 for Oracle 11g database.
I am having Oracle 11g database on the server.
I don't idea on the oracle jdbc drivers as to what exactly are they and how I can check the drivers are present or not, and if not present how can I download and install them on the server.
Can someone guide on the Oracle JDBC drivers I need to use and how to install them if needed? Also seeing the error from the above loadjava command if you can suggest anything else it might mean or in case it means something else is wrong then please let me know. We are not having a DBA currently so would need to resolve this issue ourselves with help from the oracle community firends.
Thanks
Rohit