Oracle Grid Control documentation warns against leaving the emkey in the Grid Control repository, if it is not removed after it has been copied it is easy to decrypt data, like passwords. Oracle Management Service 10.2 uses several ways to protect these sensitive data, including Virtual Private Database and Password Encryption. To overcome the first one, you have to connect to the database as the SYS user, for the second one, you have to know the encrypted password form, the key, and the associated algorithm. Obviously, the key used to cipher the password is the emkey. So the next question is, “Where are stored the ciphered passwords?”.
The Pythian family got a new song last Monday — “Sheeri” means “my song” in Hebrew. I’ve been working at Pythian for over a week now, and I really like the work model, environment and culture.The Pythian model of training is “jump right in, and ask questions when you don’t understand something.” The teams are very good technically, and people routinely help each other out. My teammates have been known to work on something I’ve been meaning to get to, and nobody utters a word of complaint. It’s a great workplace. There is a link to a post on my own blog explaining how I got the job.
With the popularity of multi-core machines (and innodb_thread_concurrency) on the rise, we are seeing more issues with adaptive hash index semaphore deadlocks. I guess there finally is a benefit to having MySQL Enterprise — the ability to disable InnoDB’s Adaptive Hash. If you want, you can hack the source code and compile your own version of MySQL. Only 4 file changes are needed to make the workaround happen, and the changes are detailed here.
This message is for our readers mostly located in UK and Europe but keep reading even if you are far away geographically – nothing is impossible in our digital age and you might actually consider traveling there in case of desperate interest. Your feedback would be useful, either way. What I want to draw your attention to is that Jonathan Lewis has posted a call for attendees for a special event dedicated to virtualization technologies with Oracle. This event is considered by UKOUG and whether it happens or not depends on you.
Going stir-crazy from sitting in with all the rain, I was looking for something to do. Paul (from the Pythian Group Australia office) suggested either shopping in Chatswood or going to Crows Nest. Crows Nest is a lovely area of town with lots and lots of shops and restaurants. They have a natural food store that serves organic coffee. Have I mentioned how big coffee is in Australia? You have to go to McDonald’s to get regular drip coffee like I am used to from Tim Horton’s. A few other things I have noticed since arriving here.
Niall Litchfield has published the 74th edition of Log Buffer, the weekly review of database blogs.
I’m a Linux fan, and when it comes to specific problems, I’m afraid not all operating systems are equally armed. Enabling a specific user to listen on a port below 1024 is one of these problems that was solved for years with various approaches. So you may think, obviously you can access the GridControl 10.2 agent on Linux with HTTPS only, on port 443! And obviously you can — but…
I decided to go to a presentation about Enterprise Manager. My own presentation went probably well as far as I could judge following up with people later in the day.Just before my session I bumped into Jonathan Lewis during lunch time and he asked me if it’s true that I fell asleep in the middle of his session. To give you some background,
Well, this was a nice Oracle Bloggers Meetup this year. It was less crowded compare to last year which is a bit surprising if you think about it — there are more and more Oracle bloggers around. On the other hand, it let me focus more talking to participants of Oracle blogosphere and other social networking Oracle related crowd and I met quite a few new faces.
Tom Kyte’s keynote on 11g (original OOW version is here) started with a poll — out of few hundred people there were 13 that worked with Oracle 4, 2 – with Oracle 3 and no one working with Oracle version 2 (version 1 didn’t exist as we all know now). Interesting that since 1994 we had new release every year on average — impressive pace. The next session was from Tom Dale — “Virtualization in Production”, then scaling 6 node RAC cluster at CERN by Eric Grancher and Anton Topurov, my last session of the day was Joel Goodman’s — Oracle 10g: RAC Tuning Tips. I’m well rested now and it’s important as I won’t get much sleep this night and could fall asleep during my own presentation tomorrow. Stay tuned!