Last Post of 2007Posted: January 1, 2008 | |
Summing up the past year is traditional, right? So is making new year resolutions. Here are some of the highlights from last year, resolutions will appear in a follow up post tomorrow.
- Relocation to the US. That was by far the biggest change of the year for me, so big that it changed almost every aspect of my life: My car and house got bigger, I work fewer hours a day, I got to ski, and I had to build a brand new social circle from scratch. Life can’t get more intense than this.
- The big DST scare. That was my first project in my new job. Make sure we patch all our servers to support the new DST dates. With the server list and Metalink notes changing on a daily basis, this was a huge challenge.
- Stabilizing RACs project. That was a cool one, and I regret not having a blog back then to document it. Very early in the year it became apparent that our RAC systems were crashing often. Management wanted to move back from RAC to standalone servers, and the DBA team asked for 10 weeks to stabilize RACs. This resulted in a flurry of patching, upgrading, changing various parameters and many fruitless discussions with Oracle support. It took a bit longer than 10 weeks, but at the end, RAC is here to stay.
- Fight for electricity. 2007 was the year that electricity became a serious issue in our data centers, and we had several projects concentrated around saving electricity: Moving applications to VMWare, consolidating servers and shutting down spare servers. It is clear that electricity issues will become even more pressing next year.
- Move to new Netapp. In order to save money and electricity, our storage team decided to move from Netapp with mirror to a Netapp cluster. This seemed like a simple project, but it turned into a nightmare of unexplained failures, politics and finger pointing.
- Upgrading to 10.2. I really wanted to have all my servers on 10.2 by the end of the year. We couldn’t upgrade all of them, two small applications don’t support 10.2, but we did upgrade many servers this year and perfected our upgrade procedures.
- Shutting down our MSSQL systems. That was part of the “save electricity” project, as a single Oracle machine can support more customers while using less electricity than MSSQL machine. It was a huge project in its own right, started two years ago, but finished in 2007. Scores of applications with hundreds of customers moved from MSSQL to Oracle. Going into 2008 without having to manage MSSQL at all is indeed a highlight.
- Oracle Open World. I blogged enough about it, but it is still one of the highlights.
- Blogging. I started blogging in June, and for months I still believed that no one is reading it, even when people started commenting on some of my posts. I finally realized that I’m really writing in public when Eye on Oracle linked to one of my OpenWorld posts, a former colleague saw it, forwarded it to my team lead, who forwarded it to everyone else. It was quite a shock. Realizing that people I know are reading what I post here.
- OCA. I’m still not sure whether or not getting an OCA helped me improve as a DBA, or if it should even count as an achievement.
- Reading blogs. Actually, I wanted to have a “top 10” favorite blogs or posts of 2007. But my google reader has over 300 posts marked as favorite, and I follow over 50 blogs, it was impossible to choose. Lets just say that I’ve learned a lot this year by reading blogs, and what’s more important – I’ve been inspired to do better and better.