Recover standby database from primary using service in oracle 18c

If your standby database is out of sync from primary or some archive logs got deleted before it is being shipped or applied to standby ,then you can follow below method to sync standby database with primary. We can call this process as  rolling forward of standby database. In oracle 11g, this process is purely […]

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 ansible control node.   Ansible control node  is any machine where ansible tool is installed.    IMPORTANT POINTS: oracle 19c client will […]

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 Extend oracle database home to new node using 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/ 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 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 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 […]