About

Martin Klier

usn-it.de

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

DOAG Regionalgruppe Nürnberg Anfahrt / Map

DOAG Regio und Meetup Die DOAG Regionalgruppe und Meetup Nürnberg hat ein großes Thema: Die Technologien von und rund um Oracle, und ist ganz leicht zu finden. Sie ist immer am gleichen Ort, und das Treffen findet immer am dritten Donnerstag eines jeden Monats statt (außer August und November). Die konkreten Termine und Themen werden […]

read more

Oracle ACE Director

Uh, there has been no blog entry for some time, had a busy time. So now I have a good reason to blog after returning from Collaborate18 in Las Vegas, where I had the chance to present two talks about SQL Tuning and Oracle Performance on VMware. The Oracle ACE Program usually hosts a dinner […]

read more

Oracle on Windows: ASM instance terminated by LMON / ORA-27300 IPC_TCPConnectCheck failed with status -1

Recently I had an issue with a two-node Grid Infrastructure on Windows 2012R2. After an infrastructure-caused cluster restart (irresponsible SAN hardware patching 🙂 ), everything was running on Node 2, and Node 1 could not join the cluster any more. No easy solution: On CSSD level, there was no issue (network and disk heartbeat worked, […]

read more

Oracle on SLES12 SP2 – Avoiding Cgroup Task Limit

Once upon a time, there was an Oracle RAC cluster 12.2.0.1 on SUSE Linux Enterprise Server (SLES) 12 SP2, that did not do well. Its database and ASM instances used to fail with: ORA-27300: OS system dependent operation:fork failed with status: 11 ORA-27301: OS failure message: Resource temporarily unavailable ORA-27302: failure occurred at: skgpspawn3 Of […]

read more

Oracle 12.2 sysctl.conf Default Preinstall Settings

This are the currently active settings, the oracle-database-server-12cR2-preinstall.rpm delivers on Oracle Linux 7. Maybe it’s useful for you when setting up Oracle 12.2 on SUSE / SLES where you are on your own. Maybe you also want to add Huge Pages: # Performing Databases Huge Page Settings # for SGA size 200GB and huge page […]

read more