How to Create a SQL Patch for a Query from the AWR views
Hey everyone, Hope you’re doing good! In most applications, application code is static and cannot be modified by users. If there is a performance issue with application SQL, one potential solution is to modify it adding hints to force the desired access path. Sometimes, the…
How to Change TDE Wallet Password
Hey everyone, Hope you’re doing good. In the last two years I worked for a client where we have activated TDE (Transparent Data Encryption), where we have enabled the encryption for datafiles on tablespaces used by application. To use TDE, the requirement is to have…
ORA-01565 ORA-01034 ORA-00205 Linux-x86_64 Error: 13: Permission denied when starting DB Instance
Hey everyone, Hope you’re all doing good. A few days ago, I received a call from a client regarding an issue during a RAC instance startup running on 19.17 version. This environment consists in a 2-node RAC, running with user segregation, so, for Grid Infrastructure…
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…
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…
Upgrade Project with Near-Zero Downtime using GoldenGate – How to Clone ASM Disks – Part 2
Hi all, Hope you are all good. This is the second 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…
About
Blog recognized by:
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.
Find
Archive
Blogroll Internacional
Blogroll Nacional
Links
Visitors
