Data360 Analyze

Hello,

I'm trying to connect an oracle DB and running into the attached error.

I currently have 32 Bit version of Oracle Client installed on the computer. 

I have installed the 64 Bit OracleInstantClient. However, I'm still getting the below error.

I have ensured that the PATH (Windows 10 64bit PC) has the location of the 64bit InstantClient set.

I have confirmed it is set by using the Windows WHERE command - "where oci.dll" - I get the following result:

C:\Users\dwramsay>where oci.dll
C:\OracleInstantClient64\oci.dll
C:\OracleInstantClient32\instantclient_12_1\oci.dll

Is there something else wrong with the config - do I need to restart the PC or Dataverse services after I set/change the environment variable? Or is there some other issue.

Thanks. 

Appreciate any feedack.

With windows and dlls.. i'm not certain whether  you should set LD_LIBRARY_PATH or simply add the folder above to the PATH.

Either way, I would select only one of the two folders at a time and yes, you do need to stop/restart the DataverseServer process after you make any such changes.

Thanks for the feedback Stony.

I have resolved the issue as follows:

1. Ensure Windows PATH includes folder location of 64bit Instant Client - this is placed before the 32 bit Client Path. ***Should this pose a problem for other apps I'll remove from my PATH and place in LD_LIBRARY_PATH and see if it still works.

2. Ensure/Set TNS_ADMIN environment variable is set to the location of the tnsnames.ora - this is necessary so the Instant Client will use existing tnsnames.ora file from another oracle Client install. In my case this was necessary because I already have an Oracle 32-Bit Client installed. Reference: http://www.oracle.com/technetwork/database/features/oci/ic-faq-094177.html#A5028

3. Restart Dataverse processes.

Once that was done - it finally worked.

Hope this helps others.

Regards,

Dwayne