Oracle connectivity issue

[Former Member]

Hi

I have a BI 4.2 SP3 FP3 environment that has problems setting up or editing Oracle connections in the IDT or UDT.

I get the following error message in IDT on the server desktop:

Error parsing connection description.

DBDriver failed to load: <install directory>\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll (Access is denied)

the dll is present in the location and appears to be the right file size. Security is fine (I am a local admin on the server).

I have added these env variables and 32 and 64 bit Oracle clients are installed:

• ORACLE_HOME=D:\app\client\product\12.1.0\client_2
• ORACLE_HOME32=D:\app\client\product\12.1.0\client_1
• LIBPATH=D:\app\client\product\12.1.0\client_2
• LIBPATH32=<D:\app\client\product\12.1.0\client_1
• BOE_USE_32BIT_ENV_FOR=ORACLE_HOME,LIBPATH

I have updated the 'path' variable with the relevant details, with the 32 bit client referenced first.

the cscheck for 32bit drivers is successful with no errors reported.

One set of reports runs fine in the browser so the 64 bit client and drivers are fine.

I have changed IDT settings to use the server middleware so my working connection tests fine from three, but the error message re the 32 bit driver still comes up when I try to edit or add a new connection for Oracle.

Any help would be much appreciated

thanks

Keith

[former_member211289]

Dear Keith,

Kindly let me know, what is the cause and solution which you implemented to avoid this issue?

currently, we are struggling with the same issue.

BO Version: 4.2 Sp6 Patch4

OS: Windows 2016 standard

Please do the needful.

Thanks

Ram

[former_member211289]

Exactly same scenario we are facing which you mentioned in query.

[Abhilasha]

hi Keith,

In the Oracle home, place the 32 bit entry before 64 bit and check.

-Abhilasha

[prithvirajr]

Hi Keith,

Please check if the local user group has access to "DRIVE:\Oracle" & "C:\Program Files\Oracle" directories.

Regards,

Prithviraj

[Former Member]

Hi Keith,

From the error message it seems that the below mentioned file is not accessible to operating system.

File: <install directory>\dataAccess\connectionServer\drivers\lib32\dbd_oci.dll

Could you please check whether this file is present at the above mentioned location or not?

Try to open IDT using the option => right click on IDT and select "Run as administrator".

I believe you have installed IDT by following right click on setup.exe and select "Run as administrator" step.

Regards,

Swapnil Y

[former_member182521]

- Did you setup PATH environment variable to refer your Oracle Home?

- Do you have multiple version versions of oracle clients being installed , If so check for their version on supportability perspective.

Thanks

Mani