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

The description for Event ID 4096 from source Tableau Server (vizportal) cannot be found

I have noticed below Tableau Error messages in event Viewer. You might see similar error for other processes too.

The description for Event ID 4096 from source Tableau Server (vizportal) cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

The description for Event ID 4096 from source Tableau Server (Backgroundr) cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.
As per Tableau when you receive these errors, check the status by following below steps.

Step1 : tabadmin status –v
Step2: Check Tableau Server Administrative Views to verify that Tableau server is behaving as expected.

If all the processes are running as expected, then the error messages can be ignored.

Please refer below KB article from tableau
http://kb.tableau.com/articles/issue/error-event-id-4096-in-windows-event-viewer-logs?lang=en-us

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