Posts

GOLD Image Creation IN OEM

  🛠️ GOLD Image Creation  Creating a standardized GOLD image for Oracle Grid Infrastructure and Database binaries is essential for maintaining consistency, simplifying patching, and ensuring compliance across production environments. This guide walks you through the process of setting up and generating a GOLD image using  Oracle Enterprise Manager (OEM)  on the  GCP production server ( OEM Server ) . ✅ Prerequisites 🖥️ Environment Setup Login Server :  OEM Server Source Database Server :  Test DB Server Oracle Version : 19.22 Target Requirement : Database must be patched with version 19.22 before proceeding. 🔐 Credential Creation In the  OEM Console , create the following credentials: Normal Credential Name :  V2V_ORACLE_VM_LOGIN User :  oracle Privilege Credential Name :  GLOBAL_SUDO_TO_ROOT_VIA_ORACLE User :  oracle  with sudo privileges to root ...
Post a Comment
Read more

Oracle Fleet Maintenance Patching – Detailed Implementation Plan

  Oracle Fleet Maintenance Patching – Detailed Implementation Plan Overview This document provides a comprehensive procedure for Oracle Fleet Maintenance patching to 19.24.0.0.0 across RAC clusters. It covers precheck, implementation, post-check, rollback, and testing plans. 1. Pre-Change Checks Includes all the pre-implementation validations and checks to ensure the environment is ready for patching. This phase helps identify any potential conflicts or configuration mismatches. 2. Implementation Plan Step-by-step instructions to perform the actual patch deployment using Oracle Enterprise Manager (OEM). This section also includes command references for all tasks and validations. 3. Post Implementation Verification Validations to ensure the patch has been applied correctly and all Oracle services are functioning from the new Oracle homes. 4. Backout (Rollback) Plan This section defines the rollback procedure if the patch fails or needs to be reverted due to any unforeseen...
Post a Comment
Read more

Database Growth report

 Use this query to find future database growth projection. --Output  Database   Create     Database   Used    Used    Free    Free                    Previous   Previous   Current    Current    Previous   Previous   Current    Current Name       Time       Size       Space   in %    Space   in %    Week    Week in Month      Month in % Month      Month in % Year       Year in %  Year %     Year in % ---------- ---------- ---------- ------- ------- ------- ------- ------- ------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- ---------- set   longchunksize   500 ; set   pages...
Post a Comment
Read more