Friday, December 23, 2016

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


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

Thursday, September 29, 2016

How to recreate oraInventory using Oracle Universal Installer (OUI)

I come across the missing oraInventory issue and I have recreated the inventory using Oracle Universal installer. In case inventory got corrupted, you can use the same steps.

1. Make sure you set the ORACLE_HOME variable
$ export ORACLE_HOME=/oracle/product/11203

2. Update the $ORACLE_HOME/oraInst.loc file to point to the inventory or wherever you want to keep the inventory.

Forex:- cat $ORACLE_HOME/oraInst.loc
inventory_loc=/oracle/oraInventory
inst_group=dba


3. Run below OUI command to register ORACLE_HOME

$cd $ORACLE_HOME/oui/bin
$ ./runInstaller -silent -invPtrLoc $ORACLE_HOME/oraInst.loc -attachHome ORACLE_HOME="/oracle/product/11203" ORACLE_HOME_NAME="OraDb11g_home1"


In case of RAC environment, pls use below syntax

$./runInstaller -silent -attachHome oracle_home="<oracle_home_location>"
"cluster_nodes={<node1, node2>}" local_node="<node_name>"


4. You can verify the inventory created or not using below command
$ORACLE_HOME/OPatch/opatch lsinventory -invPtrLoc $ORACLE_HOME/oraInst.loc

Deleting Oracle Home from Central Inventory
$./runInstaller -silent -detachHome -invPtrLoc $ORACLE_HOME/oraInst.loc 
ORACLE_HOME="<Oracle_Home_Location>"

Regards
Satishbabu Gunukula, Oracle ACE

Thursday, September 22, 2016

Explore Oracle Database In-Memory in 12C – Part1

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:

·         Oracle In-Memory Dual-Format Architecture
·         In-Memory Column Store
·         In-Memory Column Store Restrictions
·         How to enable In-Memory Column Store

Please view the article using below link.
Explore Oracle Database In-Memory – Part1

You will see more articles on this topic in near future.

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

Thursday, September 8, 2016

InnoDB: Unable to lock ./ib_logfile0, error: 11

One of our MySQL servers got restarted and after restart MySQL instance was not coming online.

I see below error message in mysqld.log

InnoDB: Unable to lock ./ib_logfile0, error: 11
InnoDB: Check that you do not already have another mysqld process
InnoDB: using the same InnoDB data or log files.
InnoDB: Error in opening ./ib_logfile0
160712 19:16:34 [ERROR] Plugin 'InnoDB' init function returned error.
160712 19:16:34 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
160712 19:16:34 [ERROR] Unknown/unsupported storage engine: InnoDB
160712 19:16:34 [ERROR] Aborting
160712 19:16:34 [Note] /u01/mysql/5.5.22/bin/mysqld: Shutdown complete

I receive below error message when trying to access the database from command line

# mysql -u root -p
Enter password:
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/u01/mysql/5.5.22/mysqld.sock' (2) 

It looks like the sudden server crash didn’t update the logfile or datafile header properly and not able to lock to bring the instance up.

After research I was able to fix this error by following below steps

1. Go to the data directory and backup the ./ib_logfile0 and copy a new one
$ mv ib_logfile0 ib_logfile0.bak
$ cp -a ib_logfile0.bak ib_logfile0

2. Restart the mySQL database

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

Monday, August 1, 2016

Webinar: How to Convert Single Instance to RAC

I am conducting the webinar once again due to overwhelming response from Oracle community. After this Webinar I hope you should be able to understand Oracle RAC benefits and "How to Convert your single instance to RAC”.

Date and time: Thursday, Sept 15th, 2016 8:00am-9:00am
Pacific Daylight Time (San Francisco, GMT-07:00)


This Webinar covers following Topics.
  • Oracle RAC and its Benefits
  • Overview of different RAC conversion methods
  • Overview of different Storage options
  • Convert Single instance to Oracle RAC Using RMAN
    • Overview
    • Prerequisites
    • Demonstration
  • Check the logs
  • Post Conversion Steps
  • References
  • Contact Info
  • Q&A
To register for this Webinar, please send an email to SatishbabuGunukula@gmail.com and reserve your spot. Note that registrations are limited and first come and first serve basis.

You will receive an email confirmation with meeting session link.
For presentation link Click here .

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