About

Martin Klier

usn-it.de

Speaker at DOAG 2015 Datenbank – “Oracle Core für Einsteiger: InMemory Column Store”

The DOAG 2015 Database conference is on the horizon: June 16, 2015 in Düsseldorf, Germany. I’m proud to announce my participation as a speaker, as I was honoured with in the years before. This year, my part will be a new “Beginners” talk in German: “Oracle Core für Einsteiger: InMemory Column Store”   Abstract: ==================== Der Vortrag richtet […]

read more

DOAG Noon2Noon Event Nürnberg / MySQL vs. Oracle – Review

It was time to try something new in our DOAG Database Community. And please, please just not another frontal conference: twenty guys look forward, one looks back, like eight-oars-and-coxswain. I don’t know if DOAG invented it, but it was a success: The Noon2Noon Event. How does it work? It’s like 24 hours of BarCamp, starting with […]

read more

Oracle 12c Multitenant: impdp fails w/ ORA-31625 and ORA-01031 because of Database Vault

Things are different in Oracle Database 12c with multitenancy option. My most recent example: I tried to import a schema (new name “NEWSCHEMA”) with datapump IMPDP and REMAP_SCHEMA into the same pluggable database it has been exported from with EXPDP immediately before (name “OLDSCHEMA”), running as SYSTEM. I’m doing things like that with DBA permissions, since […]

read more

Oracle: Did my SQL get worse over time? (AWR query)

Sometimes, we get statements to look at, and are told “it’s getting worse and worse”. Since DBAs are well advised not to take anything for granted and only to believe what they see with own eyes, here comes a SQL on AWR to see Buffer Gets per Minute, over time. select s.BEGIN_INTERVAL_TIME, round(t.BUFFER_GETS_DELTA/ 0.0001+ (extract […]

read more

Martin Klier in DOAG.tv Interview: Oracle Standard Edition

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 […]

read more

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 […]

read more

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   […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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, […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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: […]

read more

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. 🙂   […]

read more

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 […]

read more

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. ****************************************************************** […]

read more

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 […]

read more

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 […]

read more

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_.*_* ” | […]

read more

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 […]

read more

Oracle Datenbank Architektur – nicht nur für Einsteiger (DOAG Konferenz 2013)

Thanks everybody for attending my talk “Oracle Datenbank Architektur – nicht nur für Einsteiger” at DOAG Conference 2013. It was a great feeling to have a packed room there. As promised, here comes my presentation and whitepaper (both in German). OracleArchitektur-DOAG OracleArchitekturNichtNurFürEinsteiger_Klier Feedback is always appreciated! […]

read more

DOAG Presentation: Oracle Standard Edition RAC

Wednesday last week, I had a presentation for my regional Oracle Users Group (DOAG Regio Nürnberg). The month before I was asked to display the difference between Enterprise Edition and Standard Edition RACs. Here comes the presentation (German), for questions and suggestions just let me know. Stay highly available Martin Klier […]

read more

Martin Klier now on twitter

After ignoring the little bird telling things for quite a while, I decided to join the tweeters. Twitter might bring more color into my daily reading. 🙂 If you feel like, just follow me – @MartinKlierDBA […]

read more

Oracle 12c: Change hostname for Grid Infrastructure / Oracle restart

Few days ago, we cloned a VM test system with ASM. Changing the hostname in this case is mandatory from our network, we have lots of issues if they are duplicate. But changing an Oracle Restart or generally, Grid Infrastructure setup’s hostname isn’t so easy – it’s written many configs. The only way is to […]

read more

Oracle 12c New Features – Look at’s for 12.1.0.1.0

A new product … Last week I spent some days of intense investigation and testing the new database 12c. I found lots of great stuff (even about 11g 🙂 ), and some for sure will make it into a separate blog post. So these are just my notes of a very interesting couple of days, […]

read more

DOAG Konferenz 2013: “Oracle Architektur – nicht nur für Einsteiger”

      After speaking about mutex waits last year, this time DOAG accepted my lecture “Oracle Architektur – nicht nur für Einsteiger” about Oracle Database basic architecture for this year’s DOAG Konferenz 2013 in Nürnberg. It will be the first lesson in a brand-new stream of the conference: The so-called “Einsteigerpaket” (beginners package) allows […]

read more

How NLS settings can affect Oracle’s join behavior – v$ example

Recently, I had a problem with accessing Active Session History being not fast enough on Oracle Database 11.2 and 12.1. Looking at the explain plan, wow, no doubt why: Accessing two fixed tables with TABLE ACCESS FULL and joining them with NESTED LOOP. This couldn’t have been “works as designed”, it would render gv$active_session_history nearly […]

read more

Oracle SQL: Optimizing a WHERE predicate inequality with a Function Based Index

Intro Recently, on Oracle 11.2.0.3, I saw a join of three tables, using three times TABLE ACCESS FULL and HASH JOIN, without an obvious reason. During separating and understanding its components, the following scenario turned out to be the culprit. select * from CARDTEST where OBJECT_ID<DATA_OBJECT_ID; The optimizer is unable to calculate the cardinality of […]

read more

Oracle Database 12c Release 1 available

Since today, Oracle allows downloading the newest release of the Database product 12c via http://edelivery.oracle.com So far I only can see it for the Linux platform, and docs are still missing. But this may change rapidly. Take care Martin Klier […]

read more

Oracle Support allows SR details in notification emails

Yes, they did it! Finally, last night’s announcement from Oracle Support brought a long-missed feature: We can opt-in to get Service Request details in MOS’ notification emails. It’s of great benefit when you are on the road, no need to log in to the far-famed support portal. This is how the CUA has to allow […]

read more

ORA-600 [kokiasg1] – reasons and workaround

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 […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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 […]

read more

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. […]

read more

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 […]

read more

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 […]

read more