A while ago, DOAG.tv interviewed me about Oracle’s Standard Edition and database system migrations. The material was published just recently, so I’d like to share it. Enjoy, and if there are questions, just let me know! http://www.doag.org/home/aktuelle-news/article/oracle-database-standard-edition-versus-enterprise-edition.html I have to add a corrigenda: SE RAC is not – at least not at the moment – limited […]
Year: 2014
DOAG 2014 Presentation and Whitepaper online: Database I/O
Hi, my #DOAG2014 presentation and whitepaper are online now! “Oracle Core für Einsteiger: Datenbank I/O” Presentation: http://www.performing-databases.com/uploads/media/OracleCoreDatabaseIO-Klier-2014.pdf Whitepaper: http://www.performing-databases.com/uploads/media/Klier-Database-IO.pdf Thank you all for attending! Regards Martin Klier […]
It’s #DOAG2014 time!
Hello World! It’s time for all Oracle folks to congregate in Nuremberg for DOAG Konferenz 2014! I’d love to meet and greet you there – maybe you are also interested in my talk for Database Rookies: “Oracle Core für Einsteiger: Database I/O”: https://www.doag.org/konferenz/konferenzplaner/konferenzplaner_details.php?locS=0&id=459293&vid=485382 Hope to have a great week with you! Martin Klier […]
Visited Germany’s first Spatial Database, Size 26 kiloStones
Last week, I had the chance to visit Bavaria’s (and so also Germany’s) oldest Spatial Database. It’s buried deep below Munich, and contains all the geo information about Bavaria in scale 1:5000 and some in 1:2500. It was introduced in 1808 and was in use until 1950. That’s also the current state of the data. […]
New German Linux Forum (forum.linux-talk.de)
In the last weeks, some folks were busy to build a new German Linux Forum “forum.linux-talk.de”, since the predecessor was systematically ruined by the commercial owners. Especially Jean (wdp) and Hendrik (Nilpferd) invested much time and money into building the new environment. So the new forum is completely free of ads and commercials, and the […]
Performance is rarely an accident (Deutsch)
Some time ago, I saw a great presentation of Cary Millsap: „Thinking clearly about performance”. It was obviously relevant for our internal developers, so he unhesistantly granted me permission to reproduce some of his ideas for us. Cary, thank you very much! Here you can see, what I made out of the topic, mostly for […]
Oracle 12c InMemory – don’t stop thinking about performance
Oracle has released its new database version 12.1.0.2 that includes the famous in-memory column store. InMemory option promises a big advantage for OLAP-like work loads by keeping table contents in a columnar in-memory structure. InMemory is not new, they did that for decades, but the interesting part is “columnar”. There’s much writing about that on […]
Oracle 12.1.0.2 with In Memory Option available for Linux
As of today, the Oracle Database 12.1.0.2 with InMemory Columnar Store is available at https://edelivery.oracle.com. According to the price list of July 10th, it will be sold as an option for Enterprise Edition (Exadata NOT mandatory), for US$ 23,000 per CPU (calculation like EE). Hope it will do well, beta demos were extremely impressive. Yours […]
Oracle Core für Einsteiger: Datenbank I/O at DOAG 2014
Proud to announce, that DOAG accepted my tech talk “Oracle Core für Einsteiger: Datenbank I/O” for DOAG Conference 2014 in Nuremberg. It’s my next contribution to DOAGs thread aiming at beginners and part-time database people. The talk will be in German, here comes its abstract: Oracle Core für Einsteiger: Datenbank I/O Wir kennen verschiedene I/O-Typen, […]
Status Blog
Hello, long time no see? Many things have changed here, so my time for blogging was limited. Together with Benedikt Nahlovsky, I founded “Performing Databases“, a company to offer top-class database know-how combined with flexibility and agility. Doing all the formal requirements, and pushing business into life absorbed much of my free brain space. In […]
Oracle SQL Developer: New window, new session. Bad behavior?
Yay, it’s there. SQL Developer 4 is usable. It brings a new session for a new window (“unshared worksheet” in Oracle terms) – I was told lately SQL Developer 3 already had this. Did you know? Now we are kind of stable in 4: The 4.0.2 build 1521 (hehe) works good, so it’s time to […]
Oracle 11.2 PSU2 Grid Infrastructure stack start … failed to complete at crsconfig_lib.pm line 11814
Oh, sometimes it’s just (own or close-people’s) PEBKAC that costs you time and gray hair… Patching 11.2.0.4.x to PSU2 on Linux was such an issue. Problem “opatch auto” with all comfort worked well, applied the patch, but re-starting the clusterware failed with: Starting CRS… Installing Trace File Analyzer CRS-4123: Oracle High Availability Services has been […]
Oracle on Linux: How to hide your password when using a wrapper script
Sometimes, a DBA has to write an externally called wrapper script for various Oracle-supplied commands accepting password inputs. A prominent and simple example is SQL*plus (sqlplus). The Problem The process list shows all parameters of a command that’s currently executed. wrapper1.sh Accepts all connection infos on the command line: #!/bin/bash cmdstring=”sqlplus ${1}/${2}@${3}” echo “Executed command: […]
Slides for COLLABORATE 2014 IOUG forum talk #C14LV
Hi folks, here’s my slides for “YOUR machine and MY databases – a performing relationship?!” at Collaborate 2014 Las Vegas. Any feedback is greatly appreciated! 2014_141_Klier_odp_v1 2014_141_Klier_v1_doc Some pictures to come soon! You may want to follow the #C14LV hashtag to see what’s going on. 🙂 […]
SQL Server Analysis Look At’s
End of March, I had a chance to dig a bit deeper into MS SQL Server analysis. The german chapter of PASS (http://www.sqlpass.org) organized one of their “Essentials”, a condensed training day with a specific topic. This one was named “SQL Server Analysis” and was held by Andreas Wolter (MCSM) in Nuremberg. Here comes my […]
DOAG Würzburg: “Resolving child cursor issues resulting in mutex waits”
I feel honored that DOAG asked me once more for being a speaker at an event – this time it’s DOAG Regionalgruppe Würzburg. I will give my (updated) C12LV and Oracle Open World 2012 talk “Resolving child cursor issues resulting in mutex waits” there, supported by my new business Performing Databases GmbH. My abstract: In […]
Oracle Dataguard: ORA-00600 [krsu_upi_atc.7] – crash when primary ships the first time
After setting up a new Oracle Dataguard system (primary plus one standby DB), everything looked promising. But after activating the log shipping from primary, and after archiving a redo log for the first time, the primary instance crashed with ORA-00600 [krsu_upi_atc.7]. Without the standby system available (DB idle or listener off), no error occurred. ****************************************************************** […]
DOAG Database Conference Düsseldorf: “YOUR machine and MY database” was accepted
DOAG just informed me that my talk, “YOUR machine and MY database – a performing relationship!?” was accpeted for DOAG Database Conference Düsseldorf. Last year, the first Database Conference at Düsseldorf was a great success, I enjoyed it very much. I’m glad to be part of the speaker’s corps this year. Hope to see you […]
Klug GmbH integrierte Systeme wins Oracle Excellence Award Germany 2013 category “ISV”
I’m proud to announce that my employer, Klug GmbH integrierte Systeme, Teunz (Germany), won the Oracle Excellence Award Germany 2013 in the category of Independent Software Vendors (ISVs). […]
Oracle Clusterware root.sh issue: USM driver install actions failed (oracleoks.ko)
As I already said in my last post about “Can’t install ohasd service“, setting up Oracle Clusterware 11.2.0.4 on SuSE Linux Enterprise Server (SLES) SP2 should work flawlessly, but sometimes it does not. 🙂 This time, it was about the USM drivers. USM driver install actions failed /u01/app/grid/11.2.0/perl/bin/perl -I/u01/app/grid/11.2.0/perl/lib -I/u01/app/grid/11.2.0/crs/install /u01/app/grid/11.2.0/crs/install/rootcrs.pl execution failed USM drivers […]
Oracle Clusterware root.sh fails: Can’t install ohasd service: Inappropriate ioctl for device crsconfig_lib.pm line 5427
Setting up Oracle Clusterware 11.2.0.4 on SuSE Linux Enterprise Server (SLES) SP2 should work flawlessly, but sometimes it does not. 🙂 It turned out that this would become a pair of blog entries. Second one is about “USM driver install actions failed (oracleoks.ko)“. But step by step. On Saturday morning, root.sh failed with the following […]
Oracle on AIX: How to find out the process memory usage
Calculating memory on Unix is tricky business. Especially when a complex software like Oracle Database has shared memory segments like SGA and Code Area. One might be convinced to use the following construction to calculate the overall memory footprint of Oracle processes running on this machine: ps -elf |egrep ” oracle* | ora_.*_* ” | […]
Speaking at COLLABORATE 14: “YOUR machine and MY database – a performing relationship!?”
I’m excited to announce that IOUG accepted my talk “YOUR machine and MY database – a performing relationship!?” for COLLABORATE 14 in Las Vegas. I’d love to see you there – for tech talk, gossip and meeting old and new friends! Abstract: Databases affect machines, machines affect databases. Optimizing one is pointless without knowing the […]