Dear Readers, In this article, we will see the step by step Configuration of Oracle DGMGRL Utility. let’s start the step by step Oracle DGMGRL Utility configuration. Step 1 :First we should check the DB name, DB unique name, open_mode, database_role of both the servers Primary… Read More
Dear Readers, In this article, you will get to know the Oracle Physical Standby Dataguard step by step configuration in 11g. Required Parameters to configure the Oracle Physical Standby Dataguard setup:- DB_NAME= It should be the same on the primary and standby side. DB_UNIQUE_NAME= Must be different on the primary… Read More
Dear Readers, In this article we will get to know how we can perform step by step Switchover and Switchback configuration in Oracle 11g. Switchover: – A switchover is a technique through which the roles reversal is possible between the primary database and standby database. At the time… Read More
Python Scripting for Oracle databases. Dear Readers, Please check below YouTube video links for establishing python scripts for Oracle databases. Link 1 : How to launch EC2 instance with RHEL 7.5 AMI Link 2: installation of Oracle 12cR1 Database software on AWS EC2 instance Link… Read More
Dear Readers, In this article, we will see Installation of Virtual Box Guest additions on Oracle Enterprise Linux 8.1 Today we will understand the step by step Installation of Virtual Box Guest additions on Oracle Enterprise Linux 8.1. To complete this configuration we need to… Read More
Dear Readers. In this article ,we will see MySQL Migration from SUSE (M & S) to RHEL (M & S) through Cascading Slaves. Environment : Mysql version : 5.7.13-enterprise-commercial awsserver1: Suse Master awsserver2: Suse Slave Replication exists between awsserver1 and awsserver2, and is the current… Read More
Dear Readers, In this article, we will understand the Oracle to SQL Server Migration Issues which I have faced during the migrationactivity. We will look at the resolution of the below issues one by one. Issue 1)A network-related or instance-specific error occurred while establishing a… Read More
Dear Readers, Today we will see the step by step installation of Oracle Enterprise Linux 8.1 Installation. To complete this configuration we need to follow below steps. Download the Oracle Virtual Box software. Download the Oracle Enterprise Linux 8.1 ISO image. Installation of Virtual Machine… Read More
Dear Readers, How all of you are doing well & safe. Today I was reading some documents referring new DB enhancements in Oracle 18C & found we can do Oracle’s AUDIT table exports using datapump. I remember some of links in Oracle MOS/Docs mentioning, EXPDP… Read More
SQL SERVER Articles Dear Readers, Please check below articles to get good knowledge on SQL SERVER. SNO DESCRIPTION ARTICLE LINK 1 SQL Server – Issue to view Alwayson Health Events https://www.ktexperts.com/sql-server-issue-to-view-alwayson-health-events/ 2 Script to copy one particular database role from one SQL server to another… Read More
