We have to limit the number of people to 40 this time so make sure you RSVP timely! We are gathering at 5:30pm and technical goodies are starting at 6pm so use this time to catch up with other members. We should finish by 8:30pm including a beaks and some post follow up. The presentation schedule is a bit floating this time. As usual, we should have some pizza and beverages facilitating seamless peer networking. ;-) In addition to the main topic, we plan to have some overview of Oracle / Sun deal and share what everyone thinks about it + report from the InSync09 conference. We will talk a bit about MySQL as it becomes Oracle technology now.
I enjoyed InSync09 conference and the networking opportunities there — great place to meet bunch of good old friends and make some new ones. The content of the presentations and direction where Oracle is going to provided some interesting food for thoughts on Oracle’s strategy and how it’s going to make money with all those acquisitions they’ve done recently including current Oracle-Sun deal.
In this post I want to cover how to run a DELETE and an INSERT as parts of the same statement. Have a look at the test case I developed.
It’s the second day of the InSync09 conference in Sydney — the first large-scale conference in Australia that combined user of all Oracle applications such as E-Business Suite, Hyperion, Siebel and all others that Oracle has bought in the last years. There is quite a bit of sessions on SOA and Fusion technology.
If you review the recent years of Oracle’s history, you’ll see that its purchase of Sun makes perfect sense. Oracle has tried to get in the OS business (Oracle Ubreakable Linux), the hardware business with their different partnerships (e.g.: Hewlett Packard Partner Relationship), and even into the MySQL business back when they bought InnoBase (Oracle and Innobase).
Lots of people are going to be proclaiming that it is the death of MySQL, as they did when Oracle bought InnoDB. But it is not. MySQL and Oracle may both be databases, but they are not competitors. To say they are competitors is like saying that an upscale bar and the corner convenience store are competitors because you can get soft drinks, coffee and tea at both. There are many applications for which Oracle is the appropriate solution, and there’s no reason to even try to see if MySQL can do the same job. Similarly there are many applications for which MySQL is the clearly appropriate solution and there’s no need to even consider Oracle.
I’m back again with another in what I hope will be a long line of “Quick Tips for Newbies” series. At Pythian, we are spread across multiple timezones, since it wasn’t too long ago that everyone was in Ottawa, this is something that still presents little quirks. One such quirk involved email generated by one of our internal Oracle instances—via a stored procedure that used UTL_SMTP to send the messages—did not have timezone information in the “Date” email header. As a result, they would be stamped with the hour in Eastern timezone (Ottawa time), but the mail clients would think that hour was local. Even if you aren’t sending email to all the ends of the Earth, it won’t hurt to make your messages timezone-aware. I’m sure it will save some confusion and frustration down the line. Here`s how.
InSync09 is the first conference in Australia focused on Oracle applications which in the past few years multiplied immensely in numbers — e-Business Suite, JD Edwards, JD Edwards, Hyperion, Siebel, BEA, PeopleSoft. There is also significant focus on SOA. The presentation that I’m doing is titled “Making Oracle E-Business Suite R12 Highly Available”. It’s more an architectural paper to show what are the paths and how to plan the environment for high availability and what technologies can be used. Obviously, I will touch some of the DBA friendly topics like RAC and DataGuard but it definitely won’t be focused on the database tier only. It’s actually going to be quite an experience as I’m not really an Apps DBA myself so learning curve has been quite steep. I do, however, have good advisers in this are so it should be fine.
Few days ago, I have put together the Quick Install Guide for Oracle 10g Release 2 on Mac OS X Leopard (Intel). I did mention that it would be cool to get APEX working as well but, apparently, APEX isn’t supposed to be running on Oracle 10g Release 2 Database on OS X as few people pointed our on the blogs. However, looks like few people did manage to run APEX on 10g using Embedded PL/SQL Gateway. ong story short, I was able to install APEX successfully using the native Mac OS X Oracle 10g Database and here is how…
Here is how to recreate the standby controlfile in just 6 easy steps!. Trust me, it sounds more drastic than it is!