Last days, I had an interesting issue with a customer’s test database. The DB crashed, after manually but unintentionally corrupting the SYS schema (dropping an unknown number of objects). Restarting the instance (open) ended with: ORA-00600: internal error code, arguments: [kokiasg1], [], [], [], [], [], [], [], [], [], [], [] Our quick fix […]
Category: Oracle
What’s the difference between Larry Ellison and god?
Oracle Real World Performance Tour 2014 with Tom Kyte and friends in München (Munich)
The German Oracle User Group (DOAG Deutsche Oracle Anwendergruppe) announced Munich as a location of the Real World Performance Tour 2014 with Tom Kyte, Senior Technical Architect ORACLE Server Technology Division, ORACLE Vice President Graham Wood, Architect Server Technologies Andrew Holdsworth, Senior Director Real World Performance Server Technologies Location: Munich (Details coming soon) Date: February […]
Upcoming DBA in Team Oracle Germany? :)
I’m no fan of preselecting kid’s ways of life. But I couldn’t resist bringing a T-Shirt from OpenWorld back to Germany. Now since it fits Maxi, I’m just loving it. 🙂 The other picture is my teammate Benedikt as Maxi’s cushion. 🙂 Please: Let […]
Oracle SQL Developer connection storm at startup
Oracle SQL Developer (tested with version 3.2.20.09) does some unwanted network connection testing against all configured connections (by TNSPING). We noticed that it causes a kind of unwanted “inverse” connection storm to all configured databases, when we start the SQL Developer. It’s not restoring aborted connections or stuff like that, all was quit before stopping […]
DOAG Webinar: ORACLE Datenbank Architektur – nicht nur für Einsteiger (German Language)
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 […]