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 MoreBACKUP 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 MoreComprehensive 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 MoreTroubleshooting 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 MoreOEM 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 MoreOEM 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 MoreBLOCK 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 MoreHOW 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 MoreORACLE 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 MoreHOW 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