Oracle ADDM, AWR, ASH Reports
Using ADDM AWR ASH Reports. ADDM is diagnostic software built into Oracle Database. ADDM examines and analyzes data captured in Automatic Workload Repository (AWR) to… Read More »Oracle ADDM, AWR, ASH Reports
Using ADDM AWR ASH Reports. ADDM is diagnostic software built into Oracle Database. ADDM examines and analyzes data captured in Automatic Workload Repository (AWR) to… Read More »Oracle ADDM, AWR, ASH Reports
Cluster Health Advisor(ochad) in RAC Oracle Environment Oracle Cluster Health Advisor runs as on available cluster resource, ochad, on each node in the cluster.Each Oracle… Read More »Using Oracle RAC Cluster Health Advisor(ochad)
Oracle AWR, Snapshots and Baselines in Automatic Workload Repository. AWR collects, processes, and maintains performance statistics for problem detection and self-tuning purposes. This gathered data… Read More »Oracle AWR, Snapshots and Baselines
Managing Instances in Oracle RAC Starting One or More Instances and Oracle RAC Databases Using SRVCTL To start administrator-managed databases, enter a comma-delimited list of… Read More »Managing Instances in Oracle RAC
Oracle recommends Oracle Automatic Storage Management (Oracle ASM) as a Storage in Oracle RAC solution that provides an alternative to conventional volume managers, file systems,… Read More »Administering Storage in Oracle RAC
Overview of Monitoring and Tuning Oracle RAC Database Reliability Framework The Database Reliability Framework (DRF) is a proactive and automatic monitoring and correction framework. The… Read More »Monitoring and Tuning Oracle RAC Databases
Oracle RAC Log Files are used in diagnose problems for Oracle Real Application Clusters (Oracle RAC) components Oracle Database records information about important events that… Read More »Oracle RAC Log Files
Oracle recommends Using SCANs to connect Oracle RAC database The SCAN is a domain name registered to at least one and up to three IP… Read More »Oracle RAC Database Connections Using SCANs
CRSCTL Commands used to managed oracle clusterware resources and components. CRSCTL provides cluster-aware commands with which you can perform check, start, and stop operations on… Read More »CRSCTL Commands
SRVCTL is installed on each node in a cluster by default. To use SRVCTL, log in to the operating system of a node and enter… Read More »SRVCTL Commands
Useful Commands for Oracle RAC listed in this section manage the Oracle Clusterware resources Stop Oracle RAC: Perform these steps in the order listed to… Read More »Useful Commands for Oracle RAC
Oracle Cluster Registry (OCR) provides cluster configuration information. Collectively, voting files and OCR are referred to as Oracle Clusterware files. The main purpose for Oracle Cluster Registry (OCR)… Read More »Oracle Cluster Registry (OCR) in Oracle RAC