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 …

Concurrent Request Queries   HISTORY OF CONCURRENT REQUEST  (PROGRAM WISE)   SELECT DISTINCT t.user_concurrent_program_name, r.request_id, To_char(r.actual_start_date, ‘dd-mm-yy hh24:mi:ss’) “Started at”, To_char(r.actual_completion_date, ‘dd-mm-yy hh24:mi:ss’) “Completed at”, Decode(r.phase_code, ‘C’, ‘Completed’, ‘I’, ‘Inactive’, ‘P ‘, ‘Pending’, ‘R’, ‘Running’, ‘NA’) phasecode, Decode(r.status_code, ‘A’, ‘Waiting’, ‘B’, ‘Resuming’, ‘C’, ‘Normal’, ‘D’, ‘Cancelled’, ‘E’, ‘Error’, ‘F’, ‘Scheduled’, ‘G’, ‘Warning’, ‘H’, ‘On Hold’, ‘I’, ‘Normal’, ‘M’, ‘No Manager’, …

Oracle Forms Session Queries

RAC Useful Views And Tables GCS and Cache Fusion Diagnostics v$cache contains information about every cached block in the buffer cache v$cache_transfer contains information from the block headers in SGA …

RAC Files and Directories   $ORA_CRS_HOME/cdata/<cluster_name> OCR backups (default location) $ORA_HOME/log/<hostname>/client/ocrconfig_<pid>.log OCR command log file $ORA_CRS_HOME/crs/log contains trace files for the CRS resources $ORA_CRS_HOME/crs/init contains trace files for the CRS …

ERROR APP-FND-01542 : This Application Server is not authorized to access this system. Please contact your system administrator.