Remote Publish Service is not starting.

Document ID : KB000004920
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

When trying to configure Remote publish on a 64 bit windows 7 machine, the service did not start.  When looking at the log, located in the standard default location

C:\Grid-Tools\RemotePublish\logs in the dmbatch.log

the below errors were logged: 

<<DATE>> INFO DMBatch.DMBatch - Opening database connection 
<<DATE>> FATAL DMBatch.DMBatch - Error occured while connecting to database 
<<DATE>> FATAL DMBatch.DMBatch - Inner Exception Message: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) 
<<DATE>> FATAL DMBatch.DMBatch - Error occured while accessing database: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. 
<<DATE>> FATAL DMBatch.DMBatch - Inner exception: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B)

In addition to the above errors

<<DATE>> INFO  DMBatch.DMBatch - Provider Validation Message:Validating tnsnames.ora existence

Validating oci.dll existence

Found oci.dll

Either oci.dll or tnsnames.ora doesn't exists in expected directory C:\Program Files (x86)\Grid-Tools\GTDatamaker\

Environment:
Oracle XERemote Publish Setup on 64bit OS
Cause:

The first debugging done was to make sure the correct ODAC and ODP.NET were downloaded from the Oracle download site based on the Oracle Server version. The following is the Oracle download site:  

http://www.oracle.com/technetwork/database/windows/downloads/index-090165.html

Upon making sure the correct ODAC and ODP.NET were in place and since the log clearly stated that the oci.dll was found, the tnsnames.ora file was checked and verified it was not in the correct location.  The usual place to find a tnsnames.ora is in the Oracle installation folder such as the following:

C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN

Copied the tnsnames.ora to the location stated in the log file:

C:\Program Files (x86)\Grid-Tools\GTDatamaker\

Resolution:

Once the tnsnames.ora file was copied from C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN to the default installation folder 
C:\Program Files (x86)\Grid-Tools\GTDatamaker\ and the service was started, the service started without error.