Monday, October 17, 2016

[01000][unixODBC][Driver Manager]Can't open lib…file not found

I have installed a new BOXI system and working on unixODBC configuration to connect to Microsoft SQLServer Database and received below error message

$ isql -v test_ds test_username test_password
[01000][unixODBC][Driver Manager]Can't open lib '/u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/ odbc/7.0.1/lib/' : file not found
[ISQL]ERROR: Could not SQLConnect

First I thought the issue with invalid patch and I have corrected the issue but I still see same error

It looks like LD_LIBRARY_PATH was not updated properly, which might be reason it’s not able to find the library. I have updated the updated LD_LIBRARY_PATH and I was able to connect successfully.

In some cases you will see the same error, if all dependent libraries are not installed. Run “ldd on the library /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/ to ensure all dependencies are found. If something not found in below output then required PRM’s or soft links are missing.

$ ldd /u01/boxi/app/testsrv/sap_bobj/enterprise_xi40/linux_x64/odbc/lib/ => (0x00007ffd43be6000) => /lib64/ (0x00007fc9cf77e000) => /lib64/ (0x00007fc9cf575000) => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/ (0x00007fc9ce67e000) => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/ (0x00007fc9ce45a000) => /lib64/ (0x00007fc9ce255000) => /usr/lib64/ (0x00007fc9cdf4f000) => /lib64/ (0x00007fc9cdccb000) => /lib64/ (0x00007fc9cd936000) => /lib64/ (0x00007fc9cd720000)
/lib64/ (0x0000003ebc200000)

Regards ,
Satishbabu Gunukula, Oracle ACE

Friday, October 7, 2016

Explore Oracle Database In-Memory in 12C – Part2

Hi Everyone,

It’s been couple of months that I published my last article. Finally I was able to find some time and published new article in Oracle Experts website media "" by RedGate

In this article I will cover:

·         Multitenant Architecture compatibility
·         In-Memory Column store in RAC
·         How to manage In-Memory Tables
·         IM Column store Compression Methods
·         How to manage the In-Memory Column
·         Oracle Compression Advisor
·         How to manage In-Memory Tablespace

Please view the article using below link.
Explore Oracle DatabaseIn-Memory – Part2

This article will help users to understand In-Memory architecture, benefits, restrictions, functionality, performance…etc.

I hope you like the article and it will be helpful to you.

Please leave your valuable comments.

Satishbabu Gunukula, Oracle ACE line 5682: dc: command not found

While applying SBP patch on ORACLE_HOME come across an issue an error and mopatch failed.

I see below error in log file.

executing: "/oracle/ORAX/product/11204/bin/unzip" -qq -d "./mopatch-wmOvOg" "SAP11204P_1411-20010781.ZIP" "SBP_112044_201411/19493764/*"
/oracle/ORAX/product/11204/MOPatch/ line 5682: dc: command not found
Processing patch "SAP11204P_1411-20010781.ZIP!19493764!19493764"...failed.
Reason: Cannot calculate "" as (447392 > 7914856) ? 1 : 0.
Processing patch "SAP11204P_1411-20010781.ZIP!19493764!17478514"...(1 of 7)
Processing patch "SAP11204P_1411-20010781.ZIP!19493764!17478514"...failed.
Reason: Cannot calculate "" as (447392 > 7914508) ? 1 : 0.

I did some research on error “Reason: Cannot calculate” but didn’t find much in google or oracle support site. When I look into the error closely I see that “dc” command not found.

After investigation on "dc: command" I found that user will get this error if RPM missing at OS level. After installing “ bc-1.06.95-1.el6.x86_64” rpm the SBP patch went fine without any issue.

Satishbabu Gunukula, Oracle ACE