Posts by Shankar Narayanan

OEM Agent Installation in 13.5

Description: This guide provides a detailed, step-by-step process for installing and configuring the Oracle Enterprise Manager (OEM) 13.5 Management Agent on target servers. It starts with the initial OMS login…

Read More

APEX & ORDS UPGRADE

Description: This document explains how we upgraded Oracle APEX, ORDS, and Java on the DBNAME database. It covers the checks and backups done before starting, the steps for installation and configuration, and how we fixed common issues during the process. The aim was to move from older versions to APEX 24.1, ORDS 24.1, and Java 11 smoothly, without affecting service availability. Componets Current versions   Upgrade version Apex 22.2 24.1 Ords 21.2 24.1 Java  Jdk-1.8 11.1 Pre checks and backups.      Apex Workspace backups.   Steps: Login to admin responsibility and take the workspace level backup. Using APEX port utility to take workspace and application backups in backend.   Tomcat and Ords backup Taking current tomcat and ords backup using tar.   Validate workspace schema backup should be taken in DBA team.   Installation of apex in DB level.…

Read More

RMAN Incremental Backups to Refresh Standby Database 

Description to standby: A standby database is a transactionally consistent replica of the primary database, designed to ensure continuity and data integrity in the event of disasters or data corruption. It allows the primary Oracle database to remain operational even during planned or unplanned outages. If the primary database becomes unavailable, Data Guard can seamlessly promote the standby database to the primary role, minimizing downtime. Additionally, the performance of the primary database can be optimized by redirecting resource-intensive tasks such as backups and reporting to the standby system. Therefore, keeping the standby database synchronized with the primary database is always advantageous. A standby database might lag behind the primary for various reasons like: Unavailability of or insufficient network bandwidth between primary and standby database Unavailability of Standby database Corruption / Accidental deletion of Archive Redo Data on primary CHECK THE SEQUENCE IN BOTH NODES: PRIMARY: SQL> select thread#, max(sequence#) “Last Primary Seq Generated” from v$archived_log val, v$database vdb where val.resetlogs_change# = vdb.resetlogs_change# group by thread# order by 1; THREAD#        Last Primary Seq Generated ———-                ————————– 1                                  556 STANDBY:…

Read More

Manual Data Guard Switchover in oracle 19c

Description: After configuring Data Guard, databases operate in either the primary or standby role, which can be switched dynamically without data loss or resetting redo logs. This process, known as a Switchover, can be executed using specific commands. Configuration Details: Environment detail Primary Standby SID SOURCE SOURCE DB Role Primary Physical standby Host prime.localdomain.com stand.localdomain.com DB Version 19.3.0.0 19.3.0.0 OS RHEL 7.9 RHEL 7.9 Step 1:- Check database role and database name Primary database:- SQL> select name,open_mode,database_role from v$database; NAME         OPEN_MODE           DATABASE_ROLE ——— ——————– —————- SOURCE         READ WRITE           PRIMARY Standby database:- SQL> select name,open_mode,database_role from v$database;…

Read More

Manual Data Guard Manual Failover 

Introduction to Failover:  Oracle Failover is a critical feature designed to ensure high availability and continuous operation of Oracle databases in the event of unexpected system failures. In enterprise environments…

Read More

Oracle patch prerequisite failed with PRVF-4083 & PRKN-1035 

ISSUE:  When I initiated the grid patch, it failed while executing the prerequisite with the following errors:  PRVF-4083: Node reachability check failed from node <NODE1>.  PRKN-1035: Host unreachable.”  Cause of…

Read More

BACKUP USING SQL SERVER AGENT 

In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL Server Agent method.   Firstly, log in to…

Read More

BACKUP USING MAINTENANCE PLAN 

 In this blog post, we will explore the process of scheduling and taking a backup of a SQL Server database using the SQL maintenance plan method.  Firstly, log in to…

Read More

Comprehensive Guide: Removing and Adding RAC Nodes in Oracle Clusterware

Overview  Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of deleting and adding RAC nodes within the Oracle environment. …

Read More

Troubleshooting and Resolving ‘CheckApplicable’ Prerequisite Error When Applying Oracle GI RU July-2023 Patch

Overview of blog  In this blog post, we will explore a comprehensive solution to resolve the issue of ‘oracle.rdbms.deconfig, 19.0.0.0.0’: Cannot delete file ‘/usr/local/oracle/19.3.0.0/suptools/tfa’ and the subsequent ‘CheckApplicable’ prerequisite failure.…

Read More