Oracle

May 5 2020

Configure a SSH Tunnel using Putty to connect to a AWS EC2 instance.

In this post I will show you how configure a SSH Tunnel using Putty to connect to a AWS EC2 Instance with CentOS release 6.9 running Oracle 12c I will configure a SSH Tunnel to connect to a Oracle 12c database located in a EC2 instance that uses the default port 1521, If you wish you can configure other port like 5432 (default port for PostgreSQL) or 3306 (default port for MySQL) Steps to configure SSH Tunnel 1. Get the Read More

By • Amazon Web Services (AWS), Cloud, Database Security, Databases, Oracle • 0

May 2 2020

Migrate on-premises Oracle 12c running in Windows to AWS EC2 Linux using Oracle Data Guard and SSH tunel

In this post I will walk you trough the steps to migrate a database Oracle 12.1.0.2.0 running in Windows 7 to AWS EC2 running Linux CentOS release 6.9 using Oracle Data Guard 12c The below diagram shows a Dataguard architecture of replication sending the redo streams trough a SSH Tunnel from the Primary Database (source db) to the Standby Database (target db) in AWS EC2. Current Environment SOURCE TARGET Operating System Microsoft Windows 7 Enterprise Edition 64 bits CentOS release Read More

By • Amazon Web Services (AWS), Cloud, Data Guard, Databases, Migration, Oracle, Replication • 0

Apr 23 2020

Replication between SQL Server 2012 CDC and Oracle 12c using GoldenGate 19c

In this post I will walk you trough the steps to configure Oracle GoldeGate 19 to replicate transactions between Microsoft SQL Server 2012 using CDC Capture replication and Oracle 12c. We are going to build a simple unidirectional replication of the table ORG.DEPT between two heterogeneous databases. The below diagram shows the GoldenGate architecture of a replication unidirectional from SQL Server database to Oracle database. Operating System Database Database Name GoldenGate version Oracle GoldenGateHome GoldenGate installer IP Database Server Manager Read More

By • Databases, Golden Gate, Oracle, Replication, SQL Server • 0

Apr 18 2020

Install Oracle Goldengate 19c for Oracle Linux.

In this post I will install GoldenGate 19c for Oracle 12c in Linux 7.1, this will be the start point for the next post that replicate data from SQL Server 2012 to Oracle 12c. I going to install Oracle GoldenGate in the below environment: Operating System: Oracle Linux Server 7.1 Database: Oracle 12c (12.1.0.2.0) GoldenGate version: 19.1.0.0.4 GoldenGate installer: 191004_fbo_ggs_Linux_x64_shiphome.zip 1. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 191004_fbo_ggs_Linux_x64_shiphome.zip from Oracle website. 2. Transfer the zip 91004_fbo_ggs_Linux_x64_shiphome.zip to a Read More

By • Databases, Oracle, Replication • 0

Mar 17 2020

Migrate an on-premises Oracle database to Oracle on Amazon EC2 using AWS DMS

There are many ways to migrate on premises Oracle database to Elastic Compute Cloud (EC2). In this post I will show how to use AWS Database Migration Service to migrate on-premises Oracle Database 12.1.0 running in Windows to AWS EC2 running in Linux. I installed locally Oracle 12c software in Windows environment and created manually a new Oracle database 12.1.0 (SID SRCDB) then installed the Sample Schemas/Users that populate data in the new schemas: IX , SH , OE , Read More

By • Amazon Web Services (AWS), AWS Database Migration Services, Cloud, Databases, Migration, Oracle • 0