Oracle Client 32 or 64bits or both

[antoine_brejuin]

Hello,

I am using several databases for Universes in BI 4.1 SP06 patch1.

I did install Oracle client 11gR2 64 bits when installing our BI 4.1 server.

We have a database Oracle 12c for a week. I wanted to create Oracle client connection to this new database thourgh IDT but sometimes I have an error about "XML invalid". SAP support tells me to install both oracle 12c 32 and 64 bits.

What do you think about that ? Is it really necessary ?

I already have Oracle client 11gR2 64bits installed and I think that's why I get an error message while trying to install Oracle 12c 32bits.

For information, we have a lot of instances failed.

Thanks a lot for your help.

Best regard,

Antoine

[denis_konovalov · Accepted solution]

IDT is 32 bit and requires 32 bit DB drivers, BI Platform is 64bit and requires 64bit drivers.
that's it.

[antoine_brejuin · Accepted solution]

Thanks for your answer.

Is there any other tool which needs Oracle client 32bits? I mean it may be enough installing Oracle driver 64bits on BI platform ?

[former_member219634]

Hi Antoine

  Please try to create a connection based on oracle on Local project in IDT

Then, if it's fine, you can check creating the connection based on oracle on Repository in IDT

Best Regards

Ines

[onkarvelhals]

Hi Antonie,

Ensure that both 64 bit and 32 bit oracle clients are installed on server and following environment variables are set appropriately:

export ORACLE_HOME32=your_32bit_oracle_client

export ORACLE_HOME=your_64bit_oracle_client

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:$ORACLE_HOME32/lib:$LD_LIBRARY_PATH

export PATH=$ORACLE_HOME/bin:$ORACLE_HOME32/bin:$PATH

Also, ensure you are able to tnsping/sqlplus to oracle using both these clients.

Hope this helps.

Regards,

Onkar