DBA_JAF

About DBA_JAF

http://www.tcien.com

Juan A. Ferrer is a Senior and Certified Oracle Professional with more than 20 years of experience in databases technologies. As former employee of Oracle Corporation and Senior Consultant has participated in the implementation of technology of databases in different industries like Insurance, Banking, Pharmaceutical, Telecommunication, Oil & Gas, Manufacturing, Travel, Transportation, Education and Television.

Posts by Juan A Ferrer:

May 9 2020

Importing data from a CVS file to a Amazon RDS PostgreSQL 12.2 using a SSH tunnel created in Python

In this post I will show you a simple python program that import a CVS file from a remote PC into a table of Amazon RDS PostgreSQL using a a SSH tunnel created by the same Python program. I going to use an Amazon RDS PostgreSQL without a Public IP, for this reason I will use an Amazon EC2 instance as bastion host (Jump server). Both Amazon RDS PostgreSQL and EC2 Instance use the same VPC (172.31.0.0/16) and the EC2 Read More

By • Amazon RDS, Amazon Web Services (AWS), Cloud, PostgreSQL, Programming Languages, Python • 0

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 21 2020

Install Oracle GoldenGate 12c for PostgresSQL 12.2 in AWS EC2 RHEL 8

In this post I will install GoldenGate 12c for PostgreSQL 12.2 in AWS EC2 in Red Hat Linux 8. I going to install Oracle GoldenGate 12c with the below specifications: Operating System: Red Hat Enterprise Linux release 8.0 (Ootpa) Database: Postgress 12.2 GoldenGate version: 12.2.0.2.2 GoldeGate installer: 122022_ggs_Linux_x64_PostgreSQL_64bit.zip 1. Create the GoldenGate Home directory and setup the environment variable ($GGH) 2. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 122022_ggs_Linux_x64_PostgreSQL_64bit.zip from Oracle website. 3. Transfer the zip file 122022_ggs_Linux_x64_PostgreSQL_64bit.zip to Read More

By • Amazon Web Services (AWS), Cloud, Databases, PostgreSQL, Replication • 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

Apr 16 2020

Install SQL Server 2012 Service Pack 4

In this post I will show install SQL Server 2012 Service Pack 4. 1.Check the current version of SQL Server 2012, the below query returned the value RTM (release to manufacturing ) means that is the first release of SQL 2012 without applying any Service Pack. 2. Download the Service Pack 4 SQLServer2012SP4-KB4018073-x64-ENU.exe from Microsoft Download Center 3. Run the installer of SP 4 SQLServer2012SP4-KB4018073-x64-ENU.exe (Run as Administrator) a. Check the Installer pass all validations. Click on “Show details” button Read More

By • Databases, Patches, SQL Server, Upgrade • 0

Apr 15 2020

Install Oracle Goldengate 19c for Microsoft SQL Server.

In this post I will guide you trough the steps to install and configure Goldengate 19c for Microsoft SQL Server 2012, 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: Windows 7 Professional Database: SQL Server 2012 Enterprise Edition GoldenGate version: 19.1.0.0.3 GoldenGate installer: 191003_ggs_Windows_x64_MSSQL_64bit_CDC.zip. 1. Prerequiste According to Oracle documentation using the Microsoft SQL Server Native Read More

By • Databases, Replication, SQL Server • 0

Mar 28 2020

Install pgAdmin 4.19 and setup a SSH tunnel to access to AWS EC2 PostgreSQL database.

In this post will show you how install pgAdmin 4.19 for Windows and how configure postgreSQL 12.2 to be accessed by pgAdmin ussing SSH. If you do not have a AWS EC2 instance you can go to my post: Launch and setup a free tier AWS EC2 instance with Red Hat Enterprise Linux 8. If you did not install PostgresSQL Server yet you can go to my post: Install PostgreSQL Server 12.2 on RHEL 8 1. Go to PostgreSQL home Read More

By • Amazon Web Services (AWS), Cloud, Databases, PostgreSQL, Tools • 0

Mar 27 2020

Install PostgreSQL Server 12.2 on RHEL 8

In this post we are going to install PostgreSQL Server version 12.2 on Red Hat Enterprise Linux 8, this PostgreSQL server will be used for the next posts about migration of data between different databases. 1. We are going to check if a previous version of PostgreSQL Server was installed in the Linux Server. 2. Because PostgreSQL version 10.6 was installed previously we are going to remove it from the server. 3. Install the repository RPM . 4. Disable the Read More

By • Databases, PostgreSQL • 0

1 2