SAP BO 4 on Linux connection to Oracle

If you want to connect SAP BO server to Oracle server you should

1) Install Oracle Instant Client 64x
2) Set Variable $ORACLE_PATH and $TNS_ADMINS ->
modify .bash_profile in home of bo user:

export LANG=en_US.utf8

export LC_ALL=en_US.utf8

export ORACLE_HOME=/usr/lib64/oracle_instant_client64

export TNS_ADMIN=$ORACLE_HOME/network/admin

export PATH=$ORACLE_HOME:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME

export NLS_LANG=AMERICAN_AMERICA.AL32UTF8

3)Define Oracle server in file tnsnames.ora (TNS_ADMINS):

QA =

 (DESCRIPTION =

   (ADDRESS_LIST =

     (ADDRESS = (PROTOCOL = TCP)(HOST = <IP of host>)(PORT = 1521))

   )

 (CONNECT_DATA =

   (SID = QA)

 )

)

The same operation you should do with client in windows