Apr 12, 2013
Oracle RAC Background Processes in 11g
1.6K

Oracle RAC Background Processes in 11g

Oracle RAC Background Processes in 11g Oracle RAC 11g has come up with some good new background processes. Which we will discuss in this session ABMR – auto block media recovery background process – Filters duplicate BMR requests and performs flood control. When a request of block media recovery comes...
Mar 28, 2013
Server side load balancing in Oracle RAC 11g
1.6K

Server side load balancing in Oracle RAC 11g

How server side load balancing will happen in Oracle RAC 11g??  Based on the load information fed by PMON, listener will decide on to which instance the incoming connections to be directed (Or how to distribute oncoming connections among instances) Usually LOCAL_LISTENER parameter should be set to name of the listener...
Jan 19, 2013
VM Crashes Frequenty in VMware Server 2.0.2 while installing 11gR2 RAC
506

VM Crashes Frequenty in VMware Server 2.0.2 while installing 11gR2 RAC

VM CRASHES FREQUENTY IN VMWARE SERVER 2.0.2 WHILE INSTALLING 11gR2 RAC I am using VMware server 2.0.2 for setting up my Oracle 11g RAC Environment and my VM’s crashed abruptly with errors. This happens even though when there is no load on the VM’s. In one case it happened during...
Jan 10, 2013
Oracle ASM SQL scripts
794

Oracle ASM SQL scripts

Oracle ASM SQL scripts The following scripts are outlined to assist the use in managing ASM files; i.e., listing or deleting. Note:  Oracle recommends using 10g EM Grid Control or Database Control for performing these functions. 1. This SQL statement generates a script to list the ASM files for a given...
Jan 10, 2013
Adding a new node in Oracle RAC 11gR2 using Virtual Box
658

Adding a new node in Oracle RAC 11gR2 using Virtual Box

Adding a new node in Oracle RAC 11gR2 using Virtual Box: Create new Virtual Machine using Virtual Box and install same Linux version same as existing nodes RAC1 and RAC2 After installing Linux Follow the steps for Node RAC3 #Add or amend the following lines to the “/etc/sysctl.conf” file. fs.aio-max-nr...
Jan 10, 2013
Virtual IP(VIP) in RAC
673

Virtual IP(VIP) in RAC

How new connection establish in Oracle RAC? For failover configuration we should need to configure our physical ip of host name in listener configuration. Listener process is accepting new connection request and handover user process to server process or dispatcher process in Oracle. Means using listener new connection is being...
Jan 10, 2013
SINGLE CLIENT ACCESS NAME (SCAN) ARCHITECTURE
2.1K

SINGLE CLIENT ACCESS NAME (SCAN) ARCHITECTURE

Single Client Access Name (SCAN) is s a new Oracle Real Application Clusters (RAC) 11g Release 2 feature that provides a single name for clients to access Oracle Databases running in a cluster. The benefit is that the client’s connect information does not need to change if you add or remove nodes in...
Jan 10, 2013
Oracle RAC Cheat Sheet
1.2K

Oracle RAC Cheat Sheet

This is a quick and dirty cheatsheet on Oracle RAC 10g, as my experience with RAC grows I will update this section, below is a beginners guide on the commands and information that you will require to administer Oracle RAC. Acronyms Acronyms GCS Global Cache Services in memory database containing...
Jan 10, 2013
Oracle RAC Components
553

Oracle RAC Components

What is RAC? RAC stands for Real Application cluster. It is a clustering solution from Oracle Corporation that ensures high availability of databases by providing instance failover,media failover features. Mention the Oracle RAC software components:- Oracle RAC is composed of two or more database instances. They are composed of Memory structures and...
Jan 10, 2013
Oracle RAC Overview
903

Oracle RAC Overview

AGENDA What is Real Application Cluster (RAC) ? Why to use RAC ? Single instance vs RAC RAC Architecture Sharing of Resources Background processes Internal structures and services RAC Administration ORACLE Clusterware RAC Mechanism Failover Load Balancing WHAT IS RAC ? Real Application Clusters (RAC) introduced in oracle 9i, is...