About

Martin Klier

usn-it.de

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

Back again!

The blog was a bit neglected over the last time. But now, with a new face and a modern backend, I’m determined to use it again. 🙂 Thanks very much Valentin and Hendrik, who did an amazing job with renewing the infrastructure and the new theme! Stay tuned! Martin […]

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

Oracle RAC 12.2 on SLES12 – How to disable Hardware Lock Elision Support

The Problem In the last week, I had to set up an Oracle RAC (and thus, the Clusterware) version 12.2.0.1 on SuSE Linux Enterprise Server 12 SP2 (SLES12 Sp2). The gridSetup.sh failed latest in root.sh of the first node with a kinda non-intuitive error: CRS-5804: Communication error with agent process CRS-4000: Command Start failed, or […]

read more