About

Martin Klier

usn-it.de

Create Oracle Data Guard Standby with DBCA

Demands of Automation You can easily create an Oracle Data Guard Standby Database with the Database Configuration Assistant DBCA. That’s especially interesting if you have automation at work, and are not keen on configuring stuff all over the place. This is available in version 19c upwards. DBCA uses RMAN DUPLICATE FOR STANDBY with an auxiliary […]

read more

DOAG Konferenz 2021 Slides for Download

Thank you all for attending, commenting and discussing my presentations at DOAG Konferenz 2021. I am happy about the good feedback, and the attendance in the rooms. Meeting some of you in DOAG’s GatherTown was a good thing, to mimic the real conference center in Nuremberg. But still a mimic! I’m looking forward to DOAG […]

read more

Godspeed, Pieter van Puymbroeck

Last Sunday, I got a miserable call, one that everybody fears: On July, 16th 2021, the Oracle Community lost one of its loveliest members and a valued contributor. We all lost an amazing human being. I lost a dear and trusted friend: Pieter van Puymbroeck, you passed away in one of your favourite spots – […]

read more

When are Oracle RUs released?

When are Oracle Release Update and Release Update Revision released? What is the schedule for RU and RUR? It’s the same as for CPU. It’s important to know that the patch cycle that produces Release Updates (RU) and Release Update Revisions (RUR) actually is the quarterly Critical Patch Update (CPU) Program for database version 12.2 […]

read more

The Three Thirds of My Career (so far)

Recently looking into a renowned Professional Social Network, I was surprised: Somehow I managed to have three IT and Oracle jobs in sequence, and now mid-2020, all of them lasted the same amount of time. Six years and a half. 2002-2008, A.T.U Auto-Teile-Unger, where I learned to fly. 2008-2014, Klug / TGW Logistics, the lesson […]

read more

Very cool interview with Maria Colgan

Community work can be so much fun. When working for the German Oracle User Group, DOAG, one of my favourite jobs is interviewing interesting people for doag.tv. In fall 2019, we recorded a fun interview with Maria Colgan, Master Product Manager for the Oracle Database. I had the chance to prepare the story: Based on […]

read more

Oracle PGA Analysis Query

Sometimes, something in an Oracle Database starts eating PGA, and there is need to find out which process, and where the memory is left, and what or who is responsible for allocating / using / holding it. For a recent issue, I wrote the SQL below. It gives back one line for each Category (SQL, […]

read more

Make Linux Disk IDs Visible for UDEV (in VMware)

VMware is a factor Times and syntaxes change, so it’s time to refresh an old blog post a bit. Especially VMware has established its place in the Oracle world, and it can be tricky to map disk IDs directly into the VM. Many sources recommend to use the SCSI addresses, but I learned to never […]

read more

ORATOP in Oracle 19c

In 19c , the useful utility “oratop” is shipped with the Oracle Home installation. It was linked to the recent libaries, and its command line syntax changed. Error This leads to errors when calling one of the old “download” binaries like oratop12c-64.bin in a 19c environment: /home/oracle/bin/oratop12c-64.bin: error while loading shared libraries: libclntshcore.so.12.1: cannot open […]

read more