Who certified MySQL what?

Some of you in the MySQL world may have missed FAQ: Sun Certifications and Oracle-Branded Certificates from the Oracle Certification Blog. The synopsis is that anyone earning a MySQL certification before September 1st will be a SUN Certified MySQL {associate|DBA|Cluster DBA|Developer}. And starting September 1st you will be an ORACLE Certified MySQL {associate|DBA|Cluster DBA|Developer}. There is no need to replace your old certificates to get the Oracle branding and will continue to be recognized under the Oracle certification program and will be valid without expiration.

Want a new certificate anyway? Well, Oracle is planning an upgrade path in the future. Please see the linked article above for details.

Oracle Express Edition first steps for MySQL DBAs

I have had a few MySQL DBAs ask about how to get started learning Oracle. I will admit that it has been on my to-do list for quite a while¹. It never hurts to know more than one database system and a great deal of DBA help wanted ads mention Oracle. Someone once said that you must make sure your capabilities exceed your limitations² and recently I have been feeling limited when others have started to talk about Oracle capabilities.

So what does it take for a MySQL DBA to get their hands on their own Oracle instance? I used my Ubuntu box to go to Oracle's web site to get the free Oracle XE software.

1. Download and feed to package manager


2. Add my account to dba group


3. As root, /etc/init.d/oracle-xe configure to set passwords and ports

I pointed my web browser to http://127.0.01/apex and got the page you see in image with this blog. Now I need to find my copy of Hands-On Oracle Database 10g Express Edition for Linux.

1. I also have a stack of DB-2 and SQL Servers books that were picked up at Half Price Books to read through. I am always looking for better ways to express database concepts for MySql exams. Writing up something similar to this entry for DB2 and SQL Server is also on the list.

2. This quote has attributed to Bruce Lee and several others. And it always gota groan from my kids when I used it on them.