Skip to main content

Posts

How to apply RU patch on OEM Agent in Linux

Introduction: In this article we will be applying the Agent RU patch 13.5.0.27 (37784425) for OEM 13c or Oracle Managed Services (OMS) Agent of particular target in Linux OS. AgentPatcher: AgentPatcher is an Oracle utility used to apply patches and updates to the Oracle Management Agent component of Oracle Enterprise Manager (OEM) Cloud Control. It is same like OPatch utlity for applying database patches. Prerequisites: Below are the minimum requirements. Downtime required at particular target agent end for 30 mins. Minium 2GB space should be free in mount point for patch & Binary backup. RU Patch 13.5.0.27 (37784425) should be applied on OMS. Download the RU Patch & required AgentPatcher from below link. Agent RU patch 13.5.0.27 AgentPatcher Environment: OEM Hostname oem.oraeasy.com OS OL 7.3 OEM Version 13c Release 5 (13.5.0.27) OMS Home /oem/app/oracle/middleware ...

Rollback Oracle RU Patch

Introduction: In this article, we will do rollback or deinstall the RU patch step by step. You may require to rollback the particular patch if any issue arises due to patching. Prerequisites: RU patch should be applied. Downtime required at Database end for 120 mins. Environment: Hostname devdb.oraeasy.com OS OL9 Database Name DEVDB Approach: We have applied 2 RU patches: 19.25(36912597) & 19.27(37642901). We will rollback the 19.27(37642901) patch. . Now let's proceed to rollback the patch step by step: 1. First we need to take some precheck along with the patch details. SQL> DEF DEFINE _DATE = "02-SEP-25" (CHAR) DEFINE _CONNECT_IDENTIFIER = "devdb" (CHAR) DEFINE _USER = "SYS" (CHAR) DEFINE _PRIVILEGE = "AS SYSDBA" (CHAR) DEFINE _SQLPLUS_RELEASE = "1927000000" (CHAR) DEFINE _EDITOR ...

Cross Platform RMAN restoration || Linux to Windows

Introduction: In this article, we will do database migration from Linux to Windows via RMAN step by step. It can also be referred as Cross Platform restoration using RMAN from Linux to Windows. Patch consideration: As Oracle provides different patches of Windows & Linux, so it is a best practice to run the datapatch verbose post restoration to update the sql patch registery. Environment: Source Database Hostname devdb.oraeasy.com OS OL 7 Database Name DEVDB Database Version 19c(19.25) Oracle Home /u01/app/oracle/product/19c/db_home Datafile Location /u01/app/oracle/oradata/devdb Target Database Hostname oraeasy OS Windows 11 Database Version 19c(19.27) Oracle Home D:\app\oracle\product\19c\db_home1 Datafile Location D:\app\oracle\oradata\devdb Now procee...