UNIX Administrator - Linux/Solaris (IL) Next Step Systems US-IL-Chicago Post A Job | Post A Resume

Oracle 10g Real Application Clusters (RAC)

Oracle RAC Monitoring: Keeping your RAC under control : Proactively monitoring your Oracle RAC or even a typical single node Oracle database will keep you upwind of problems. However, that means you need to know which tools you should be using to do just that. Read on to learn more.

Oracle Extended RAC: Stretching your RAC to the limit : Tarry Singh offers an overview of how to extend your RAC geographically, up to 25km or even 50kms.

Oracle RAC: Capacity Planning for your RAC : Implementing RAC, or any clustered solution, requires planning. Tarry Singh discusses capacity planning, breaking it up into several components, such as network, storage, and infrastructure.

Oracle 10gR2 RAC Load Balancing Features : Learn how Oracle 10gR2 takes advantage of client-side connection load balancing, server-side load balancing, and the new Load Balancing Advisor (LBA) features to improve the distribution of workloads across the appropriate nodes in an Oracle 10gR2 RAC clustered database environment.

Upgrade Oracle 9i RAC to Oracle 10g RAC : This article provides the procedures for converting Oracle 9i (9.2.0.4) RAC to Oracle 10g (10.2.0.1) RAC on Red Hat Enterprise Linux 3 (RHEL3).

Oracle RAC: How shared storage works on VMware

Part 4 - Clustering Oracle RAC Virtual Machines across physical and ESX hosts : Part 4 of this series examines various possibilities for building clusters across several physical and ESX hosts and takes a quick look at upgrading clustered Virtual Machines in all the three scenarios.

Part 3 - Clustering Oracle RAC Virtual Machines across ESX hosts : Our previous article looked at the clustering possibilities on the ESX Server. In this article, we will examine the various possibilities for building clusters across several physical ESX hosts and the clustering possibilities across ESX hosts and physical machines.

Part 2 - Clustering: Application Clustering vs. VirtualCenter Clustering : Part two of this series discusses creating clustered virtual machines on VMware's ESX 3 Server.

Part 1 - Storage considerations: VI3 ESX Server vs VMware Server, VMware Workstation : Tarry Singh revisits the storage option on VMware Server, VMware Workstation and ESX 3.0.1 Server for Oracle RAC.

RACingAhead with Oracle on VMware

Part 16: Installation gotchas for Oracle Linux , Oracle RAC 10gR2 and VMware ESX 3.0.1 : Tarry Singh covers several issues that can cause problems when installing Oracle Linux 10gR2 RAC on Oracle Enterprise Linux 4.4 with VMware ESX 3.0.1.

Part 15: Creating database using DBCA on Redhat 4.2 Advanced Server : Part 15 of the RACing ahead with Oracle on VMware Series looks at the companion CD installation and DBCA, creating the ASM instances.

Part 14: Software installation : Part 14 of RACing ahead with Oracle on VMware covers the database software only installation and the listener setup.

Part 13: Installing Oracle Clusterware on Redhat 4.2 : Part 13 of the RACing ahead with Oracle on VMware Series covers the first steps towards installing Oracle Clusterware on Redhat 4.2.

Part 12: Setting up ASM on Oracle 10g : Part 12 of Racing Ahead with Oracle on VMware offers a brief look at what ASM is, and how to go about installing, configuring and stamping the ASM disks.

Part 11: Final Checks and OCFS2 Setup : Part 11 of "RACing ahead with Oracle on VMware" continues with the final checks and the installation and configuration of OCFS2.

Part 10: Securing Remote Access and Copy with SSH and SCP : Part 10 of "RACing ahead with Oracle on VMware" continues the remote access set up and looks at compatible SSH and SCP support.

Part 9: Configuring RHEL/Centos 4.2 Server for Oracle RAC 10g R2 Readiness : Part 9 of this series continues the setup of the RHEL/Centos 4.2 server, covering setting up the Swap Space, Shared Memory, Semaphores, File Handles and Hangcheck Timer.

Part 8: Configuring RHEL/Centos 4.2 Server for Oracle RAC 10g R2 Readiness : In part 7 of this series, we started a detailed explanation of setting up a RHEL 4.2 or Centos 4.2 OS. This article works towards our goal by configuring the Network and Linux servers for Oracle readiness.

Part 7: Installing RHEL 4.2 on VMware, Preparing Tools and Network Configuration : Tarry Singh examines configuration errors and issues when installing RHEL 4.2 on VMware Virtual Machines.

Part 6:Preparing for a 2-node Oracle 10gR2 RAC on RHEL 4.2 Linux with VMware : Tarry Singh discusses the preparation and planning for the installation of a 2-node RHEL 4.2 Linux VMware for Oracle 10gR2 RAC. Also covered in the article are groundbreaking technologies like OCFS2 and ASMlib, and an overview the ESX Server in general.

