Installation Oracle RAC 11gR2 OEL5.9

This manual describes the installation of Oracle Grid Release 11.2.0.3 and Oracle Real Application Cluster (RAC) 11.2.0.3 release .

Prereq
  • Installation of Oracle Enterprise Linux
Software

The necessary software can be downloaded by clicking the following link (s).

Display

If you do not work directly from the console, you can start a terminal session to the server.
On the server, the display must be exported to the machine from where you will perform the installation.

VMware tools

In this installation we are using a virtual host. From the VMware vSphere client mount the VMWaretool iso file to the cd-rom player on the specific virtual host. When you are using a physical machine this step can be skipped.

Naamresolutie

Pas het hosts bestand aan op node/nodes zodat de hostnaam, priv en vip adressen gedefinieerd worden. Dit is noodzakelijk om het Oracle RAC cluster te configureren.

Configure Repository

Configure the connection for the oracle yum-repository.

Set enabled to 1 for 64bit systems.

Installation packages

After you have configured the repository the ‘oracle-validated’ package can be downloaded. This package contains all the settings and software you will need to install Oracle related products.

You can install the packages below, in most cases they are already been installed.

Add user and groups

Add user(s) and group(s) that will be used for the installation.

Create directory’s

Create the directories in which the Oracle software will be installed.

Kernel parameters

Use the kernel settings as described below for a succesful Oracle software installation.

Make using the following command the new kernel parameters active.

Limits.conf

Add the following below in the limits.conf file.

Config selinux

Set secure Linux to permissive by editing the “/etc/selinux/config” file.

Once the change is complete, restart the server or run the following command.

NTP Time

Because use is made of a virtual environment, we set the time synchronization at operating system level. This is handled by the VMware ESX 5.0 environment. There may be other problems with the cluster synchronization times .

Environment variables

In the .bash_profile file in the home directory of the oracle user, set the path references so that they are automatically set when the user oracle logs in.

Node 1

Node 2

NFS

In the /etc/exports have come to be references to the shared storage where the ASM files are located. This share is linked to the directory / u01 / oradata .

Subsequently, the directory can be linked to the nfs share.

This installation has been tested 4 to create files of 5GB stored on a redundant backup of the NFS server system. This ‘Archive’ files will represent the ASM disks for the configuration of the ASM instance.

Installatie Oracle Grid release 11.2.0.3

Go on Node 1 to the directory where the installation software is . The software will automatically be installed on Node 2 .

Installation Oracle Grid 11.2.0.3

If no use is made of automatic software updates, then select ‘Skip software updates ” and then click Next.

Installation Oracle Grid 11.2.0.3

In this installation , we want to make use of a cluster and this must also be configured . This, select the first option “Install and Configure Oracle Grid Infrastructure for a Cluster , and then click Next.

Installation Oracle Grid 11.2.0.3

Select ” Advanced Installation ” if you want to configure settings and then click Next.

Installation Oracle Grid 11.2.0.3

Enter the SCAN address as in the host file is given to and de- select ” GNS ” when do not use to be there Grid Naming Service , and then click Next.

Installation Oracle Grid 11.2.0.3

Click ‘ Add’ to add a node , enter the details as in the host file and kilk OK. Then click ‘ SSH conectivity “

Installation Oracle Grid 11.2.0.3

Enter the password in the Oracle user and click on “Setup” to configure the ssh connection to the other node and kilk then click Next.

Installation Oracle Grid 11.2.0.3

Check the Public and Private network , and then click Next.

Installation Oracle Grid 11.2.0.3

Select ” Oracle Automatic Storage Management (Oracle ASM ), and then click Next.

Installation Oracle Grid 11.2.0.3

Click ” Change Discovery Path ‘ and refer to ‘ / u01 / oradata ‘ mount point (NFS shared file system).

Installation Oracle Grid 11.2.0.3

Click OK.

Installation Oracle Grid 11.2.0.3

The disks that will be used for the ASM instance are now displayed , select it and then click Next.

Installation Oracle Grid 11.2.0.3

If you want to use the same password for the user SYS and ASMSNMP select “Use same password for thesis Accounts” and then click Next.

Installation Oracle Grid 11.2.0.3

If you do not want to use Intelligent Platform Management Interface ( IPMI ), select ‘ Do not use Intelligent Platform Management Interface ( IPMI ), and then click Next.

Installation Oracle Grid 11.2.0.3

Choose from the drop down box ” oinstall ” and then click Next.

Installation Oracle Grid 11.2.0.3

The Oracle base and software location are shown.

Installation Oracle Grid 11.2.0.3

The Oracle Grid release 11.2.0.3 location , we want to have in this case at a different location . Enter ‘ / u01 / app / grid ” in the text field next Software Location and then click Next.

Installation Oracle Grid 11.2.0.3

Indicate where the ” oraInventory ” to appear a kilk then click Next.

