LogMiner Eating Up the CPU
Hi everyone, Hope you’re doing good! A few days ago, a client complained about a slowness in their SAP DB environment running on Oracle. DB version is 19.24. I asked…
Two Clusters with Same Name. How to Fix It?
Hi everyone, hope you’re doing well! I was working on a RAC migration project for a client. I did the Cluster install for the first environment. Cluster and DB versions…
ORA-32000 when Cluster is in Rolling Patch
Hi all, I hope you’re doing good. I got a call from a client, DBA team was trying to change some parameters on ASM and getting an error: You cannot…
How to Retrieve Oracle DB System Details Using SQL?
Hi all, I hope you’re fine. You may don’t know, but Brazilians love WhatsApp! I’m part of a WhatsApp Group for the Brazilian Oracle Users Group (GUOB). Today, an user…
Finding the Needle in the Haystack: Troubleshooting Performance Issues with ASH and dashtop.sql
Hi all, I hope you’re doing good. After a client migrated their main database to RAC (they just did the switchover from Single Instance to RAC using Data Guard), they…
SELinux Blocking AHF/OSW from Writing Logs – How to Fix It
Hi everyone, Hope you’re doing good. I was working for a client and they complained about some errors they found on logs about AHF/OSWatcher and SELinux. Here are the errors…
How to Customize the oracle-database-preinstall package?
Hello all, Hope you’re doing fine! I was working in a project where client was building Oracle RAC clusters. They would like to use the oracle-database-preinstall package to make sure…
ORA-12514 when using TNS entry for SCAN_LISTENER
Hi everyone, Hope you all are doing great! It’s been a while since my last post. Well, today I’m going to share about an issue you all can get it…
