Device Mapper Multipath – How this works? Why as a DBA I should concern about it?
Hi everyone, hope you’re doing good. On this blog post, I’ll discuss about DM Multipath and why this is so important when we are talking about Databases. OK, let’s first understand about how the disks interacts with the databases and/or vice-versa. If we think about…
Scheduler Job does not exist (not visible) in Snapshot Standby Database
Hi everyone! Hope you are doing good! I got a call from a client during their DR test. We do know that usually DR test means when the entire workload is moved to DR site. Some clients never execute DR test. 🙂 For this specific…
Query on Active DataGuard failing with ORA-12801 and ORA-03254
Hi everyone, Hope you’re doing good. I was working with a client where they have their DR environment running with Active DataGuard, ie, a physical standby database opened in read only mode, meanwhile is applying the transactions which are transfered from Production to DR. Sometimes…
Cluster Startup fails with CRS-41053
Hi everyone, Hope you’re doing good! A few weeks ago, DBA team of a client reached up to me and told me that they have a 2-node cluster where the second node it was not running as expected. I started the cluster troubleshoot: Let’s check…
opatch rollback cleaning up content of $GRID_HOME/jdk folder
Hi everyone, Hope you’re doing good! A few days ago, a client reached out to me because they had some issues during the rollback of a JDK patch that was installed in $GRID_HOME. Let’s better understand about the scenario: Client was running on RU 19.17…
STARTUP MOUNT failed with ORA-00210 ORA-00202 ORA-27086
Hi everyone, Hope you’re doing good. I’m working for a client which has Oracle DB for SAP applications. Those DB’s are not using RAC, yes, I know 🙂 SAP does not support use RAC in its fullness, as cannot use services…
Shell Script to monitor Oracle Enterprise Manager Agent
Hey everyone, Hope you’re doing good. Sometime ago, an old client called saying that they have migrated their Linux servers from RHEL6 to RHEL7. They have done a new installation instead upgrading OS. Because of this movement, OEM Agent was not starting…
Shell Script to create weekly backups for TDE Wallet
Hey everyone, Hope you’re doing good. As already discussed in the blog, every environment which uses TDE (Transparent Data Encryption), a wallet is needed to store the encryption key. The wallet is a file extremally important and critical for the health and…
Disclaimer
My postings reflect my own views and do not necessarily represent the views of my employer, Accenture.