On Friday, 08/03/2013, I’ll present an online lecture about Oracle Architecture for the DOAG (Deutsche Oracle Anwendergruppe, German Oracle User’s Group) and the DOAG SIG Database. Link: http://www.doag.org/termine/termine.php?tid=454245 The lesson will contain (excerpt from TOC): Oracle Datenbank-Architektur Verbindung, Namespace(s) und Abschottung Instanz und Datenbank Alles Blöcke, oder was? Redo, Undo und was man […]
Oracle Grid Infrastructure: 11.2.0.3.5 PSU on AIX: gipchaLowerRecv: invalid message header hdr
Just a quick note: if you plan to apply PSU 5 on top of 11.2.0.3 on AIX 6.1 or 7.1 – it has a known issue. CSSD will not start on the second node (depending on the order how you start OHASD in the cluster) and ocssd.log will show “gipchaLowerRecv: invalid message header hdr” with […]
Oracle Grid Infrastructure / ASM – ERROR: failed to update diskgroup resource ora.DATA.dg
Recently, when installing a database on a grid infrastructure, dbca failed with the message that it wasn’t able to establish the dependency between the database and the corresponding grid infrastructure resource of the DATA ASM disk group I was using for my data files. Its name would have been “ora.DATA.dg”. (ERROR: failed to establish dependency […]
Oracle: DOAG Konferenz 2012 presentation – Child cursors / Mutex Waits
“Resolving Child Cursor Issues Resulting in Mutex Waits”: Here are my presentation and the white paper about child cursor related mutex waits. The white paper is also available as an article in the IOUG SELECT Journal 3rd Quarter 2012 (Vol. 19, Number 3). Thanks a lot to all attendees – it was great fun […]
Oracle: DOAG Konferenz 2012 – Look at’s
Hi there, as usual, here are my personal notes from DOAG Konferenz 2012 (annual conference of the German Oracle User’s Group). I was there for two days, not three, on account of workload. But it was really good there, and again the event was a great mixture of technology and people/networking. Ok, here’s the list. […]
OakTableWorld TED Talk: The Connectivity Issue
It was a great OakTableWorld this year. Thanks to the organization team around Kyle Hailey! There have been many speakers worth listening to, just to mention the best in my opinion: Cary Millsap, Jonathan Lewis, Tanel Põder, Alex Gorbachev, Connor McDonald and John Hurley. I had the chance to have a TED Talk of 10 […]
Oracle Database 12c announced for 2013
Oracle’s CEO Larry Ellison announced Oracle Database 12c, with a focus on its Pluggable Database feature.Oracle Database 12c will become available in 2013. Mr. Ellison pointed out, that in consolidation cases, saving the overhead for processes and memory structures gives the product an advantage over competitors. There have been more announcements: Oracle Cloud, Oracle Private […]
Oracle Open World: “Resolving child cursor issues resulting in mutex waits”
As promised in the session, here comes my presentation from Oracle Open World 2012, Moscone West, Room 2016 at 10:30 PST. For the case studies and detailed information, please see the white paper or my article in the newest IOUG SELECT Journal (Vol. 19 / No. 3 / Third Quarter 2012). Thanks a lot to […]
Effecting Oracle Miracles With Standard Edition And Statspack (=without AWR)
For the most time, I have to work with Oracle Standard Edition database systems without any chance to use AWR, ASH or Diagnostics Pack in general. But performance problems have to be analysed in budget environments as well, and many people are complaining about Oracle’s policy in this area. But in my experience, it’s also […]
R.I.P. Oracle Database 10g: “Oracle depends on humidity”
Or: “Why we should be happy about Adaptive Cursor Sharing” Premier Support for 10g R2 ended in July 2010, and Extended Support will end in July 2013, 11gR2 is widely used, and 12c is on the horizon. Maybe it’s time for writing a kind of obituary for my first Oracle love, and to spread a […]