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…
CRS-42216: No interfaces are configured on the local node for interface definition ethN
Hi everyone, Hope you’re doing good! I was working for a client where they were upgrading their Servers from RHEL 7 to RHEL 8. As part of this project, DB…
Effective Management of $ORACLE_HOME/.patch_storage: Cleanup and Archive Strategies
Hi all, Hope you’re doing good! I had a call with one of our clients, long story short, they would like to cleanup some space under $ORACLE_HOME/.patch_storage directory. There are…
