on oracle linux 6 oracle 11.2 grid asm standalone nonrac
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.