on oracle linux 6 oracle 11.2 grid asm standalone nonrac

Upload: praveen-bachu

Post on 07-Jan-2016

63 views

Category:

Documents


0 download

DESCRIPTION

On Oracle Linux 6 installing and creating Oracle 11.2 Grid ASM Standalone Server (Non-RAC/not a RAC)

TRANSCRIPT

  • Table of Contents

    In This Article ........................................................................................................................................... 2

    Software .................................................................................................................................................. 2

    Hardware (Disks) Configuration .............................................................................................................. 2

    Assumptions ............................................................................................................................................ 2

    Virtual Disks Configuration ...................................................................................................................... 3

    Server Preparation .................................................................................................................................. 3

    UDEV Preparation.................................................................................................................................... 5

    Grid Installation ....................................................................................................................................... 7

    ASM Database Creation ........................................................................................................................ 10

    Login And Verify ASM Instance ............................................................................................................. 14

    FRA Disk Group Creation ....................................................................................................................... 15

    Verify With ASMCMD ............................................................................................................................ 15

    Archive Log Setup .................................................................................................................................. 16

    Verify Archives ....................................................................................................................................... 17

    Verify The Basic Parameters .................................................................................................................. 18

    Verify Redo Log Groups ......................................................................................................................... 18

    Links ....................................................................................................................................................... 18

  • In This Article Installing and creating 11gR2 Oracle Grid (Non-RAC/not a RAC) Infrastructure Standalone

    Server, and ASM on Oracle Linux 6.4 using Oracle Virtual Box (This works on most RHEL Clones)

    Grid and Oracle home is owned by Oracle so, there is only one account used to manage both homes

    The screenshots are less and they are specific to the point where the changes have to be done

    Software Oracle Virtual Box and Virtual Disks, Oracle 11gR2 Database and Grid Software for Linux x64 Oracle Software Part 1&2&3 for Linux x64 should be downloaded for this installation

    Hardware (Disks) Configuration On a Separate Drive Oracle home and Grid home are installed. So, this disk will have file

    system Three Virtual disks for ASM are used (External Redundancy was set). Two of them are used

    for storing Data, which is named as DATA and the third disk is for other files, which is named as FRA (Storing Archive logs )

    Important Info/Note : It is said the FRA is calculated approximately double the size of Data disk.

    Practically thinking, a test database is of 4+ GB, so when a full backup is taken and stored on FRA or another disk it should be having more space

    When RMAN is set for backup more disk space should be considered (the idea is to repeat the step of adding more disk space gives you a practise)

    Assumptions Oracle Linux 6.4 was installed and configured already

  • Virtual Disks Configuration On the below screen you can see how you can create ASM Disks. That needs to be "Fixed Size

    Storage"

    Server Preparation On this below link click on the "manual set up" for the values to be set etc

    https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oracle-linux-6-using-virtualbox

    When you have Oracle Linux Server 6.4. or 6.5 then only the below Packages will be missing

  • The Oracle Bash Profile is set as below suitable for my Server Host Name, Partitions, directories etc . You have to do the necessary changes suitable for your Server Host Name etc.

  • UDEV Preparation Create Partitions Note : For ASM, creating a single Partition of disk is the way to go and OS File System is not

    installed

    After Partitioning the disks are verified

  • Verify the details

  • Grid Installation

    The recommended size of AU is 4 MB by Oracle for good performance. If you do not change it that remains with the default 1 MB size (For example, in case DWH Database it is set to higher number, for example 16 MB of AU size)

  • Only 2 Disks are for DATA and the third disk is for FRA. This creation of FRA Disk group is done later

    Note: The Oracle_Base is same for Grid and Oracle Home but, only Software locations for them are on different directories and should be separated

  • Once you are present with Summary and happy then click on "install"

    The scripts are executed with "Root" account

    Wait to see the below success confirmation "successfully...Standalone Server"

  • Verify the "oratab" file to see the details of ASM

    ASM Database Creation

  • Click on "Options" (on the lower right side) and you deselect that you do not need

    Note: The Oracle_Base is same for Grid and Oracle Home but, only Software locations for them are on different directories and they should be separated

  • So, once you do the changes you reach the Summary screen, then click "install" to get it installed

  • Login to the Enterprise Manager

    Login And Verify ASM Instance

  • FRA Disk Group Creation Run the ASMCA to create this new Disk Group "FRA". At this point it has only 1 Disk which is

    the third Partition

    Verify With ASMCMD

  • Archive Log Setup

  • Verify Archives

  • Verify The Basic Parameters

    Verify Redo Log Groups

    Links The Oracle Master has already shown this on the below link. The only difference is that it is

    about RAC (but, of course it is about Grid Infrastructure)

    https://oracle-base.com/articles/11g/oracle-db-11gr2-rac-installation-on-oracle-linux-6-using-virtualbox

    Check there UDEV etc.