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…
Automating Bulk Data Loads into Oracle Database with Shell Script and SQL*Loader
Hey everyone, Hope you’re doing good! Recently, a client approached me with an urgent issue: they needed to load 456 files into an Oracle Database table to resolve an integration problem. These files were compressed in ZIP format and contained data in fixed-position records with…
How to Calculate Database Uptime Querying the Oracle Enterprise Manager Views
Hi everyone, Hope you’re doing good! Ensuring high availability of your Oracle databases is crucial for maintaining optimal performance and meeting Service Level Agreements (SLAs). Oracle Enterprise Manager (OEM) provides a comprehensive way for monitoring and managing database uptime. With that said, I received a…
Why is the INSERT Statement Slow? Understanding ‘db file sequential read’ Waits
Some weeks ago, a client called complaining about a slowness during its load in a table. The scenario it was pretty simple: They are loading the table using the INSERT statement for each agency (agency_id), with thousands of records for each agency. They complained that…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.