19C

Automate oracle client installation using ansible

We can use the power of ansible to automate the oracle client installation task on multiple servers.In this article, we will explain how we will achieve this by executing an ansible playbook from ansi...

How to delete a node from oracle RAC 19C

This tutorial explains how to delete a node from a multi node grid infrastructure setup. Current GRID NODES  -> DBHOST3( node 1) , DBHOST4 ( node 2) Node to be deleted -> DBHOST4 Grid version -...

How to add a node in oracle RAC 19c

Below are the steps for adding  a node in  oracle 19c RAC. STEP OVERVIEW: Add the new node  using gridSetup.sh Extend oracle database home to new node using addnode.sh Add the database instance  t...

How to clone oracle home in oracle 19c using gold image

In this article, we will explain , how to clone 19c oracle home binary (including patches) , from one server to another server using gold image method. Prior to oracle 19c, cloning was done using runI...

How to Downgrade oracle 19C Grid to 12C GRID

In the pervious article we have explained the STEPS FOR GRID UGPRADE FROM 12C TO 19C. Now We will explain the steps for downgrade oracle 19c 2 node GRID to oracle 12.1.0.2 GRID. ENVIRONMENT DETAILS: 2...

Clone a database using dbca command in oracle 19c -New feature

In oracle 19c, there is a new feature of duplicate/cloning an oracle database using dbca with simple and one line command. With this command, we need need to setup listener or pfile manually. All will...