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.

Real Application Cluster Acronyms GCS Global Cache Services in memory database containing current locks and awaiting locks, also known as PCM GES Global Enqueue Services coordinates the requests of all …