How to Upgrade Oracle 12c to 19c on a Window Failover Cluster Manager environment

On this post we are going to upgrade Oracle 12c to 19c on an ACTIVE/PASSIVE setup on Windows Failover Cluster Manager: Server Name DBNAME 12c Oracle Home 19c Oracle Home win-rac1 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 win-rac2 DBPROD C:\oracle\app\product\12.1.0\dbhome_1 C:\oracle\app\product\19c\dbhome_1 This is the current patch level of both 12c and 19c homes (on both nodes!): Its worth... » read more

0
Read
Alex
Windows: How to Install Oracle 19c Database Software

These are the steps to install Oracle 19c Software. We are going to create ORACLE_HOME=C:\app\ORACLE\product\19c\dbhome_1 STEPS: 1:- Download software from here 2:- Unzip downloaded file on path C:\app\ORACLE\product\19c\dbhome_1 3:- Execute setup.exe from C:\oracle\app\product\19c\dbhome_1 4:- Follow GUI: That’s it, Oracle 19c Software installed

1
Read
Alex
How to AUTOUPGRADE from 12.1.0.2 to 19c

This post will go though the all the steps needed to upgrade a 12.1.0.2 database to a 19c using AUTOUPGRADE. Source DB: 1:- Create 19c directory and copy software: 2:- Create response file for a silent 19c Instalation: 3:- Execute 19c pre-requisites: 4:- Install 19c software in silent mode: 5:- Execute root.sh (as root): 6:-... » read more

0
Read
Alex
How to Upgrade Oracle Grid from 12c to 19c

This post will go though the steps needed to upgrade an Oracle Grid High Availability Services (HAS) from version 12c (12.1.0.2) to 19c (19.13.0) on a Linux environment. 1:- As per document Doc ID 2539751.1, Patch 28553832 is a prerequisite for both GI and DB Upgrade. Here the steps to apply Oct 2021 PSU which... » read more

1
Read
Alex
Oracle 19c: How Oracle Enable TDE on RAC DB

Setting up TDE (Transparent Data Encryption) in 19c is very easy and these are the steps needed. 1:- Create a backup of spfile/initfile (it is always a good practice to create a backup before any change on the DB): 2:- Create WALLET directory in both nodes: 3:- Update sqlnet.ora with wallet location (in all nodes):... » read more

0
Read
Alex
Oracle GoldenGate 19c: How to configure EXTRACT / REPLICAT

In this activity we are going to assume we have GoldenGate software already installed, if not, you can follow these steps here: Oracle GoldenGate 19c: How to install We are are going to replicate schema HR from/to these server: SOURCE (PDB): TARGET (NON CDB): hostname: racnode1 hostname: standbyracnode IP: 192.168.24.1 IP: 192.168.24.3 RDBMS: 19c RDBMS:... » read more

5
Read
Alex
Oracle GoldenGate 19c: How to install

This is going to be a guide for how to install GoldenGate on your source/target servers, just the installation of the software. For the configuration and setting up and running, please check this: Oracle GoldenGate 19c: How to configure Integrated EXTRACT/REPLICAT First of all make sure you have the GoldenGate version that matches your DB.... » read more

0
Read
Alex