Patch Information: – Patch 30087906 – Database Release Update Revision 19.3.2.0.191015   Step: -1 Environment Details   export ORACLE_HOME=/u01/app/19c/grid export [...]

Overview  Diving into the intricacies of Oracle Clusterware management, this comprehensive guide elucidates the meticulous steps involved in the process of deleting and adding RAC nodes within [...]

SERVER CONTROL UTILITY (SRVCTL) Server Control Utility (SRVCTL): It is used to administer Oracle Real Application Clusters (Oracle RAC) databases and instances. Use SRVCTL to manage Oracle [...]

STOP & START CRS: ( run from root user) $GRID_HOME/bin/crsctl stop crs $GRID_HOME/bin/crsctl start crs Enable/Disable auto restart of CRS. $GRID_HOME/bin/crsctl disable crs [...]

SQL> Startup upgrade ORACLE instance started. Total System Global Area 1.3262E+11 bytes Fixed Size                  2304584 bytes Variable Size            2.2481E+10 bytes Database Buffers     [...]

Posted by : Pushparaj   This Post describes about converting into RAC instance Add separate Undo Tablespaces First, Create 2 UNDO tablespaces for the 2 instances.PLINKTST1 > create undo [...]

Parameters that must have identical in RAC database: In a RAC database there may contain several instances and the initialization parameters of all of the instances should not have identical [...]

Issue: The issue is in racprd database while connecting to service name racprdha1  is  showing ORACLE initialization or shutdown in progress. Workaround: The problem is with the [...]

CSS ADMINISTRATION: crsctl get css diagwait  The time limit is to update the respective output logfiles for every process. crsctl get css disktimeout  Disk Latencies in seconds [...]

In 3 node  RAC setup,In initial stage–node 3 is the master node. [oracle@host01 ~]$ cat $ORACLE_HOME/log/host01/cssd/ocssd.log |grep ‘master node’ |tail -1 2016-09-24 [...]