Oracle Grid Infrastructure Service The Oracle Grid Infrastructure for a standalone server is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. If you plan to use Oracle Restart or Oracle Automatic Storage Management… Read More
Introduction to Oracle RAC Environment What is Cluster ? A cluster in computer science is a set of computing nodes that work together and can be loosely viewed as a single system. In other words A cluster consists of multiple interconnected servers that appear to end users… Read More
VD and OCR migration online: 1) Check existing setup by running below commands : +ASM1@cloud-server-1:/opt/oracle> crsctl query css votedisk 2) Check the OCR/VD backup : 3) Ask SA to take new backup using below command as ROOT: 4) Check… Read More
col name for a20 trunc col value for a40 trunc set pagesize 140 select name,value,inst_id from gv$parameter where inst_id in (1,2) order by 1,3; Herewith the sample output for a 2 Node RAC. You can see the different value for two nodes highlighted in RED.