Skip to main content

Posts

Showing posts with the label RAC

Monitoring Oracle RAC Database and Cluster Performance.

Monitoring Oracle RAC Database and Cluster Performance. Both Oracle Enterprise Manager Database Control and Oracle Enterprise Manager Grid Control are cluster-aware and provide a central console to manage your cluster database.  From the Cluster Database Home page, you can do all of the following: View the overall system status, such as the number of nodes in the cluster and their current status. This high-level view capability means that you do not have to access each individual database instance for details if you just want to see inclusive, aggregated information. View alert messages aggregated across all the instances with lists for the source of each alert message. An alert message is an indicator that signifies that a particular metric condition has been encountered. A metric is a unit of measurement used to report the system's conditions. Review issues that are affecting the entire cluster and those that are affecting individual instances. Monitor cluster cache coherency sta...

What is the use of public, private, VIP in RAC

What is the use of public, private, VIP in RAC? Public IP: The public IP address is for the server.  This is the same as any server IP address, a unique address with exists in /etc/hosts. Private IP: Used for the cluster interconnect. Oracle RAC requires "private IP" addresses to manage the CRS&the cluster ware heartbeat process and the cache fusion layer. Virtual IP (VIP): This IP is required for fail over in case of Node is down. This willsfailoversession to the surviving node. Instead of host ips will have VIP in the listener.ora