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...
RAC
Steps for changing public hostname for a standalone grid infrastructure
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 $GRI...
How to deinstall/cleanup standalone grid infrastructure
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 c...
How to Downgrade oracle 19C Grid to 12C GRID
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...
How to flashback a RAC database
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...
How to move spfile from file system to ASM in RAC
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 cu...
How to change spfile in Oracle RAC.
If we are changing spfile in oracle RAC, then we need to use additional SID parameter in the alter system command. Here SID is the instance_name. For changing the parameter in both the instances of th...
Oracle local registry(OLR) in RAC
ORACLE LOCAL REGISTRY(OLR) contains node-specific information required by OHASD . Every node has its own dedicated OLR file.(not shared between the nodes). As OCRs files are present in ASM diskgroup, ...
OLSNODES COMMANDS IN RAC
OLSNODES provides information related RAC nodes. 1. List of nodes in the cluster olsnodes prod54-1 prod55-1 2.Nodes with node number olsnodes -n prod54-1 1 prod55-1 2 3.Node with vip olsnodes -i prod5...
How to create ACFS file system in RAC using command line:
ACFS i.e Oracle ASM Cluster File System is cluster file system service used for High availability services. Example – For achieving high availability in goldenate for Oracle RAC, we can use ACFS...