Installation of Oracle 11g R1 (11.1.0.6) Real
Application Cluster (RAC) Software on Linux (CentOS EL 4 Update 5 x86) for
ASM_HOME
By Bhavin Hingu
This document explains the step by
step process of installing Oracle 11g R1 RAC for ASM using OUI.
Start the runInstaller command as oracle user from any one node after setting the ORACLE_BASE
for this installation.
[oracle@node1-pub ~]$ export
ORACLE_BASE=/u01/app/asm
[oracle@node1-pub ~]$ 11g_database/database/runInstaller
Xlib: connection to ":0.0" refused by
server
Xlib: No protocol specified
Can't connect to X11 window server using ':0.0' as the value
of the DISPLAY variable.
If you get the above error, please execute the below command as root and
then start the runInstaller by connecting as oracle.
[root@node1-pub ~]# xhost +
access control disabled, clients can connect from any host
I got the permission errors on the below files while
executing the runInstaller. I worked around this issue by grating the execute
privilege on the below files.
chmod u+x 11g_database/database/runInstaller
chmod u+x /home/oracle/11g_database/database/install/.oui
chmod u+x /home/oracle/11g_database/database/install/unzip
chmod u+x /tmp/database/runInstaller
chmod u+x /tmp/database/install/.oui
chmod u+x /tmp/database/install/unzip
Click Next
Select "Custom" and Click Next.
Click Next
Select all the nodes and Click Next
At this step, you should not receive any error. If you have configured the
Pre-Installation steps correctly, then you will not get any errors. I get one
warning here as you can see which is complaining about the low memory than
required. I had only 512 MB ram and the required memory is 1GB but I would not
worry about this warning and will check the status box.
Click Next
Click Next
Leave the Default values (dba, dba, dba) and Click Next
Select "Configure Automatic Storage Management" and Click Next
Click Install
Execute the mentioned script on all the nodes.
Click Exit
Click Exit
ORA-00845: MEMORY_TARGET not supported on this system
MEMORY_TARGET or MEMORY_MAX_TARGET, cannot be greater than the shared memory
filesystem (/dev/shm) on your operating system.
For example, if the shared memory filesystem allocation on your system is 1 GB,
but you set Memory Size (MEMORY_TARGET) to 2 GB, then you
receive the above error during instance startup:
So, I decided to create the ASM instances manually and setting MEMORY_TARGET
init.ora parameter to 0. OK to this window and 'Cancel" the operation
to Exit out from dbca. Simply run the root.sh scripts when prompted by
next window and exit out from runInstaller. The installation is considered
successful
but I still needed to configure ASM instance manually.
CREATE ASM Instance Manually:
[oracle@node1-pub
dbs]$ orapwd file=orapw+ASM1 password=ChangeIt entries=5
[oracle@node1-pub dbs]$
[oracle@node1-pub dbs]$ cat init+ASM.ora
instance_type=asm
+ASM1.instance_name=+ASM1
+ASM2.instance_name=+ASM2
MEMORY_TARGET=0
cluster_database_instances=2
cluster_database=true
+ASM1.instance_number=1
+ASM2.instance_number=2
remote_login_passwordfile='SHARED'
SQL> create
spfile='/u02/ocfs2/asm_spfile/spfile+ASM.ora' from
pfile='/u01/app/asm/product/11gr1/dbs/init+ASM.ora';
File created.
Update the init+ASM1.ora and init=ASM2.ora to add the pointer to the spfile.
[oracle@node2-pub
dbs]$ cat init+ASM2.ora
SPFILE='/u02/ocfs2/asm_spfile/spfile+ASM.ora'
[oracle@node2-pub dbs]$
[oracle@node2-pub pfile]$ srvctl add asm -n node2-pub -i +ASM2 -o
/u01/app/asm/product/11gr1 -p /u02/ocfs2/asm_spfile/spfile+ASM.ora
[oracle@node2-pub pfile]$ srvctl enable asm -n node1-pub -i +ASM1
[oracle@node2-pub pfile]$ srvctl enable asm -n node2-pub -i +ASM2
Run the dbca again to add/create disk groups to the
ASM instance.
[oracle@node1-pub ~]$ /u01/app/asm/product/11gr1/bin/dbca
Click "Finish" to exit out from dbca.
Verify that LISTENER and ASM instances are up and running and are properly
registered with CRS.
CRS STACK STATUS AFTER THE INSTALLATION AND CONFIGURATION OF ASM
================================================================
[oracle@node2-pub
dbs]$ crs_stat -t
Name
Type Target
State Host
------------------------------------------------------------
ora....SM1.asm application ONLINE
ONLINE node1-pub
ora....UB.lsnr application ONLINE
ONLINE node1-pub
ora....pub.gsd application ONLINE
ONLINE node1-pub
ora....pub.ons application ONLINE
ONLINE node1-pub
ora....pub.vip application ONLINE
ONLINE node1-pub
ora....SM2.asm application ONLINE
ONLINE node2-pub
ora....UB.lsnr application ONLINE ONLINE
node2-pub
ora....pub.gsd application ONLINE
ONLINE node2-pub
ora....pub.ons application ONLINE
ONLINE node2-pub
ora....pub.vip application ONLINE
ONLINE node2-pub
[oracle@node2-pub dbs]$
[oracle@node1-pub ~]$ export ORACLE_HOME=/u01/app/asm/product/11gr1
[oracle@node1-pub ~]$ asmcmd
ASMCMD> ls
DATA/
FLASH/
ASMCMD> lsdg
State Type Rebal Sector
Block AU Total_MB Free_MB
Req_mir_free_MB Usable_file_MB Offline_disks Name
MOUNTED NORMAL N
512 4096 1048576 199996
199810
0
99905
0 DATA/
MOUNTED EXTERN N
512 4096 1048576 199996
199901
0
199901
0 FLASH/
ASMCMD>
Now
with the setup of ASM, next is to install the 11g R1 RAC for database home and
create a RAC database.