From 12c onwards, MGMTDB which is known as GRID INFRASTRUCTURE MANAGEMENT REPOSITORY( GIMR) , stores diagnostic and performance related data for GRID infrastructure. This MGMTDB is created as part of oracle grid installation. However there might be some instances where mgmtdb gets corrupted or requirement is to move the database to another diskgroup, then solution […]

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 file (that comes with patch), mention the recommended opatch version. If your existing opatch version is lower than the recommended version then, Opatch need […]

From oracle 12c onward Bundle patches/PSU patch can be applied to oracle GRID or database home using opatchauto utility which simplifies the patching process.   NOTE – >  WHAT IS PROACTIVE BUNDLE PATCH  ->  APPLY BUNDLE PATCH  TO GRID USING OPATCHAUTO   However recently i faced an issue where due to opatch utility issue, we are […]

AWR report can be generating in RAC database using 2 scripts awrrpt.sql or awrrpti.sql awrrpt.sql – > This will generate the one report for the database across all the nodes(i.e for all instances) for a partiular snapshot range. awrrpti.sql – > This will genereate report for a particular instance, i.e for a 2 node RAC […]

If you are planning to change the hostname and ipaddress of the standalone grid infrastructure ( oracle restart), then we need to do below deconfig and reconfig on the grid setup. 1. Stop the has $GRID_HOME/bin/crsctl stop has 2 . Run the deconfig tool ( from root user ) export GRID_HOME=/gridapp/app/oracle/product/12.1.0.2/grid $GRID_HOME/crs/install/roothas.pl -deconfig -force [root@dbhost-prod […]

Below are the steps to deinstall or cleanup oracle standalone grid infrastructure setup. 1. Login with grid owner and ( i.e oracle or grid). export GRID_HOME=/oracle/app/oracle/product/12.1.0.2/grid cd $GRID_HOME/deinstall 2. Run deinstall tool cd $GRID_HOME/deinstall ./deinstall cd $GRID_HOME/deinstall ./deinstall $ ./deinstall Checking for required files and bootstrapping … Please wait … Location of logs /tmp/deinstall2019-10-02_10-53-45AM/logs/ ############ […]

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

The latest oracle version is oracle 19C . In the below article we will explain the steps for upgrading grid infrastructure to 19c from oracle 12c  . The upgrade will be done in rolling mode. Current configuration – > No of nodes – 2 node current version – 12.1.0.2 os platform – Solaris grid owner […]

Below are the steps for flashback a database to restore point in a RAC database. 1. Check the restore point details. SELECT NAME FROM V$RESTORE_POINT; NAME ———— STAGE_CR178 2. Check the status of the database. srvctl status database -d DBPRE Instance DBPRE1 is running on node dbats-2 Instance DBPRE2 is running on node dbats-2 SQL> […]

Below are the steps for moving spfile from file system to ASM diskgroup in RAC. database name – ORCL instance_names – ORCL1,ORCL2 oracle DB nodes – dbhstorcl1, dbhstorcl2 1. Check current pfile location: SQL> show parameter pfile NAME TYPE VALUE ———————————— ———– —————————— spfile string /oracle/app/oracle/product/dbs/temp_init.ora 2. Now required directory in ASM diskgroup(where pfile will […]