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

http://www.oracleracexpert.com

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

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

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

xxxxx is disabled and will not be called. Reason: timeout SNAPSHOT_ID

In HANA Studio I see many following internal alerts

 Internal statistics server problem --- xxx is disabled and will not be called. Reason: timeout SNAPSHOT_ID: <timestamp>

I found below error message in Indexserver trace.

These issues fixed in SAP HANA SPS08 database maintenance version 85.05, Please check the release SAP note 2188592.

If you are in higher version still receiving these alerts then raised a ticket with SAP.

Regards

Satishbabu Gunukula, Oracle ACE

http://www.oracleracexpert.com