I just read on Metalink (1130327.1) that we Commodore 64 users who have to patch our 10.2.0.4. will get extened support untill April 30, 2011
I’ve seen many a good DBA make the master of starting slaves from the position in the master.info file, most recently this week, that I want to bring it to everyone’s attention.
The scenario goes like this: The instance was in nomount stage and was unable to mount the database. Checked the uptime, and found that the server was rebooted some 5 minutes ago, and the instance tried to come up automatically but failed to mount the database. Checked the alert log and found the following error: ORA-214 signaled during: ALTER DATABASE MOUNT…Made a quick searched about ORA-00214 and it was about mismatched control files. It was probably due to the fact that control files got out of sync as the not-so-graceful reboot of the server was done without first cleanly shutting down the database. This is what doc says:
Knowing how failible my memory is, I looked for some automated safety net to use with Git. The most obvious would have been to use a push hook, but alas Git has no such thing, and if the latest thread I caught on the topic still hold, one isn’t going to appear anytime soon. Since that venue is (for now) closed, I turned to plan B: crafting a new git command, git-safepush:
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.
It started out innocently enough: Two node RAC cluster on two Linux RHEL5 with Netapp NFS used as shared filesystem for all shared files. My favorite OS and storage, so I felt confident that clusterware installation will be as smooth as it usually is. I told the customer that this can be done in 3 hours. What I didn’t take into account is that this was my first 11gR2 installation, and that much have changed since 11gR1. As things turned out, it took over 20 hours of my time and a lot of help from colleagues and even former colleagues before we had a successful installation. The time it takes you to read this blog post (and any other on this subject) is likely to be time well spent.
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:
I must confess, that game I’m leasurely working on is nothing but a big fat excuse to dabble with fun bits of technology that I don’t get to touch with my usual projects. And in that optic, yesterday I fooled around with logging and internationalization stuff…. Yes, I know. I’m using a game as a pretext to work on logging and I18N. I’m ashamed of myself. But aaanyway, let’s see what I got to discover.
Now that we are entering 2011, I thought I could stop for a few seconds to join the Todo meme and list what I hope be able to work on for the next little while during my spare time. So… Here’s what one could expect from little me in the new year, non-$work-related but still programming-wise: