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 change system wide parameters when cluster is in rolling mode. The reasoning behind disallowing parameter…
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 posted these questions there: The questions are: That was a great question! I’m glad that…
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 started complaining about some performance issues with a very specific business function. Their team was…
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 they found (output truncated to make reading easier): type=AVC msg=audit(1726515744.9:642519): avc: denied { append }…
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 their environment is following the requirements and best practices as asked by Oracle. Why use…
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 when using RAC. This issue happened on September 2024, client was running on 19.24 version….
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 Servers are part of upgrade. On this client, they use a naming convention for network…
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 a lot of options to accomplish this. I will talk a little bit here about…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.