Scribd Logo
Upload

Welcome to Scribd!

  • 48 views

    D50311GC40 Les03

    Uploaded by

    MuhammadSaad
    CHAPTER 3 RAC

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd

    D50311GC40 Les03

    Uploaded by

    MuhammadSaad
    48 views32 pages
    CHAPTER 3 RAC

    Original Title

    D50311GC40_Les03

    Copyright

    © © All Rights Reserved

    Available Formats

    PPT, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    CHAPTER 3 RAC

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    48 views32 pages

    D50311GC40 Les03

    Uploaded by

    MuhammadSaad
    CHAPTER 3 RAC

    Copyright:

    © All Rights Reserved
    Download as PPT, PDF, TXT or read online from Scribd
    Download as ppt, pdf, or txt
    of 32

    3

    Installing and Configuring Oracle RAC

    Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Objectives

    After completing this lesson, you should be able to:


    Install the Oracle database software
    Create a cluster database
    Perform post-database-creation tasks
    Convert a single-instance Oracle database to RAC

    3-2 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Installing the Oracle Database Software
    $ /stage/database/Disk1/runInstaller

    3-3 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Installing the Oracle Database Software

    3-4 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Installing the Oracle Database Software

    3-5 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Installing the Oracle Database Software

    3-6 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Installing the Oracle Database Software

    3-7 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Creating the Cluster Database

    $ cd /u01/app/oracle/product/11.2.0/dbhome_1/bin
    $ ./dbca

    3-8 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Database Type Selection

    3-9 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Database Identification

    3 - 10 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Cluster Database Management Options

    3 - 11 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Passwords for Database Schema Owners

    3 - 12 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Database File Locations

    3 - 13 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Recovery Configuration

    3 - 14 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Database Content

    3 - 15 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Initialization Parameters

    3 - 16 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Database Storage Options

    3 - 17 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Create the Database

    3 - 18 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Monitoring Progress

    3 - 19 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Postinstallation Tasks
    Download and install the required patch updates.
    Verify the cluster database configuration.
    $ srvctl config database -d orcl
    Database unique name: ORCL
    Database name: ORCL
    Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
    Oracle user: oracle
    Spfile: +DATA/orcl/spfileorcl.ora
    Domain: example.com
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Server pools: orcl
    Database instances: orcl1,orcl2
    Disk Groups: DATA,FRA
    Services:
    Type: RAC
    Database is administrator managed

    3 - 20 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Checking Managed Targets
    https://host01.example.com:1158/em

    3 - 21 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Background Processes Specific to Oracle RAC

    ACMS: Atomic Control File to Memory Service


    GTX[0-j]: Global Transaction Process
    LMON: Global Enqueue Service Monitor
    LMD: Global Enqueue Service Daemon
    LMS: Global Cache Service Process
    LCK0: Instance Enqueue Process
    LMHB: Global Cache/Enqueue Service Heartbeat Monitor
    PING: Interconnect Latency Measurement Process
    RCBG: Result Cache Background Process
    RMSn: Oracle RAC Management Processes
    RSMN: Remote Slave Monitor

    3 - 22 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Single Instanceto-RAC Conversion

    Single-instance databases can be


    converted to RAC using:
    DBCA
    Enterprise Manager
    Single-instance
    RCONFIG utility database
    DBCA automates most of the
    conversion tasks.
    Before conversion, ensure that:
    Your hardware and operating RAC database
    system are supported
    Your cluster nodes have access to
    shared storage

    3 - 24 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Considerations for Converting Single-Instance
    Databases to Oracle RAC
    Backup procedures should be available before conversion
    takes place.
    Archiving in Oracle RAC environments requires a thread
    number in the archive file format.
    The archived logs from all instances of an Oracle RAC
    database are required for media recovery.
    By default, all database files are migrated to Oracle
    Managed Files (OMF).

    3 - 25 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Single-Instance Conversion Using the DBCA

    Conversion steps for a single-instance database on


    nonclustered hardware:
    1. Back up the original single-instance database.
    2. Complete the Oracle Grid Infrastructure installation.
    3. Validate the cluster.
    4. Copy the preconfigured database image.
    5. Install the Oracle Database 11g software with RAC.

    3 - 26 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Conversion Steps
    1. Back up the original single-instance database.

    3 - 27 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Conversion Steps

    2. Perform the preinstallation steps.


    Tasks include kernel parameter configuration, hardware
    setup, network configuration, and shared storage setup.
    3. Set up and validate the cluster.
    Create a cluster with the required number of nodes
    according to your hardware vendors documentation.
    Validate cluster components before installation.
    Install Oracle Clusterware.
    Validate the completed cluster installation by using cluvfy.
    4. Copy the preconfigured database image.
    The database structure *.ctl file
    The preconfigured database image *.dfb file
    5. Install the Oracle Database 11g Release 2 software with
    RAC.
    3 - 28 Copyright 2012, Oracle and/or its affiliates. All rights reserved.
    Single-Instance Conversion Using rconfig

    1. Locate the appropriate .xml file located in the


    $ORACLE_HOME/assistants/rconfig/sampleXMLs
    directory.
    2. Modify the ConvertToRAC_AdminManaged.xml or
    ConvertToRAC_PolicyManaged.xml file as required for
    your system.
    3. Save the file under a different name.

    $ cd $ORACLE_HOME/assistants/rconfig/sampleXMLs
    $ vi ConvertToRAC_PolicyManaged.xml
    ... Saved as my_rac_conversion.xml
    $ rconfig my_rac_conversion.xml

    3 - 30 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Quiz

    The RAC database software installation is initiated by executing


    runInstaller from the root directory of the Oracle Database
    11g Release 2 CD-ROM or from the software staging location.
    1. True
    2. False

    3 - 32 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Quiz

    A single-instance database can be converted to a RAC


    database by using (choose the correct options):
    a. rconfig
    b. netca
    c. dbca

    3 - 33 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Summary

    In this lesson, you should have learned how to:


    Install the Oracle database software
    Create a cluster database
    Perform post-database-creation tasks
    Convert a single-instance Oracle database to RAC

    3 - 34 Copyright 2012, Oracle and/or its affiliates. All rights reserved.


    Practice 3 Overview

    This practice covers the following topics:


    Installing the Oracle database software
    Creating a RAC database

    3 - 35 Copyright 2012, Oracle and/or its affiliates. All rights reserved.

    You might also like