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 […]

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 […]

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 […]

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 […]

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 […]

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, […]

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 […]

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 […]

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 […]

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 […]