Skip to Content
0

Oracle connectivity issue

Jun 23, 2017 at 03:13 PM

149

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

4 Answers

Manikandan Elumalai Jun 26, 2017 at 11:40 PM
0

- 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

Share
10 |10000 characters needed characters left characters exceeded
Swapnil Yavalkar Jun 27, 2017 at 05:37 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Prithviraj Rajpurohit Jun 27, 2017 at 05:54 AM
0

Hi Keith,

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

Regards,

Prithviraj

Share
10 |10000 characters needed characters left characters exceeded
Abhilasha Patil Jun 27, 2017 at 02:44 PM
0

hi Keith,

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

-Abhilasha

Share
10 |10000 characters needed characters left characters exceeded