Introduction Oracle GoldenGate is a robust and flexible data replication and integration tool widely used for real-time data replication across heterogeneous systems. This document outlines the [...]

SQL Server database restore from one server to another server Introduction Restoring a SQL Server database from one server to another is a common administrative task that ensures business [...]

Introduction In SQL Server, effective management of disk space is crucial to maintaining optimal database performance and preventing issues caused by excessive log file growth. One common [...]

Introduction Launching the AWS ec2 instance from scratch step by step procedure. Step 1: AWS Console Login Access the AWS console by navigating to: AWS Console Login. Log in to your AWS account. [...]

Mongodb on linux Mongodb version 3.4   Step -1 -Create a directory to keep the software – Give full permission to the directory for Execute Step -2 -Download software mongodb 3.4 v [...]

Installing  MySQL on linux STEP -1 -Download the rpm required based on your operating system here iam using linux -User the below link to assess the RPM -Link- [...]

STEP – 1 1 First download .netframework 3.5   Completed. Now the .net framework 3.5 has been installed in the windows system STEP-2 -Download software for the sqlserver -User the [...]

METABASE INSTALLING IN ORACLE DATABASE   Requirements – Metabase requires a Java Runtime Environment (JRE), with a Java version of 11 or higher. – Check you have a java version [...]

              Solution to  not logged on error and up the database ORA-01012: not logged on error   ERROR ERROR at line 1: ORA-01012: not logged on Process ID: 0 Session ID: 0 Serial number: 0 [...]

SWITCH OVER IN DATAGUARD   CHECK THE FOLLOWING IN PRIMARY AND STANDBY STEP-1 STANDBY -Keep the database in mount state -keep the standby in MRP mode     STEP-2 FIND THE SYNC GAP ON [...]