Jan 26, 2013
Oracle Enterprise Linux 5.7 Installation
2.2K

Oracle Enterprise Linux 5.7 Installation

Oracle Enterprise Linux 5.7 Installation on Oracle VirtualBox Follow this article to install Oracle Enterprise Linux 5.7 64 bit on Oracle Virtualbox Step 1 is to install Oracle Virtual Box in your Windows Host after enabling Virtualization in bios of the machine. Step 2 is to download OEL 5.7...
Jan 22, 2013
Oracle Database 11G Installation Error
1K

Oracle Database 11G Installation Error

Error: ===== [oracle@fmw database]$ ./runInstaller Starting Oracle Universal Installer… Checking Temp space: must be greater than 120 MB. Actual 117523 MB Passed Checking swap space: must be greater than 150 MB. Actual 11999 MB Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Preparing...
Jan 19, 2013
VM Crashes Frequenty in VMware Server 2.0.2 while installing 11gR2 RAC
718

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
1K

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
848

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
843

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.3K

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.4K

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
765

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
1.1K

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...