Installation Oracle Grid 11.2.0.3

You will now see whether the environment meets the requirements for installing Oracle Grid Release 11.2.0.3.

Installation Oracle Grid 11.2.0.3

In this case we have a bug ( Metalink Note 1267569.1 ) is controlled manually or ASM is running.
Tick to put Ignore All and then Next.

Installation Oracle Grid 11.2.0.3

Enter the above scripts on both node , and then click OK. Node 1 and Node 2

Installation Oracle Grid 11.2.0.3

An overview is shown of the installation settings. Check it, and then click Next.

Installation Oracle Grid 11.2.0.3

The installation of Oracle Grid release 11.2.0.3 is performed.

Installation Oracle Grid 11.2.0.3

At the end of the installation process you will be asked to put on both machines’ orainstRoot.sh “and” root.sh ” under the user to perform root. Do this also in that order.

Node 1 and Node 2

Node 1 and Node 2

 Installation Oracle Grid 11.2.0.3

Click on Close to exit the installation of Oracle Grid Release 11.2.0.3 .

Installation Database

Installation Oracle RAC 11.2.0.3

If no email is required on security related findings uncheck on ” I wish to … . ‘Away , and then click Next.

Installation Oracle RAC 11.2.0.3

Click Yes.

Installation Oracle RAC 11.2.0.3

Wanneer er geen gebruik gemaakt moet worden van ‘automatische’ updates selecteer dan ’Skip Software Updates’ en klik vervolgens op Next.

Installation Oracle RAC 11.2.0.3

Selecteer ‘Create and configure a database’ en klik vervolgens op Next.

Installation Oracle RAC 11.2.0.3 

Select ‘Server Class’ and click on next.

Installation Oracle RAC 11.2.0.3

Select Oracle Real Application Cluster Database Installation ” and make sure all node are checked, and then click Next.

Installation Oracle RAC 11.2.0.3

Select ‘Advanced install’ and then click Next.

Installation Oracle RAC 11.2.0.3

Add extra languages , and then click Next.

Installation Oracle RAC 11.2.0.3

Select Enterprise Edition , and then click Next.

Installation Oracle RAC 11.2.0.3

Indicate what the ” Oracle Base ” should be and what the “Software Location ” for installation vanOracle Real Application Cluster release 11.2.0.3 should be , and then click Next.

Installation Oracle RAC 11.2.0.3

In this case, a ” General Purpose / Transaction Processing ” database selected. Make the desired selection, then click Next.

Installation Oracle RAC 11.2.0.3

Enter the Global Database name ‘and’ Oracle Service Identifier , and then click Next.

Installation Oracle RAC 11.2.0.3

If you want to determine how the memory should be divided then uncheck to ‘Enable Automatic Memory Management ‘ away , and then click Next.

Installation Oracle RAC 11.2.0.3

Select the Character Set ” to be used for the database and then click Next.

Installation Oracle RAC 11.2.0.3

Put a tick in ” Assert all new security settings , and then click Next.

Installation Oracle RAC 11.2.0.3

When not being used is made of a central Oracle Enterprise Manager select “Use Oracle Enterprise Manager Database Control for Database Management , and then click Next.

Installation Oracle RAC 11.2.0.3

Enter the password for the user ASMSNMP and then click Next.

Installation Oracle RAC 11.2.0.3

Select whether to automatically create backups, and then click Next.

Installation Oracle RAC 11.2.0.3

Select the ASM disk group where the database files moved to and then click Next.

Installation Oracle RAC 11.2.0.3

If you want to use the same password for the user SYS , SYSTEM , SYSMAN and dbsnmp select “Use same password for thesis Accounts” and then click Next.

Installation Oracle RAC 11.2.0.3

Enter the “Database Operator Group ‘ on . In this case is that the user ” oinstall ” and then click Next.

Installation Oracle RAC 11.2.0.3

Wait until the prerequisite check is complete . When problems occur repair it or put a tick in “Ignore All” checkbox and then click Next.

Installation Oracle RAC 11.2.0.3

Click Next

Installation Oracle RAC 11.2.0.3

An overview is shown of the installation. Check these details , and then click Next.

Installation Oracle RAC 11.2.0.3

An overview is shown of the installation. Check these details , and click Next .

Installation Oracle RAC 11.2.0.3

 

Installation Oracle RAC 11.2.0.3

Press OK.

Installation Oracle RAC 11.2.0.3

Log in to the system as root and go to the correct directory. Click OK when it is carried out below.

Installation Oracle RAC 11.2.0.3

The Real Application Cluster database is created. Click Close to exit the installation screen.

Sequel
Information

Please let me know if this manual ‘Installation Oracle RAC 11gR2 OEL5.9’ was usefull to you. If there are  errors or you have suggestions regarding this manual, please let me know.
No rights can be derived from this manual

Regards,

Maarten

Maarten Schoonus

Leave a Reply