Posts by Alex Gorbachev
This blog post was inspired by a recent report of a Database Analyst at American Express stealing Credit Card data. It’s amazing how many companies still follow a mainly “perimeter security” approach when it comes to controlling access to sensitive information—their focus is on network security using firewalls, advanced authentication options, and so on. Even with such measures, it’s very common to setup strong barriers to the outside world but very little by way of internal limits; most internal people have some level of access to servers that store and process sensitive data.
OpenSQL Camp will take place Saturday 22nd and Sunday 23rd of August, in St. Augustin, Germany, so it could do for a nice August getaway to Germany. It’s not really the biggest of cities, but then again, that is part of the charm, going to some small city and learning more about databases.
In case you do happen to be curious, feel free to check out the list of proposed sessions, although it is not complete, it does give a overview of what to expect.
Presentation: Migrating 1 Terabyte Database to MySQL — Case Study by Alex Gorbachev. This presentation is based on the real project migrating from RDB on OpenVMS to MySQL on Linux. We will review the migration of the data itself and what infrastructure has been setup — high availability cluster with Heartbeat, DR site replication, organizing backup for 1 TB database. The system has been successfully put in production few months ago.
We will start with an overview of the AQ technology in Oracle database – what it is and what it let you do. Then we will see how it’s used in Oracle E-Business Suite and how to manage it. Our speakers for the evening are your fellow SOM members – Jurijs Velikanovs and Warwick Sands. TBC.
No doubt you want to cast you first vote for my abstract — Developing Plug-ins for Oracle Enterprise Manager by example :) This presentation starts with an introduction of Enterprise Manager’s Extensibility features and walks the audience through the basics of creating a new plug-in. This session will also demonstrate some proven plug-in development steps based on the experience gained from developing MySQL management plug-in. Session includes a demo of the plug-in development scenarios. After this presentation, attendees will be able to design and develop management plug-ins for their own applications. Login to Oracle Mix and vote now. At the time of writing, my session is on the very top — help to keep it there! ;-)
The first videocast was quite popular — it has more than 300 views in couple weeks and considering no Hollywood stars were starring in that video and there were no nude scenes, I think it’s fair to say that this format was very much welcomed by the audience. Today, I’m posting the follow up session on VIP’s (Virtual IP’s) with Oracle RAC. What I demonstrate today is a typical configuration mistake for a RAC databases created with Database Configuration Assistant (DBCA) and what’s the result of such omission.
I’ve been just sending the abstracts for UKOUG 2009 Conference before the extended deadline is over and realized that I hadn’t spread those exciting news. Actually, the news spread via Twitter before I saw the official confirmation in my inbox. Well, I guess the blog post title says it all. It’s a pleasure to join this program and get engaged in its activities.
This meetup will be focused on storage technologies for Oracle database. It looks like a short presentation on Oracle Automatic Storage Management is in order – quite a few people are missing the concepts of the Oracle flagman storage storage solution and it’s useful to understand the approach whether you use it now or not.
Just got an interesting note on Twitter that you can’t call a stored procedure dynamically in Oracle from a PL/SQL block like passing the procedure name in a variable. Well, yes we can! And the answer is EXECUTE IMMEDIATE — it can be used to run anonymous PL/SQL blog and not just a SQL statement. However, you will want to think many many times before doing so… if you love your data. Let’s create the test procedures…
I think it was the smallest group so far which is not surprising considering that Monday has been the least popular day in our internal poll. We had a tad less than 20 people but very good size for the informal discussion of Oracle 11g adoption that took place at the second half of the meetup.