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