Oracle11g-rac Installation Deployment

On-line 11g RAC installation documentation is mostly not detailed, today comes a detailed!

Pure operation of the document, do not like to spray!!

Environment:

System: rhel5.5

oracle:11.2.03

Dual NIC

Shared disk

IP address and host name planning:

#节点1 Host Name: Rac1

#节点2 Host Name: RAC2

192.168.56.11 Rac1
192.168.56.22 RAC2
10.10.10.11 Rac1priv
10.10.10.22 Rac2priv
192.168.56.123 RAC1VIP
192.168.56.124 RAC2VIP
192.168.56.125 Racscanip

Operating system basic Environment configuration:

1. Configure the Yum Source:

Mount/dev/cdrom/mnt

Cat/etc/yum.repos.d/yum.repo
[Server]
Name=server
Baseurl=file:///mnt/server
Gpgcheck=0
Enable=1

2. Install the dependent package:

Yum install-y binutils compat-libstdc++-33 elfutils-libelf elfutils-libelf-devel \
GCC gcc-c++ glibc glibc-common glibc-devel glibc-headers ksh libaio \
Libaio-devel LIBGCC libstdc++ libstdc++-devel make Sysstat UnixODBC unixodbc-devel

3. Configure the Hosts file:

Cat/etc/hosts

192.168.56.11 Rac1
192.168.56.22 RAC2
10.10.10.11 Rac1priv
10.10.10.22 Rac2priv
192.168.56.123 RAC1VIP
192.168.56.124 RAC2VIP
192.168.56.125 Racscanip

4, modify the system parameters:

modifying system parameters
Vi/etc/sysctl.conf
FS.AIO-MAX-NR = 1048576
Fs.file-max = 6815744
Kernel.shmall = 2097152
Kernel.shmmax = 636870912
Kernel.shmmni = 4096
Kernel.sem = 250 32000 100 128
Net.ipv4.ip_local_port_range = 9000 65500
Net.core.rmem_default = 262144
Net.core.rmem_max = 4194304
Net.core.wmem_default = 262144
Net.core.wmem_max = 1048586

Sysctl-p

5. Modify User Resource limits:

Vim/etc/security/limits.conf
Oracle Soft Nproc 2047
Oracle Hard Nproc 16384
Oracle Soft Nofile 1024
Oracle Hard Nofile 65536
Grid Soft Nproc 2047
Grid hard Nproc 16384
Grid Soft Nofile 1024
Grid hard Nofile 65536

Vim/etc/profile
if [$USER = "Oracle"]; Then
if [$SHELL = "/bin/ksh"]; Then
Ulimit-p 16384
Ulimit-n 65536
Else
Ulimit-u 16384-n 65536
Fi
Fi

6. Create user

Groupadd-g Oinstall
GROUPADD-G 1100 Asmadmin
Groupadd-g DBA
Groupadd-g 1300 ASMDBA
Groupadd-g 1301 Asmoper
Useradd-u 1100-g oinstall-g asmadmin,asmdba,asmoper-d/home/grid grid
Useradd-u 1101-g oinstall-g dba,asmdba-d/home/oracle Oracle

echo Grid | passwd--stdin Grid
echo Oracle | passwd--stdin Oracle

7. Create a directory:

Mkdir-p/oracle/app/orainventory
Chown-r grid:oinstall/oracle/app/orainventory
Chmod-r 775/oracle/app/orainventory

Mkdir-p/oracle/11.2.0/grid
Mkdir-p/oracle/app/grid
Chown-r Grid:oinstall/oracle/app/grid
Chown-r Grid:oinstall/oracle/11.2.0/grid
Chmod-r 775/oracle/11.2.0/grid

Mkdir-p/oracle/app/oracle
Mkdir/oracle/app/oracle/cfgtoollogs
Chown-r oracle:oinstall/oracle/app/oracle
Chmod-r 775/oracle/app/oracle

Mkdir-p/oracle/app/oracle/product/11.2.0/db_1
Chown-r oracle:oinstall/oracle/app/oracle/product/11.2.0/db_1
Chmod-r 775/oracle/app/oracle/product/11.2.0/db_1

8. Set User Environment variables:

Su-grid
VI. bash_profile
Export ORACLE_SID=+ASM1 #另外一边是export oracle_sid=+asm2
Export Oracle_base=/oracle/app/grid
Export Oracle_home=/oracle/11.2.0/grid
Export path= $ORACLE _home/bin: $PATH

Su-oracle
Vim. Bash_profile
Export ORACLE_SID=RACDB1 #另外一边是 Export ORACLE_SID=RACDB2
Export Oracle_base=/oracle/app/oracle
Export Oracle_home= $ORACLE _base/product/11.2.0/db_1
Export path= $ORACLE _home/bin: $PATH

9, Decompression grid software: (Cluster software)

10, root user execution (configure mutual trust)
/software/grid/sshsetup/sshusersetup.sh-user grid-hosts "Rac1 rac2"-advanced-nopromptpassphrase
/software/grid/sshsetup/sshusersetup.sh-user oracle-hosts "Rac1 rac2"-advanced-nopromptpassphrase

Test trust:

Rac1 and RAC2
Su-grid
SSH Rac1 Date
SSH RAC2 Date
SSH Rac1priv Date
SSH Rac2priv Date

Su-oracle
SSH Rac1 Date
SSH RAC2 Date
SSH Rac1priv Date
SSH Rac2priv Date

11. Configure the bare device:

Vim/etc/udev/rules.d/60-raw.rules
action== "Add", kernel== "sdb1", run+= "/bin/raw/dev/raw/raw1%N"
action== "Add", kernel== "Sdb2", run+= "/bin/raw/dev/raw/raw2%N"
action== "Add", kernel== "raw*", owner= "grid", group= "Asmadmin", mode= "660"

Start_udev
Partprobe
Ls-l/dev/raw

To this basic environment configuration complete!

To install the cluster software:

Grid user

[Email protected] grid]$./runinstaller

#先跑完脚本再点OK

To this cluster software installation is complete!

To install the database software:

Using Oracle Users

[Email protected] database]$./runinstaller

Oracle official data explains. This GSD is used on the 9.2 library, if there is no 9.2 library, the service can be offline.

5.3.4 enabling the Global Services Daemon (GSD) for Oracle Database Release 9.2
By default, the Global Services Daemon (GSD) is disabled. If you install the Oracle Database 9i Release 2 (9.2) on the Oracle Grid Infrastructure for a Cluster 11g Release 2 (11.2), th En you must enable the GSD. Use the following commands-to-enable the GSD before you install Oracle Database Release 9.2:

To this database software installation is complete!

To create an ASM disk:

Using a grid user

[Email protected] ~]$ ASMCA

To create a database:

Using Oracle Users

Resources are all OK

This data is also built to complete!

Oracle11g-rac Installation Deployment