Posts Categorized: Group Blog Posts
Today I’ve spent some time (more than this issue was worth, actually) on a client’s system trying to find out why table was not accessible and failed. The error message suggested something went very wrong with .frm file and I already started thinking about restoring the table from backup, when I noticed that accessing any InnoDB table was producing same error. A quick check of the error log showed that when MySQL server was restarted some time ago InnoDB failed to initialize due to a memory issue.
For this blog I have compiled the main information regarding JDBC drivers specifically considering the 11gR2 platform, but the concepts and idea also apply for older platforms as well.
Just to make you smile and let you remember all those sweet holidays I would like to congratulate you and wish you MERRY CHRISTMAS! in Oracle style:
Welcome to Log Buffer, a weekly review of the database industry.
The days are cold and wet. The nights are long and dark and full of beeping pagers. It is time to look back and reflect on the past year and plan for next year.
Many companies become accustom to lags in performance or even accept outages as normal to their day to day business due to poorly performing database environments. It’s what I refer to as the plague of the database industry and the constant frustration of DBA’s everywhere. Until these lags and outages become huge storms and are impossible to ignore, it is commonly tolerated. How do environments end up in this situation?
Welcome to Log Buffer, the weekly news update of happenings in the database world.
Hey ALL! I just got a very good present from Santa :) I Passed 1Z1-536 Oracle Exadata 11g Essentials and 1Z1-515 Data Warehousing 11g Essentials certification exams. How cool it is if small things like these can make you rejoice like a child :) I am still smiling ….
For last few months I was part of the Pythian’s team helping implement Oracle 11gR2 Clusters for different Oracle customers. All the implementations had different requirements and configurations, however, in all cases, the client’s DBAs made the same mistake over and over again. They used sqlplus and lsnrctl utilities to manage (start/stop) databases and listeners. This is totally wrong in the 11gR2 Cluster world. The following commands are just few examples on how you should start/stop Oracle processes
Sorry, no funny nick name for version 1.27 but here is the scoop on it anyway. This version removes ‘PERL_POLLUTE’ and adds in PL_ so it will be fully compatible with Perl 5.13. So in a nutshell 1.27 is a single issue maintenance release.