Step By Step: Install Oracle 11g R2
Real Application Cluster (11.2.0.1) on Oracle Enterprise Linux 5.5 (32 bit)
Platform.
By Bhavin Hingu
After the successful
installation of 11g R2 Grid Infrastructure Software, it’s time to install 11g
R2 RAC software (database).
·
Install 11g R2 RAC Software
(11.2.0.1)
·
Add new listener (LAB_LISTENER TCP:1525)
·
Create ASM disk groups (FRA and
DATA)
Start the runInstaller from 11g R2 Real
Application Cluster (RAC) Software Location:
[oracle@node1 ~]$
/home/oracle/db11201/database/runInstaller
Real Application Cluster installation process:
Configure Security Updates:
Email: bhavin@oracledba.org
Ignore the “Connection Failed” alert.
Installation Option:
Install database software only
Node Selection:
Select All the Nodes (node1,node2
and node3)
Product Language:
English
Database Edition:
Enterprise Edition
Installation Location:
Oracle Base: /u01/app/oracle
Software Location: /u01/app/oracle/db11201
Operating System Groups:
Database Administrator (OSDBA) Group: dba
Database Operator (OSOPER) Group: oinstall
Network Interface Usage:
OUI picked up all the interfaces correctly. I
did not have to make any changes here.
Summary Screen:
Verified the information here and pressed
“Finish” to start installation.
At the End of the installation, the two scripts
needs to be executed on all the nodes as root user.
/u01/app/oracle/db11201/root.sh
The Screenshots of the
11g R2 Real Application Cluster Installation is as follow:
Run the root.sh on all the RAC nodes.
At this point, the 11g
R2 (11.2.0.1) Real Application cluster Installation is completed successfully.
Now, it’s time to create new ASM disk groups and LISTENER for the new database.
Listener name: LAB_LISTENER
END Point: TCP:1525
Invoke the netca utility under $ORACLE_HOME/bin to create a listener
and provide the above information to the specific window. The screenshots of
this process are as below.
Disk Group Name: FRA, DATA
ASM DISKs: DSK02, DSK03 respectively.
Redundancy Level: External
Connect as grid user and Invoke the asmca utility under $GRID_HOME/bin to create these disk
groups. The screenshots of this process are as below.
Create 11g R2 RAC database using dbca:
DB Name: labdb
Connect as oracle user and invoke the dbca utility under $ORACLE_HOME/bin to create a new
database. After the successful creation of database, modify the LOCAL_LISTENER
parameter to point to port 1525 for all the RAC nodes and test the connectivity
to the database. The HOST and port value in the TNS ALIAS (connect string)
should be set to lab-scan.hingu.net and 1521 respectively. This way, all client knows is the cluster host and port
(lab-scan.hingu.net:1521). The DATABASE instances gets registered with the SCAN
Listener (1521) running on virtual Host via REMOTE_LISTENER parameter and
client connect request coming to SCAN listener gets redirected to the least
loaded DATABASE instance based on the service name specified in connect string.
So, the Database instance gets registered with the LOCAL_LISTENER (regular
Database Listener) and REMOTE_LISTENER (scan).
The screenshots of this process are as below.
[grid@node1
~]$ lsnrctl status listener_scan1
LSNRCTL for
Linux: Version 11.2.0.1.0 - Production on 03-SEP-2011 22:30:53
Copyright
(c) 1991, 2009, Oracle. All rights
reserved.
Connecting
to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LISTENER_SCAN1)))
STATUS of
the LISTENER
------------------------
Alias LISTENER_SCAN1
Version TNSLSNR for Linux: Version
11.2.0.1.0 - Production
Start
Date 03-SEP-2011 22:23:08
Uptime 0 days 0 hr. 7 min. 45 sec
Trace
Level off
Security ON: Local OS Authentication
SNMP OFF
Listener
Parameter File
/u01/app/grid11201/network/admin/listener.ora
Listener Log
File
/u01/app/grid11201/log/diag/tnslsnr/node1/listener_scan1/alert/log.xml
Listening
Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LISTENER_SCAN1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.152)(PORT=1521)))
Services
Summary...
Service
"labdb.hingu.net" has 3 instance(s).
Instance "labdb1", status READY,
has 1 handler(s) for this service...
Instance "labdb2", status READY,
has 1 handler(s) for this service...
Instance "labdb3", status READY,
has 1 handler(s) for this service...
Service
"labdbXDB.hingu.net" has 3 instance(s).
Instance "labdb1", status READY,
has 1 handler(s) for this service...
Instance "labdb2", status READY,
has 1 handler(s) for this service...
Instance "labdb3", status READY,
has 1 handler(s) for this service...
The command
completed successfully
[grid@node1
~]$
[oracle@node1 ~]$ lsnrctl status
lab_listener
LSNRCTL for Linux: Version
11.2.0.1.0 - Production on 03-SEP-2011 22:36:55
Copyright (c) 1991, 2009,
Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=LAB_LISTENER)))
STATUS of the LISTENER
------------------------
Alias LAB_LISTENER
Version TNSLSNR for Linux: Version
11.2.0.1.0 - Production
Start Date 03-SEP-2011 22:23:08
Uptime 0 days 0 hr. 13 min. 47 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File
/u01/app/oracle/db11201/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/node1/lab_listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=LAB_LISTENER)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1525)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.2.51)(PORT=1525)))
Services Summary...
Service "labdb.hingu.net"
has 1 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this
service...
Service
"labdbXDB.hingu.net" has 1 instance(s).
Instance "labdb1", status READY, has 1 handler(s) for this
service...
The command completed successfully
[oracle@node1 ~]$
With this, the
Installation of 11g R2 RAC on Linux (OEL 5.5) is completed successfully. I hope
you find this article helpful.
Bhavin Hingu