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/CRsqls26.so' : 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/CRsqls24.so 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/CRsqls24.so
linux-vdso.so.1 => (0x00007ffd43be6000)
libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fc9cf77e000)
librt.so.1 => /lib64/librt.so.1 (0x00007fc9cf575000)
libCRicu26.so => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/libCRicu26.so (0x00007fc9ce67e000)
libodbcinst.so => /u01/boxi/app/biqapp/sap_bobj/enterprise_xi40/linux_x64/odbc/7.0.1/lib/libodbcinst.so (0x00007fc9ce45a000)
libdl.so.2 => /lib64/libdl.so.2 (0x00007fc9ce255000)
libstdc++.so.6 => /usr/lib64/libstdc++.so.6 (0x00007fc9cdf4f000)
libm.so.6 => /lib64/libm.so.6 (0x00007fc9cdccb000)
libc.so.6 => /lib64/libc.so.6 (0x00007fc9cd936000)
libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fc9cd720000)
/lib64/ld-linux-x86-64.so.2 (0x0000003ebc200000)

Regards ,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

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 "Allthingsoracle.com" 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.

Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

mopatch.sh: 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/mopatch.sh: 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.

Regards
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com