Posts by Nishanth S

Golden Gate – Source and target server configuration(Extract, dump and replicate)

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 step-by-step process for configuring…

Read More

SQL Server database restore from one server to another server

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 continuity,…

Read More

LOG SHRINK IN THE SQL SERVER

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 scenario is when…

Read More

AWS EC2 Instance Setup and SSH Connection Guide

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…

Read More

How to install Mongodb on linux Mongodb version 3.4

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…

Read More

Installing MySQL on linux

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- https://dev.mysql.com/doc/refman/8.1/en/ Downloading…

Read More

STEPS TO INSTALL SQLSERVER IN WINDOWS 10

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…

Read More

METABASE INSTALLING IN ORACLE DATABASE

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…

Read More

Solution to not logged on error and up the database

              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:…

Read More

SWITCH OVER IN DATAGUARD

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…

Read More