среда, 25 сентября 2013 г.

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