Connect SAP ECC6 with a external Oracle Database

[Former Member]

Hi guys

I need to connect my ECC 6.0 (SID=UMD) System (MAXDB 7.6.00.035 over Linux RedHat 5.2 32 bits) with external database Oracle 10g (PROD). I follow the steps according the SAP Note 339092:

1. Install the oracle client in the ECC server in the path /opt/oracle/oracle/product/10.2.0/client_3 (this client is the Oracle official client)

2. Set the environment values for umadm with the command

set ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/client_3

set NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"

set ORA_NLS33=$ORACLE_HOME/nls/data

2. create in Oracle the user umdadm with the same password that in Linux

3. in ECC 6.0 tx DBCO create a connection

DB Connection ..... DBMS

DBMS ..................ORA

username...............umdadm

Conn info ..............PROD

permanent.............(no)

Connection Limit ....0

Optimum conns .....0

4. Download the dboraslib.so for oracle-linux 32bits (extracted from SAPEXEDB.SAR 175 download from service marketplace) and put in /usr/sap/UMD/SYS/exe/run, /sapmnt/UMD/exe and /usr/sap/UMD/DVEBMGS00/exe

Then in the se38 run the report ADBC_TEST_CONNECTION, choose the DBMS connection and execute, this is the output error:

M Tue Mar 24 14:32:17 2009

M TRACE FILE TRUNCATED (pid = 6160 )

M sysno 00

M sid UMD

M systemid 387 (Intel x86 with Linux)

M relno 7000

M patchlevel 0

M patchno 175

M intno 20050900

M make: single threaded, Unicode, optimized

M pid 6160

M

M kernel runs with dp version 241000(ext=110000) (@(#) DPLIB-INT-VERSION-241000-UC)

M length of sys_adm_ext is 576 bytes

B

B Tue Mar 24 14:32:28 2009

B create_con (con_name=DBMS)

B Loading DB library '/usr/sap/UMD/SYS/exe/run/dboraslib.so' ...

M *** ERROR => DlLoadLib: dlopen()= libclntsh.so.10.1: cannot open shared object file: No such file or directory -> DLENOACCESS (0,

B *** ERROR => Couldn't load library '/usr/sap/UMD/SYS/exe/run/dboraslib.so'

[dbcon.c 4731]

B ***LOG BYG=> could not load library for database connection DBMS [dbds#1 @ 1035] [dbds 1035 ]

B ***LOG BZY=> unexpected return code 8192 calling DBACDS [dbacds#2 @ 1471] [dbacds 1471 ]

Thanks in advance for your help in solve this error

Alberto Gil

Edited by: Alberto Gil on Mar 24, 2009 2:31 PM

[markus_doehr2 · Accepted solution]

> set ORACLE_HOME=/opt/oracle/oracle/product/10.2.0/client_3

> set NLS_LANG="AMERICAN_AMERICA.WE8ISO8859P1"

> set ORA_NLS33=$ORACLE_HOME/nls/data

> M *** ERROR => DlLoadLib: dlopen()= libclntsh.so.10.1: cannot open shared object file: No such file or directory -> DLENOACCESS (0,

> B *** ERROR => Couldn't load library '/usr/sap/UMD/SYS/exe/run/dboraslib.so'

You have to add the client library path (may be most likely /opt/oracle/oracle/product/10.2.0/client_3/lib) to the LD_LIBRARY_PATH variable in the .sapenv_<hostname>.csh or .sh script.

Markus

[Former Member · Accepted solution]

Thank Markus the problem is solved with this environment value.

Alberto Gil