Database access error. Reason Loading shared object failed

User might receive below error during Business Objects(Boxi ) or Data services installation when using Oracle as database.

Error
An error has occurred.

Database access error. Reason Loading shared object failed. First tried to load library clntsh and failed because of error: . Second tried to load library libclntsh.so and failed because of error: .
(FWB 00090)

The system cannot verify the database logon information. That means the path might not be correct.

User will receive this error when below environment variables are not set properly.

1. The environment variable "LD_LIBRARY_PATH" is not set.
2. environment variable for ORACLE client is not setup properly
3. the user where you are running the BOXI install not able to tnsping to the listener service

Resolution

Make sure you set the below library paths in .profile of the user by which Business objects is installed

• ORACLE_HOME=<Oracle client home path>
• LD_LIBRARY_PATH=<$ORACLE_HOME/lib>

Note : ORACLE_HOME may be set also in the bash_profile. After setting variables, tomcat should be restarted.

Regards,
Satishbabu Gunukula, Oracle ACE

License key not valid INS00140 in Unix

You might encounter below error during the installation of Business Objects (BODS/BOBJ), Data Services  install will stop

License key not valid INS00140 in Unix

Cause

A library is missing

Resolution

Use strace or ldd to find what library is missing.

strace -ff -v isKeycodeValid

Note: Using strace, you can watch something similar like this: 10isKeycodeValid: error while loading shared libraries: libstdc++.so.6: cannot open shared object file: No such file or directory.

If using ldd

Run ldd on /usr/dlc/odbc/lib/pgoe1023.so to ensure all dependencies are found.

Find out which library is missing , in my case  libstdc++.so.6 would be the library that is missing.

Installed the library using below command

sudo yum install libstdc++.so.6

Rerun the install and install working fine.

Regards

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com

[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

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