Part 5: The powerful SRVCTL Utility : Part 5 of this series discusses using the SRVCTL utility to see if our database is functioning as it should.

Part 4: Installing RAC Database with ASM Option : The last article in this series talked about installing clusterware on two Windows 2003 nodes. Part 4 of this series discusses how to install a fully working RAC with ASM on the disk setup that was explained in Part III.

Part 3: Installing Oracle 10g Release 2 Clusterware on a 2-node Windows 2003 Enterprise Edition Server : Part 3 of this series discusses the installation of Clusterware on a 2-node windows 2003 server with VMware.

Part 2: Oracle RAC and RAW disk setup on Windows 2003 Enterprise Server : Part two of this series continues the discussion of Oracle RAC, how to install the VMware tools and set up RAW disks on Windows 2003 Enterprise Server.

Part 1: Setting up VMware for Oracle/Intro to Virtualization/Server Consolidation : Part l of this series offers a brief introduction to setting up VMware and the importance of other tools such as VNC, freeNX or NoMachine, PuTTY, etc.

Oracle RAC Administration

Oracle RAC Benchmarking with SwingBench 2.2 : Tarry Singh discusses why benchmarking is important and offers an overview of SwingBench 2.2, a free Java based utility, to stress test Oracle databases.

Part 21: Troubleshooting ASM problems on VMware ESX 3.x - Part 2 : Tarry Singh looks at some problems that can be encountered during ESX 3.x Oracle RAC setup, and how to fix those problems.

Part 20: Troubleshooting ASM problems on VMware ESX 3.x : Several errors may be encountered when setting up ESX 3.x on Oracle Rac. This article covers some of those errors and how to fix them.

Part 19: Wait events in Oracle RAC : Tarry Singh discusses wait events in Oracle RAC, focusing on Global Cache waits in particular.

Part 18: Checking RAC status with SQL/OS level statements : Tarry Singh discusses running typical SQL/OS level statements to check the status of RAC nodes.

Part 17: Backing up your RAC with RMAN : Whether you are a single node Oracle DBA or a multi-node RAC farm DBA, you will be confronted with various backup alternatives. Tarry Singh discusses several scenarios and backup possibilities using the RMAN utility.

Part 16: Balancing act between Server and Client : In this article, Tarry Singh takes a little detour to look at connectivity load balancing and failover.

Part 15: Connection Load Balancing and FAN : Part 15 of our series continues the discussion of workload characteristics and load balancing connections in our Virtualized RAC, focusing this time on Connection Load Balancing and Fast Application Notification.

Part 14: Services Architecture in Workload Management : Part 14 of the series focuses on workload management, which facilitates management and distribution of the workload to provide peak performance and high availability.

Part 13: Cache Coherency : Part 13 of this series takes a break from administration to discuss performance metrics specific to the RAC environment.

Part 12: RAC Essentials : Part 12 of this series continues its discussion of RAC specific parameters.

Part 11:The RAC DBA continued : Part 11 of this series continues the discussion of Oracle RAC DBA essentials.

Part 10:The RAC DBA : Part 10 of this series takes a breather, to review some RAC basics, before returning to the more advanced material in RAC administration. (or other users).

Part 9: Hands on administration : Tarry Singh takes a closer look at installation errors that aren't really errors, ESX host tuning for time synchronization and some SRVCTL commands.

Part 8: Hands on syntax check : Part 8 of this series covers the details of the commands discussed in Parts 3 and 4, "Administering the Clusterware Components".

Part 7: Starting and Stopping the Database Instances and RAC Databases : Learn how to start up and shut down database instances using Enterprise Manager, SQL*Plus and SRVCTL.

Part 6: Administering the Database Instances and Cluster Databases : Part 6 of this series offers an overview of three tools that can be used to tame the Oracle database, whether it be a multi-node RAC farm or a single Oracle instance.

Part 5: Administering the Clusterware and ASM Storage : Part 5 of the Oracle RAC Administration series offers a quick look at the administration of clusterware and storage administration.

Part 4: Administering the Clusterware: Components : Part 4 of this series covers administering and restoring the OCR using OCR Backups and overruling the OCR Data Loss Protection Machinery.

Part 3: Administering the Clusterware Components : This article examines two important components of Oracle Clusterware, : the voting disk and the Oracle Cluster Registry (OCR).

Part 2: CRS commands : Part 2 of this series continues with a discussion of how the CRS commands can be used to fix/troubleshoot the quirkiness of Real Application Clusters.

Part 1: Controlling the Cluster with CRS command : Tarry Singh begins a new series on Oracle RAC Administration with a discussion on the challenges of administering a RAC database.

If you have an interesting column / article / short note etc., that you would like to share with the rest of the DBA world, please send it to webmaster@dbasupport.com.

Back to DBAsupport.com