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

PROBLEM:   While  analyzing/applying patch to both grid and db at a same time using opatchauto command , got below error. root@dbaclass01:/export/home/oracle# /gridapp/app/oracle/product/grid12c...

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

  PROBLEM:   While running opatch lsinventory , got below error LsInventorySession failed: RawInventory gets null OracleHomeInfo: oracle@dbhost1:…p/app/oraInventory/ContentsXML$ $ORACL...

In this article I will explain how to install/upgrade OPatch utility in grid_home and oracle_home in a RAC infrastructure. Opatch utility is used while applying patches to the database. Every readme f...

                 To apply psu patch on  physical standby database setup, 1st patch need to be applied on standby, and then on primary. Below are the steps.  Download patch from oracle suppo...