Skip to Content

Oracle connectivity issue

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Jun 26, 2017 at 11:40 PM

    - 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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 05:37 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 05:54 AM

    Hi Keith,

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

    Regards,

    Prithviraj

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 27, 2017 at 02:44 PM

    hi Keith,

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

    -Abhilasha

    Add comment
    10|10000 characters needed characters exceeded