RAC

How to create asm disk using asm filter driver(AFD)

If you are working on RHEL, then to use the disk in ASM diskgroup, the disks need to be labeled with ASM. Earlier oracleasm utility was used for this purpose. But oracle developed its own ASM filter d...

Real DBA interview questions -3

These below oracle DBA questions has been shared by a candidates who appeared for a interview in MNC. Candidate has 10 years of experience . ROUND 1: ( Technical Round) Background processes in oracle ...

Real Interview questions for experienced DBAs – 1

Overview: Below are the questions asked to a candidate with 10 years of experience in Oracle DBA and postgres . There were 2 rounds.   Round 1 :  What are your day to day activities. And what is...

How to change asm spfile location in oracle RAC

Recently we found that, one of our asm instance was using a different spfile. So used below steps to change the spfile. existing spfile – > /u01/app/grid/dbs/asmbackup.ora new spfile      ...

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 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 g...

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 apply JDK patch in oracle database

Recently we got a notification from security Team, that the java versions inside the ORACLE_HOME were outdated, and those need to be updated to the latest one. So We checked in  oracle support portal...

How to change private interconnect details in oracle grid

Below are the steps for changing private interconnect details in oracle GRID/RAC  12c. In our case we will change the private interface name from eth7 to eth8(after confirmation from network team). 1...

How to setup password less ssh connectivity using sshUserSetup.sh

Before starting RAC setup between two nodes, we need to have password less ssh connectivity between the nodes. There is a manual process to enable ssh connectivity . However oracle is providing a simp...