ORACLE 19C

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 -> 19c STEPS OVERVIEW: Precheck Delete the instance from DBHOST4  using dbca Deinstall the oracle database home from DBHOST4 Deinstall […]

How to deinstall oracle 19c grid infrastructure

In this article , we will explain the steps required for deinstalling 2 node grid infrastructure. STEPS OVERVIEW: Deinstall oracle database homes if any Deinstall grid infrastructure Manually delete grid_home and oracle_home if anything is reported at 2nd stage. NOTE – > This deinstall process, will drop the database. So if your data is critical […]

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  to new node using dbca DEMO In this demo, we will add new node dbhost04, to existing node dbhost03( where grid is […]

How to change cluster name in oracle RAC

NOTE – You can follow this method for deinstall and reinstall of  grid infrastructure without losing your database data(asm disk data)   Changing the cluster_name in ORACLE RAC means grid infrastructure need to be reconfigured( which is a complex activity). You will need downtime to do this activity and you will lose your cluster services, […]

How to create database using dbca in silent mode – 19C

From oracle 19c onward, we can create a database using dbca in silent mode with help of response file. default response file location: export ORACLE_HOME=/oracle/app/oracle/product/19.9.0.0/dbhome_1 cd $ORACLE_HOME/assistants/dbca By using the default response files, you can create a new response file, as per your requirement. Below is the response file i have created. cat /export/home/oracle/db_create.rsp responseFileVersion=/oracle/assistants/rspfmt_dbca_response_schema_v12.2.0 […]

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 runInstaller – clone command or clone.pl script .But in oracle 19c, these methods has been deprecated.  Refer below link SEE […]

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 NODES – dbhost1 and dbhost2 Grid owner – oracle 19C ORACLE_HOME(current) – > /sharearea/crs/grid19c 12C ORACLE_HOME (old) -> /crs/app/oracle/product/grid12c […]

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 be taken care by the the dbca duplicate command. In the below example, we will clone the primary database ILTST19C […]

Steps for upgrading oracle database to 19c using DBUA

Database upgrade can be performed either using manual or DBUA. Below are the steps for upgrading oracle database from oracle 12c to 19c version using DBUA. Important points: Direct upgrade to 19  can be performed from 11.2.0.4,12.1.0.2,12.2.0.1 & 18c . Compatible parameter should be at minimum 11.2.0 Post upgrade , oracle default accounts ( whose […]

Upgrade grid infrastructure to 19C oracle

The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c  . The upgrade will be done in rolling mode. Current configuration – > No of nodes – 2 node current version – 12.1.0.2 os platform – Solaris grid owner […]