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…
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…
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…
Why my Data Guard Physical Standby always had Apply Lag greater than 30 minutes?
Hey everyone, Hope you’re doing good. I had a call with a client some days ago, they have a Data Guard Physical Standby running in protection mode Maximum Performance. This…
Gathering Dictionary Statistics Runs Very Long Time. Why?
Hey everyone, Hope you’re doing good. We have a client that has a database used for a SAP BI solution (BW – Business Warehouse), which had stale statistics for dictionary…
How to Create a Job using DBMS_SCHEDULER to execute a Shell Script every Thursday at 9:00 am
Hey everyone, Hope you’re doing good. I was working for a client which would like to schedule a schell script every Thursday at 9:00 am to remove old traces. Client…
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…
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…
