Posts by Vimal Raju

Index Usage & Missing Index Checks in Oracle

A Practical Guide for Oracle DBAs Indexes play a critical role in Oracle database performance. While well-designed indexes can dramatically improve query response time, unused or missing indexes can just…

Read More

Oracle Audit Trail Queries

A Practical Guide for DBAs Auditing helps Oracle DBAs track who did what, when, and from where. Whether for security reviews, compliance, or incident investigations, having ready-to-use audit queries saves…

Read More

Automated Compilation of Invalid Database Objects in Oracle Multitenant Architecture

Detailed Description: The compile_invalid_objects.sh script is designed to automate the identification and compilation of invalid objects across pluggable databases (PDBs) within an Oracle multitenant database environment. Invalid objects—such as packages,…

Read More

Automated PDB Enumeration and Dynamic Login Selector for Oracle Multitenant Databases

Detailed Description: This Bash script automates the enumeration and dynamic selection of Pluggable Databases (PDBs) in an Oracle Multitenant environment. It connects to the Oracle Container Database (CDB) as a…

Read More

Diagnosing and Repairing Failures with Data Recovery Advisor

Data Recovery Advisor feature helps in diagnosing and repairing data failures. It will automatically diagnose the issue and provides the recommendation for the repair that helps to resolve the data…

Read More

Redo log corruption

What is a Redo log corruption?   In the Oracle RDBMS environment, redo logs comprise files in a proprietary format which log a history of all changes made to the database. Each redo log file consists…

Read More

How to download the database backup from OCI storage using MV2bucket

Introduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to download the database backup from OCI…

Read More

How to upload the backup files to OCI Archival storage using MV2bucket

Introduction : Oracle database automated backups are stored in Oracle Managed Object Store Buckets in OCI. This blog covers step by step process to Upload the database backup files from…

Read More

How to Upgrade JDK in OEM agent

Steps to upgrade the latest JDK in OEM agent : 1. Check JDK Version. Go to OEM agent location and check the java version. cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0/jdk/bin ./java -version 4. Upgrade…

Read More

How to upgrade the OEM Agent Release update

Steps to upgrade the latest OEM Agent Release update 1. Install the latest AgentPatcher Download the latest Agentpatcher from oracle support. cd <Patch location> cp p33355570_135000_Generic.zip /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 cd /u01/app/oracle/product/agent13c/agent_13.5.0.0.0 unzip…

Read More