One of the topics that beginners RAC DBA’s (along with network engineers supporting Oracle database infrastructure) are confused about is the Virtual IP usage in Oracle RAC starting from Oracle Clusterware 10g. With this videocast, I will try to clarify those concerns once and for all. I have embedded the video here in a smaller window so you might want to go directly to YouTube for the full-size version of “Pythian Video: Oracle RAC – Why VIPs”.
More than a month has passed since Sydney Oracle Meetup #2. We shot some video, but it took me a while to process it and publish a few interesting pieces, but I finally got it all. Have a look.
This meetup is focused on Oracle 11g adoption. We will have one presentation followed by (or combined with) the discussion of Oracle Database 11g release, who is using it currently – what are positive and negative moments. The presentation for this meeting is “Oracle 11g New Features Out of the Box” by Alex Gorbachev. Unlike many presentations on 11g new features, we will try to focus on a more subtle enhancements and less known new features.
When I posted my RAC Workload Management whitepaper, it was downloaded by many but it turned out that not everyone has half a day to go through such level of details and, frankly, not everyone is interested in how those features are implemented. This prompted me to put together a webinar that does high level overview of available options to balance workload properly with Oracle Real Application Clusters.
SOM #4 is about Oracle backup and recovery. As usual, Pizza and drinks arrive at 5:30PM and we start the presentation at 6PM. We should be out by 8:30PM with optional post-event program. It’s Friday night in the end!
I go throught the steps required for Installing Oracle EBS 12 on a PC with Centos Linux
Thanks to a patch from Tomas Pokorny, you can now select Oracle user-defined types directly into a Perl object. User-defined types include Object, Varray, and Table. These have been around in Oracle since 8i but have never really gained any sort of popularity for any number or reasons. With the new functionality of DBD::Oracle, selects of these objects are simple to work with in Perl. Lets take the example below for a web site that has a number of different “user” types. Lets have a look.
DBD::Oracle (1.23) has been released. DBD::Oracle is the 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 The Pythian Group as open source/free software. This release is largely a maintenance release that fixes a number of bugs. New stuff includes the ability to fetch Oracle embedded types directly into an oracle object; a big thank you goes out to Tomas Pokorny for that patch.
In the first part of this blog I tried to shed some light on EBS patch terminology and naming conventions. In this post, I’ll show you how to check your patchset levels and query applied patches.
Following my presentation at InSycn09 about Oracle E-Business Suite high availability, I gave an interview to a fellow Oracle tweeter here in Sydney and member of the team behind The Red Room blog — Gareth Llewellyn. I should say that my dedication to the interview was very strong and you will believe me if I tell you that during that time the party in the InSync09 exhibition hall was already in the full swing. Thanks to Gareth, the interview is now on Youtube and if you go there directly, you can watch in HD.