Posts by Shankar Narayanan

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

OEM Upgrade from 13.4 to 13.5

OEM UPGRADE FROM 13.4 TO 13.5   PRE-REQUISITE: First, we need to take a backup of the Middleware Home, the Management Repository, Central inventory, Software library, Management Agent. The minimum…

Read More

OEM 13.4 Step by Step Installation

OEM 13.4 INSTALLATION AND CONFIGURATION   OEM OVERVIEW: Oracle Enterprise Manager is management tool, which is used to integrated solution for managing your heterogeneous environment. It Includes, Graphical console, Agents,…

Read More

BLOCK CHANGE TRACKING

BLOCK CHANGE TRACKING Block changing tracking improves the performance of incremental backups by recording changed blocks in the block change tracking file. During an incremental backup, instead of scanning all…

Read More

HOW TO RESOLVE ORA-04031: UNABLE TO ALLOCATE 11513896 BYTES OF SHARED MEMORY (“LARGE POOL”,”LARGE POOL”,”CTWR DBA BUFFER”)

Step1: We want to ensure the block change tracking is enabled in our database or not by using the below sql statement. i.e, SQL> select filename,status from v$block_change_tracking; FILENAME ——————————————————————————–…

Read More

ORACLE GOLDEN GATE ERROR OGG-00868

In this tutorial, we are going to learn about, “How to resolve this ERROR OGG-00868″ I got the below type of error while re-start the replicat in golden gate. I…

Read More

HOW TO RESOLVE THE ORA-01092: ORACLE instance terminated. Disconnection forced ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option

In this tutorial, we are going to learn about, “How to resolve these ORA ERRORS: ORA-01092, ORA-00704 and ORA-39700”. I got the below type of error while startup the database.…

Read More

ORACLE OS WATCHER

ORACLE OS WATCHER   What is oracle OS watcher? Oracle OS watcher is collects and stores as archives operating system and network metrics that you can use to diagnose performance…

Read More

ORACLE TRACE FILE ANALYZER UPGRADE TO 21.1.2

TRACE FILE ANALYZER UPGRADE TO 21.1.2 Oracle Trace file Analyzer provides a number of diagnostic tools in single bundle, making it easy to gather diagnostic information about oracle database and…

Read More