Basic RAC Management Commands   Cluster Related Commands crs_stat -t Shows HA resource status (hard to read) crsstat Ouptut of crs_stat -t formatted nicely ps -ef|grep d.bin crsd.bin evmd.bin ocssd.bin …

CRS Administration   CRS Administration starting ## Starting CRS using Oracle 10g R1 not possible ## Starting CRS using Oracle 10g R2 $ORA_CRS_HOME/bin/crsctl start crs stopping ## Stopping CRS using …

How To Add Redo Logfiles In Standby Database   Step 1. First, Check MEMBER present in Standby Database. SQL> select member from v$logfile; MEMBER ———————————- E:\STANDBYLOGS\REDO03.LOG E:\STANDBYLOGS\REDO02.LOG E:\STANDBYLOGS\REDO01.LOG   Step 2. …

ERROR Error stack: AutoConfig completed with errors. The log file for this session is located at: /u01/apps/inst/apps/TEST_apps/admin/log/03451250/adconfig.log

RAC General Administration   Managing the Cluster starting /etc/init.d/init.crs start crsctl start crs stopping /etc/init.d/init.crs stop crsctl stop crs enable/disable at boot time /etc/init.d/init.crs enable /etc/init.d/init.crs disable crsctl enable crs …

Oracle RAC Daemons and Processes   OPROCd Process Monitor provides basic cluster integrity services EVMd Event Management spawns a child process event logger and generates callouts OCSSd Cluster Synchronization Services …

SQL Queries to Check ACTIVE / INACTIVE Sessions

ERROR Error stack while running autoconfig: Updating Context file…COMPLETED

RAC Useful Parameters cluster_interconnects specify a specific IP address to use for the inetrconnect _gcs_fast_config enables fast reconfiguration for gcs locks (true|false) _lm_master_weight controls which instance will hold or (re)master …