Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Tips Database Forum Rss Feed

» Database Journal Home
» Database Articles
» Database Tutorials
MS Access
SQL Scripts & Samples
» Database Forum
» Slideshows
Free Newsletters:

News Via RSS Feed

Rss Feed

Database Journal |DBA Support |SQLCourse |SQLCourse2

Featured Database Articles


Posted Feb 25, 2010

Oracle Database 11gR2: Installing Grid Infrastructure - Page 2

By Jim Czuprynski

Installing Oracle Grid Infrastructure

I know this probably seems like an immense amount of preparation, but based on my numerous attempts at installing the Grid Infrastructure in both 32- and 64-bit environments, I’ve found that it’s important to perform it properly and carefully; otherwise, I’m just going to have to return to my checklist to figure out what I missed before I can complete the installation. But once these setup steps are completed, it’s time to begin installation of the Grid Infrastructure through Oracle Universal Installer (OUI). OUI gets a welcome facelift in this release, and that’s evident from the first panel that’s displayed after invoking the runInstaller command script from the Grid Infrastructure staging directory as shown in Figure 1.1 below:

Click for larger image
Initial OUI Grid Infrastructure Installation Panel

Figure 1.1. Initial OUI Grid Infrastructure Installation Panel.

Note that I’ve chosen the option to install Grid Infrastructure for a standalone server; the installation for a clustered environment like Real Application Clusters is obviously quite different. The next panel allows me to select which languages will be supported for this installation (Figure 1.2):

Click for larger image
Language Choices

Figure 1.2. Language Choices.

And now the beauty of using ASMLIB is apparent: It’s really easy to see which virtual disks are which because I’m able to label the mount points any way I choose for simpler management and identification, as shown in Figure 1.3.:

Click for larger image
Assigning Raw Partitions for ASM Disk Groups

Figure 1.3. Assigning Raw Partitions for ASM Disk Groups.

Now that my initial ASM disk group configuration is complete, the next two panels allow me to specify a strong, secure password (Figure 1.4) as well as assign appropriate operating system groups (Figure 1.5):

Choosing ASM Passwords
Figure 1.4. Choosing ASM Passwords.

Specifying ASM Administration Groups
Figure 1.5. Specifying ASM Administration Groups.

Note that the location for my Grid Infrastructure is placed within the same general path that a traditional Oracle database home would be placed, as shown in Figure 1.6 below.

Choosing Grid Infrastructure Home Path
Figure 1.6. Choosing Grid Infrastructure Home Path.

And here’s a neat new feature! As shown in Figure 1.7, once Oracle 11gR2 has automatically verified that all prerequisites have been met, it identifies whether any of the issues detected can be ignored (at my peril, of course!) or even repaired automatically by generating a fixit.sh script:

Validating Installation Prerequisites
Figure 1.7. Validating Installation Prerequisites.

Since I know from prior installation attempts that the reported issues are not “show stoppers,” I simply selected the Ignore All option on the panel, and OUI then presents me with a summary of what it intends to accomplish during the installation. Note another neat feature: I can tell OUI to generate a response file just by clicking the Save Response File ... button.

Final Confirmation
Figure 1.8. Final Confirmation.

As the installation continues, OUI returns a summary of its status, but note that I can opt to view a detailed summary of that installation at any time by clicking on the Details button:

Installation Progress
Figure 1.9.1. Installation Progress.

Installation Details
Figure 1.9.2. Installation Details.

At last, the expected prompt to run the root.sh script – always a good sign that the majority of the installation is complete.

root.sh Prompt
Figure 1.9.3. root.sh Prompt.

Post-root.sh Configuration
Figure 1.9.4. Post-root.sh Configuration.

Now that all configuration assistants have completed their work, OUI pats me on the back for a job well done.

Installation Confirmation
Figure 1.10. Installation Confirmation.

Next Steps

In the next article in this series, I’ll demonstrate how to configure the new ASM Clustered File System (ACFS) to show how ACFS makes short work of applying patches to the binary files for any Oracle Home so configured.

References and Additional Reading

Before you proceed to experiment with any of these new features, I strongly suggest that you first look over the corresponding detailed Oracle documentation before trying them out for the first time. I’ve drawn upon the following Oracle Database 11g Release 2 documents for this article’s technical details:

E10881-03 Oracle Database 11gR2 New Features

E10592-04 Oracle Database 11gR2 SQL Language Reference

E10595-06 Oracle Database 11gR2 Administrator’s Guide

E10713-04 Oracle Database 11gR2 Concepts

E10820-03 Oracle Database 11gR2 Reference

E10500-04 Oracle Database 11gR2 Storage Administrator’s Guide

And these Oracle MetaLink documents are also extremely helpful in setting up Grid Infrastructure for the first time:

462618.1 Cannot Find Exact Kernel Version Match For ASMLib (Workaround using oracleasm_debug_link tool)

» See All Articles by Columnist Jim Czuprynski

Oracle Archives

Latest Forum Threads
Oracle Forum
Topic By Replies Updated
Oracle Data Mining: Classification jan.hasller 0 July 5th, 07:19 AM
Find duplicates - Unique IDs Lava 5 July 2nd, 08:30 AM
no matching unique or primary key rcanter 1 April 25th, 12:32 PM
Update values of one table based on condition of values in other table using Trigger Gladiator 3 February 29th, 06:01 PM