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 }…
Disk failed even using Multipath. How? Why?
Hi everyone, hope you’re doing good. In my last post I explained some basic concepts about Multipath and the importance to use it. You can read more here: Device Mapper Multipath – How this works? Why as a DBA I should concern about it? On…
How to copy SQL Patches, SQL Profiles and SQL Baselines between environments
Hey Everyone, Hope you’re fine. This is a simple and short post, but extremely useful. I was in a migration project and client used PreProd environment for stress test, code deploy, functional validations, etc. This PreProd environment have the sizing similar with…
Sequence value JUMPING after some “error”
Hey everyone, Hope you’re doing well. This week it happened a “good” discussion in a WhatsApp Group for a DBA Brazilian Community (DBA Brasil). One colleague was facing an “inexplicable” situation. He had an object SEQUENCE, configured with INCREMENT_BY to 1 and CACHE_SIZE to 20…
Resolving OEM Alert Issues regarding Tablespaces
Hi all, Hope you’re doing good. A client called me a few days ago regarding an issue with their OEM environment. A huge database got some tablespace space exhausted and OEM did not generated the alerts. After a deep review on…
Linux: How to search in which package is a specific file
Hi all, Hope you’re doing good. Sometimes we need to install some packages on Linux. Sometimes we already know what are the packages, sometimes we only knows what is the file provided by package, but without knowing the package name. YUM utility…
RSM0 Killed during Physical Standby conversion
Hi everyone, Hope all of you are doing good. Recently I was contacted by a client which were doing DR tests on its environment. All databases have Physical Standby (DataGuard) as a DR solution. In all DataGuards they have DG Broker configuration in place. Two…
Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 3
Hi all, Hope you are all good. This is the last post showing how to create a clone of ASM Disks to do your DB clone very quickly to use it as a target for GoldenGate. Just to recap what we did in the last…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.