Administration Database 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 t… May 31, 2023 3 min read
Administration Database 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), … May 31, 2023 3 min read
Administration Database 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 prote… May 31, 2023 4 min read
Administration Database 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 h… May 30, 2023 3 min read
Administration Database 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 r… May 30, 2023 2 min read
Administration Database 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 perfor… May 30, 2023 2 min read
Administration Database 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),… May 19, 2023 2 min read
Administration Database 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 r… May 18, 2023 3 min read
