I want to introduce several post about Oracle GoldenGate (GG), a relatively new replication software from Oracle. This first post is about installating GG software and creating the simplest replication using only the “extract” and “replicat” processes. Lets start the installation.
Denver Convention Center at the Oracle ACEs and ACE Directors Breakfast at 7:50am. This is your chance to ask any questions you want and get honest answers on anything from Oracle databases and Fusion Apps to diving with sharks and anything in between. Also consider dropping by the OakTable / Apress booth to have a more private conversation with members of the OakTable Network. Traditional OakTable Challenge begins again tomorrow so if you think you have a tricky question around Oracle databases — by all means let us know.
Pythian has launched a Partner Program to assist Independent Software Vendors (ISVs), whose applications have intensive database requirements. We assist their client base by helping them correctly plan, deploy, and manage the underlying database infrastructure, be it MySQL, Oracle or SQL Server, to ensure the ISV customers’ software environment is sound, and performs well over time.
Today I’ve read the following email on the mailing list of Sydney Oracle Meetup. I thought that this question is asked many times in attempt to find a silver bullet to learning Oracle so I wanted to publish my reply here on the blog, especially, that I’m a firm believer in one silver bullet that exists — there are no silver bullets.
Gerry Narvaja has published the 178th edition of Log Buffer, the weekly review of database blogs.
How many times have we heard the assurance of storage administrators (fueled by the SAN vendor’s claims) that their top-of-the-shelf SAN arrays simply cannot fail. Unfortunately, reality proves this wrong and we see it regularly with our customers. At the moment of this writing, one of our DBA teams has just completed failover to the standby database as a result of a database crash caused by a SAN issue. Is there a silver bullet? Well, not as solution but as a concept, yes — simply admit that SANs do fail — this what should drive infrastructure design for business continuity. Actually, I should extrapolate it to another design principle — everything fails, but that’s another story.
What should you expect coming to the Hotsos Symposium 2010? It’s 3 days packed with sessions on all aspects of Oracle performance optimization whether it’s design, troubleshooting, development, methodologies and processes. Legendary Tom Kyte — who else can you expect for the keynote?! If you take an optional training day with Tanel Poder then you are likely to learn at least as much about troubleshooting Oracle database performance as you do during the conference and probably even more. Every presentation by Tanel has been an eye opener for me. If you’ve seen his material, you’d know what I’m talking about. Now, imagine that it’s not a one-hour session but the whole day! It will fry your brains so this day is for the strongest! :)
The “Beer” version of DBD::Oracle (1.24) has been released. You can find it at CPAN DBD::Oracle. DBD::Oracle is a Perl module that works with the DBI module to provide access to Oracle databases. It is maintained by me, John Scoles, under the auspices of Pythian as Open Source/Free Software. This is largely a maintenance release that fixes a number of bugs. New stuff includes some more improvements to embedded types from Charles Jardine. Find out more here.
There are a lot of discussions going on in the Internet regarding whether we can trust third parties to look after our data. I am not going to add fuel to the fire. I am going to show you how simple it is to backup an Oracle database to the Storage Cloud using the Oracle Secure Backup (OSB) Cloud Module.
Welcome, everyone, to the 177th edition of Log Buffer, the weekly review of database blogs. It was another week heavy with technical posts, so let’s waste no time, and get it all started with . . .