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 […]
Category: Oracle
What’s the difference between Larry Ellison and god?
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, […]
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 […]
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 […]
Oracle Database 18c changed MRP checkpointing from log boundary to time-based
The gap The story started with an always-unpleasant alert log message: The reason Looking into v$archived_log: The log sequences 2306-2405 ARE applied on standby. And thus deleted by policy from the Fast Recovery Area. Okay, this explains the effect, but not the root cause. So we had to open a SR with Oracle Support. The […]
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 […]
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 […]
Oracle: Create a Materialized View with Fast Refresh on commit and debug upcoming errors
Sometimes, our users and customers need rapid access to complex data structures. Materialized Views in their various forms are a very potent way to shift efforts from the query to insert/update time of base data. That’s the nature of a Materialized View: One way or another, we need to put the data into a redundant structure. With […]
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, […]
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 […]