The process for applying a patch on top of the CRS, or now called, the Grid Infrastructure, has changed from what we used to do on 11gR1 and prior releases. The patch I had recently applied was in order to resolve the Oracle bug “18.104.22.168 ONS CORE DUMP or High Resource Usage [ID 988795.1]“. Due to the fact that the patch doesn’t require full downtime and could be applied on a rolling basis, the plan below is to be executed on each node at time.
One of the most critical skills of any Oracle DBA is the ability to prevent a system crash and to restore and recover the system in case of a disaster. The “Oracle RMAN 11g Backup and Recovery” book by Robert G. Freeman and Matthew Hart is a resource that can definitely help to acquire the skill. I recently received my early copy of it, and am honored to have contributed to Chapter 5 “Oracle Secure Backup” for it.
I want to post the slides of the two presentations I did. My first presentation was a double slot session about Oracle Clusterware internals. My second presentation was about how we designed and run 1TB MySQL database in high availability setup.
I have successfully compiled and installed DBD::Oracle on Windows 2008 Server 64bit operating system today. I used the latest version of DBD::Oracle 1.24, version 22.214.171.124.0 for 64bit Windows of Oracle’s Instant Client Package – Basic along with the Instant Client Package – SQL*Plus and finally the Instant Client Package – SDK. Here are some instructions that will help with the install.
Recently I’ve been puzzled with the performance difference observed between 11GR1 and 11GR2. As part of the investigation I’ve decided to compare session stats from both 11GR1 and 11GR2 and found that there is a big difference for session cursor cache hits. But the number of session cursor cache hits I’ve been observing in 11GR2 just didn’t made any sense while being absolutely fine in 11GR1. An overflow was certainly a possibility, though in 2010, it’s not like someone should be counting every bit especially if they didn’t in 11GR1! Anyway it was worth a shot so I’ve decided to check it out…
Once again into the breach. The release of Ubuntu 10.04 is at hand. I’ve been playing with “Lucid” for a couple of months now but since we’re in beta2 with the release candidate soon to follow, I thought I would really sit down and get my normal app stack working including TOra. All in all the instructions are mostly the same as last time around, with a couple of new improvements, caveats and quid pro quo.
I’m in Denmark these days at the wonderful Oracle conference organized by Miracle A/S — Miracle OpenWorld 2010. Opening session was something special this year, the opening was rounded up with a new film production demo from We Do Not Use TV Studio. Time to grab a bite and get ready to my dual-slot presentation — Under the Hood of Oracle Clusterware which is the very first presentation of today. More to come — stay tuned.
Oracle invested heavily in open source even before the acquisition. Linux (Oracle Unbreakable Linux = Oracle Enterprise Linux = OEL). Clustering, data integrity, storage validation, asynchronous I/O, virtualiation technology that has been accepted back into the Linux kernel. They have enhanced Xen, in order to make a good Oracle VM server for x86. With Sun, they now have VirtualBox. In the 3 years of OEL, they have over 4,500 companies.
There you can find the list of EM 11g new features. After I quickly skimmed through it I could mention few areas…Here is the surprise you might not have expected — you now need to install Oracle WebLogic Server 10.3.2 (Oracle Fusion Middleware 11g Release 1 Patch Set 1) as a pre-requisite to Oracle Grid Control installation.
I’m tired reading all over the internet — Oracle taking back OpenSolaris, Open Solaris May Die?, Solaris Is Dead, Save Open Solaris, Oracle taking back OpenSolaris. I’m so sick of it! I see that some don’t even know the difference between OpenSolaris and commercial Oracle Solaris (former Sun Solaris 10)! Wake up people! Oracle did make commercial Solaris 10… eh… commercial, that is.