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

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

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

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

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

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

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

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

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

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