Remote Oracle DB not getting connected via DBACOCKPIT

[Former Member]

Dear All,

Greetings!!

Please be informed that, we are running ECC 6.0 EHP 07 with HANA DB on RHEL 7.0. And now we are trying to connect a remote Oracle DB (Version 11.2.0.3) for reading some data.

And for establishing the connection between Oracle DB and ECC server, I did the following activities.

1. Download the ORACLE DBSL library file (equivalent to my ECC Kernel version 741) and moved the same to the ECC DEV kernel directory as per SAP note 1261329

2. Install Oracle Client 11.2.0.3 in ECC DEV server as per SAP note 1261329

3. Adjusted the environmental variable accordingly as per the SAP note 1261329

4. Made the DBCON entry for the Remote Oracle DB in DBACOCKPIT in ECC server

And when I tried to test the connection via the report ADBC_TEST_CONNECTION to the remote Oracle DB from ECC, I'm getting an error "DBI error 16 occurred". And when i see the error log, it shows dboraslib.so couldn't be loaded from the Kernel directory. But its available there with correct permissions.

I have attached the error screenshot (DB_ERROR.png) for your reference.

Please help us with any suggestions to resolve this.

Thank you.

Regards,

Ela

[Former Member]

Hi Elan Chezhian  ,

The below SAP notes and link can be useful to you !!!

1265134 - DBA Cockpit: Connection of a remote database

1261329 - DBA Cockpit: Oracle as a remote database

http://help.sap.com/saphelp_nw73/helpdata/en/4a/1df9315c171b40e10000000a42189c/content.htm?frameset=...

Regards

Ram

[Reagan]

The dboraslib.so should be part of all the latest kernel.

Have you restarted the SAP system after putting the DBSL and Oracle client?

The error looks like it is unable to load the file libclntsh.so.11.1 which part of the Oracle Client Software. Check the permission of the Oracle client software directory.

[Former Member]

Hello Ela,

Thanks for the good description of the steps you have performed.

1. As kedadm please run "ldd dboraslib.so" and post the output. This will verify that all your dependencies are being met.

2. Did you logoff as kedadm, logon and then stop/start your SAP system ?

KR,

Amerjit

[former_member184628]

Hi,

1. /usr/sap/SID/SYS/exe or /usr/sap/SID/SYS/exe/run - where have you extracted the DBSL file?

as per note you should extract DBSL at /usr/sap/SID/SYS/exe/run , but your system is trying to read it from /usr/sap/SID/SYS/exe.

2. Can you share exact name of the DBSL file which you have extracted in the /usr/sap/SID/SYS/exe location.

Thanks,

Sharib

[JPReyes]

I agree, seems like sapcpe has not distributed the files.... check the existence of the library on those directories, if they are not there you can copy them manually.

Regards, Juan