11G RAC安装
2014年4月18日
15:18
1.修改IP,hostname
vi /etc/hosts
192.168.6.110 pdd1
192.168.6.112 pdd1-vip
8.8.8.8 pdd1-priv
192.168.6.111 pdd2
192.168.6.113 pdd2-vip
8.8.8.9 pdd2-priv
192.168.6.114 scan_ip
[root@pdd1 ~]# vi /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=pdd1
eth0作为公网
[root@pdd1 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth0
DEVICE=eth0
BOOTPROTO=static
ONBOOT=yes
IPADDR=192.168.6.110 192.168.6.111
GATEWAY=192.168.6.1
NETMASK=255.255.255.0
eth1作为私网
[root@pdd1 ~]# vi /etc/sysconfig/network-scripts/ifcfg-eth1
DEVICE=eth1
BOOTPROTO=static
ONBOOT=yes
IPADDR=8.8.8.8 8.8.8.9
NETMASK=255.255.255.0
关闭ntpd时间同步，和sendmail
[root@pdd1 ~]# chkconfig ntpd off
[root@pdd1 ~]# mv /etc/ntp.conf /etc/ntp.conf.bak
[root@pdd1 ~]# chkconfig sendmail off
重启一下，或者手动 hostname
2.磁盘分区格式化
[root@pdd1:/root]# fdisk -l
Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 2610 20860402+ 8e Linux LVM
Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdb doesn't contain a valid partition table
Disk /dev/sdc: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdc doesn't contain a valid partition table
[root@pdd1:/root]# fdisk /dev/sdb
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
The number of cylinders for this disk is set to 2610.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-2610, default 2610):
Using default value 2610
Command (m for help): p
Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 2610 20964793+ 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@pdd1:/root]# mkfs.ext3 /dev/sdb1 格式化
mke2fs 1.39 (29-May-2006)
Filesystem label=
OS type: Linux
Block size=4096 (log=2)
Fragment size=4096 (log=2)
2621440 inodes, 5241198 blocks
262059 blocks (5.00%) reserved for the super user
First data block=0
Maximum filesystem blocks=0
160 block groups
32768 blocks per group, 32768 fragments per group
16384 inodes per group
Superblock backups stored on blocks:
32768, 98304, 163840, 229376, 294912, 819200, 884736, 1605632, 2654208,
4096000
Writing inode tables: done
Creating journal (32768 blocks): done
Writing superblocks and filesystem accounting information: done
This filesystem will be automatically checked every 20 mounts or
180 days, whichever comes first. Use tune2fs -c or -i to override.
[root@pdd1:/root]# mount /dev/sdb1 /u01 挂在磁盘
[root@pdd1:/root]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/mapper/VolGroup00-LogVol00
18G 6.1G 11G 38% /
/dev/sda1 99M 12M 82M 13% /boot
tmpfs 782M 0 782M 0% /dev/shm
/dev/sdb1 20G 173M 19G 1% /u01
[root@pdd1:/root]# vi /etc/fstab 编辑开机自动挂载
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
/dev/sdb1 /u01 ext3 defaults 0 0
3.增加交换分区
[root@pdd1:/root]# dd if=/dev/zero of=/u01/swapfile bs=1024k count=2048
2048+0 records in
2048+0 records out
2147483648 bytes (2.1 GB) copied, 5.54063 seconds, 388 MB/s
[root@pdd1:/root]# mkswap -c /u01/swapfile
Setting up swapspace version 1, size = 2147479 kB
[root@pdd1:/root]# swapon /u01/swapfile
[root@pdd1:/root]# free -m
total used free shared buffers cached
Mem: 1562 1524 37 0 11 1436
-/+ buffers/cache: 76 1485
Swap: 4095 0 4095
[root@pdd1:/root]# vi /etc/fstab 编辑开机自动挂载
/dev/VolGroup00/LogVol00 / ext3 defaults 1 1
LABEL=/boot /boot ext3 defaults 1 2
tmpfs /dev/shm tmpfs defaults 0 0
devpts /dev/pts devpts gid=5,mode=620 0 0
sysfs /sys sysfs defaults 0 0
proc /proc proc defaults 0 0
/dev/VolGroup00/LogVol01 swap swap defaults 0 0
/dev/sdb1 /u01 ext3 defaults 0 0
/u01/swapfile swap swap defaults 0 0
4.创建用户组和目录并赋权
注意在RAC环境中要保持各节点上用户组的gid一致
groupadd -g 200 oinstall
groupadd -g 201 dba
groupadd -g 202 oper
groupadd -g 203 asmadmin
groupadd -g 204 asmoper
groupadd -g 205 asmdba
useradd -u 200 -g oinstall -G dba,asmdba,oper oracle
useradd -u 201 -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
mkdir -p /u01/app/oraInventory
chown -R grid:oinstall /u01/app/oraInventory/
chmod -R 775 /u01/app/oraInventory/
mkdir -p /u01/11.2.0/grid
chown -R grid:oinstall /u01/11.2.0/grid/
chmod -R 775 /u01/11.2.0/grid/
mkdir -p /u01/app/oraInventory/
mkdir -p /u01/app/oracle
mkdir -p /u01/app/oracle/cfgtoollogs
mkdir -p /u01/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /u01/app/oracle
chmod -R 775 /u01/app/oracle
|
Oinstall ： |
oracle Inventory and Software Owner，oracle软件的所有者和清单 |
|
Dba: |
oracle database administrator,oracle数据库管理员 |
|
Oper： |
oracle Database Operator oracle database操作组 |
|
Asmadmin： |
ASM Instance Administrator（osasm) Group asm管理组 |
|
Asmdba： |
ASM Database Administrator(osdba) Group asm数据库管理dba |
|
Asmoper： |
ASM Instance operator(asmoper) asm 实例操作组 |
|
asmadmin用户组： |
该用户组具有sysasm权限，可以管理oracle clusterware和oracle asm的权限需求，如果grid用户没有asmadmin权限，将无法操作asm disk group。 |
|
asmdba用户组： |
该用户组具有读写和访问asm文件的权限，oracle用户组和GI用户都必须拥有这个权限，如果oracle用户没有asmdba权限，将无法使用asm上的文件，也就无法启动数据库。 |
|
asmoper用户组： |
该组和oper用户组类似都是额外的用户组，asmoper用户具有asm的sysoper权限，可以启动和关闭asm实例，默认情况下asmadmin用户就具有了asmoper用户组权限。 |
5.修改系统参数
[root@pdd1:/root]# vi /etc/sysctl.conf 在最后添加下面的参数
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
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
[root@pdd1:/root]# sysctl -p
[root@pdd1:/root]# vi /etc/security/limits.conf 限制用户访问的CPU和内存资源
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
[root@pdd1:/root]# vi /etc/pam.d/login linux操作系统的登陆配置文件
添加
session required /lib/security/pam_limits.so 当用户登陆以后自动启用上面的限制
[root@pdd1:/root]# vi /etc/profile
添加
if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
6.设置oracle、grid用户环境变量
节点1
su - oracle
vi .bash_profile
export EDITOR=vi
export ORACLE_SID=prod1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
su - grid
vi .bash_profile
export EDITOR=vi
export ORACLE_SID=+ASM1
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/11.2.0/grid
export GRID_HOME=/u01/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export THREADS_FLAG=native
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
节点2
su - oracle
vi .bash_profile
export EDITOR=vi
export ORACLE_SID=prod2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
su - grid
vi .bash_profile
export EDITOR=vi
export ORACLE_SID=+ASM2
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/11.2.0/grid
export GRID_HOME=/u01/11.2.0/grid
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export THREADS_FLAG=native
export PATH=$ORACLE_HOME/bin:/bin:/usr/bin:/usr/sbin:/usr/local/bin:/usr/X11R6/bin
umask 022
7.安装ASM软件
[root@pdd1:/root]# cd /soft/asm/
[root@pdd1:/soft/asm]# rpm -ivh *
warning: oracleasm-2.6.18-194.el5-2.0.5-1.el5.i686.rpm: Header V3 DSA signature: NOKEY, key ID 1e5e0159
Preparing... ########################################### [100%]
1:oracleasm-support ########################################### [ 33%]
2:oracleasm-2.6.18-194.el########################################### [ 67%]
3:oracleasmlib ########################################### [100%]
俩节点都安
8.为sharedisk分区格式化创建ASM磁盘组
用节点1
[root@pdd1 asm]# fdisk -l
Disk /dev/sda: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 14 2610 20860402+ 8e Linux LVM
Disk /dev/sdb: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 2610 20964793+ 83 Linux
Disk /dev/sdc: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Disk /dev/sdc doesn't contain a valid partition table
[root@pdd1 asm]# fdisk /dev/sdc
Device contains neither a valid DOS partition table, nor Sun, SGI or OSF disklabel
Building a new DOS disklabel. Changes will remain in memory only,
until you decide to write them. After that, of course, the previous
content won't be recoverable.
The number of cylinders for this disk is set to 2610.
There is nothing wrong with that, but this is larger than 1024,
and could in certain setups cause problems with:
1) software that runs at boot time (e.g., old versions of LILO)
2) booting and partitioning software from other OSs
(e.g., DOS FDISK, OS/2 FDISK)
Warning: invalid flag 0x0000 of partition table 4 will be corrected by w(rite)
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 1
First cylinder (1-2610, default 1):
Using default value 1
Last cylinder or +size or +sizeM or +sizeK (1-2610, default 2610): +1024m
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 2
First cylinder (126-2610, default 126):
Using default value 126
Last cylinder or +size or +sizeM or +sizeK (126-2610, default 2610): +1024m
Command (m for help): n
Command action
e extended
p primary partition (1-4)
p
Partition number (1-4): 3
First cylinder (251-2610, default 251):
Using default value 251
Last cylinder or +size or +sizeM or +sizeK (251-2610, default 2610): +1024m
Command (m for help): n
Command action
e extended
p primary partition (1-4)
e
Selected partition 4
First cylinder (376-2610, default 376):
Using default value 376
Last cylinder or +size or +sizeM or +sizeK (376-2610, default 2610):
Using default value 2610
Command (m for help): n
First cylinder (376-2610, default 376):
Using default value 376
Last cylinder or +size or +sizeM or +sizeK (376-2610, default 2610): +5g
Command (m for help): n
First cylinder (985-2610, default 985):
Using default value 985
Last cylinder or +size or +sizeM or +sizeK (985-2610, default 2610): +5g
Command (m for help): n
First cylinder (1594-2610, default 1594):
Using default value 1594
Last cylinder or +size or +sizeM or +sizeK (1594-2610, default 2610): +4g
Command (m for help): n
First cylinder (2081-2610, default 2081):
Using default value 2081
Last cylinder or +size or +sizeM or +sizeK (2081-2610, default 2610): +4g
Command (m for help): n
First cylinder (2568-2610, default 2568):
Using default value 2568
Last cylinder or +size or +sizeM or +sizeK (2568-2610, default 2610):
Using default value 2610
Command (m for help): p
Disk /dev/sdc: 21.4 GB, 21474836480 bytes
255 heads, 63 sectors/track, 2610 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdc1 1 125 1004031 83 Linux
/dev/sdc2 126 250 1004062+ 83 Linux
/dev/sdc3 251 375 1004062+ 83 Linux
/dev/sdc4 376 2610 17952637+ 5 Extended
/dev/sdc5 376 984 4891761 83 Linux
/dev/sdc6 985 1593 4891761 83 Linux
/dev/sdc7 1594 2080 3911796 83 Linux
/dev/sdc8 2081 2567 3911796 83 Linux
/dev/sdc9 2568 2610 345366 83 Linux
Command (m for help): w
The partition table has been altered!
Calling ioctl() to re-read partition table.
Syncing disks.
[root@pdd1 asm]# service oracleasm configure两个节点都要configure一下
Configuring the Oracle ASM library driver.
This will configure the on-boot properties of the Oracle ASM library
driver. The following questions will determine whether the driver is
loaded on boot and what permissions it will have. The current values
will be shown in
brackets ('[]'). Hitting
answer will keep that current value. Ctrl-C will abort.
Default user to own the driver interface []: grid
Default group to own the driver interface []: asmadmin
Start Oracle ASM library driver on boot (y/n) [n]: y
Scan for Oracle ASM disks on boot (y/n) [y]:
Writing Oracle ASM library driver configuration: done
Initializing the Oracle ASMLib driver: [ OK ]
Scanning the system for Oracle ASMLib disks: [ OK ]
创建磁盘
[root@pdd1 asm]# service oracleasm createdisk OCR_VOTE1 /dev/sdc1
Marking disk "OCR_VOTE1" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk OCR_VOTE2 /dev/sdc2
Marking disk "OCR_VOTE2" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk OCR_VOTE3 /dev/sdc3
Marking disk "OCR_VOTE3" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk ASM_DATA1 /dev/sdc5
Marking disk "ASM_DATA1" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk ASM_DATA2 /dev/sdc6
Marking disk "ASM_DATA2" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk ASM_RCY1 /dev/sdc7
Marking disk "ASM_RCY1" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm createdisk ASM_RCY2 /dev/sdc8
Marking disk "ASM_RCY2" as an ASM disk: [ OK ]
[root@pdd1 asm]# service oracleasm listdisks
ASM_DATA1
ASM_DATA2
ASM_RCY1
ASM_RCY2
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
节点2要scan一下
[root@pdd2 soft]# service oracleasm scandisks
Scanning the system for Oracle ASMLib disks: [ OK ]
[root@pdd2 soft]# service oracleasm listdisks
ASM_DATA1
ASM_DATA2
ASM_RCY1
ASM_RCY2
OCR_VOTE1
OCR_VOTE2
OCR_VOTE3
9.建立节点间oracle、grid用户间信任关系
首先在两节点用户的家目录下
mkdir .ssh
节点1
[oracle@pdd1 ~]$ mkdir .ssh
[oracle@pdd1 ~]$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_rsa.
Your public key has been saved in /home/oracle/.ssh/id_rsa.pub.
The key fingerprint is:
32:8a:e1:8c:0d:70:86:8e:88:97:5a:3a:15:fd:a3:dd oracle@pdd1
[oracle@pdd1 ~]$ ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/oracle/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/oracle/.ssh/id_dsa.
Your public key has been saved in /home/oracle/.ssh/id_dsa.pub.
The key fingerprint is:
d8:88:23:9b:6f:cd:74:81:8f:f9:13:16:98:5f:8a:8f oracle@pdd1
节点2执行相同操作
[oracle@pdd2 ~]$ mkdir .ssh
[oracle@pdd2 ~]$ ssh-keygen -t rsa
[oracle@pdd2 ~]$ ssh-keygen -t dsa
节点1
[oracle@pdd1 ~]$ cat .ssh/id_rsa.pub >> .ssh/authorized_keys
[oracle@pdd1 ~]$ cat .ssh/id_dsa.pub >> .ssh/authorized_keys
[oracle@pdd1 ~]$ ssh pdd2 cat .ssh/id_rsa.pub >> .ssh/authorized_keys 这一步是将节点2的id_rsa.pub追加写入到节点1的authorized_keys文件里
oracle@pdd2's password:
[oracle@pdd1 ~]$ ssh pdd2 cat .ssh/id_dsa.pub >> .ssh/authorized_keys
oracle@pdd2's password:
[oracle@pdd1 ~]$ scp .ssh/authorized_keys pdd2:~/.ssh 将写有节点1和节点2密码文件的authorized_keys拷贝到节点2，两边就都拥有密钥了
oracle@pdd2's password:
authorized_keys 100% 1988 1.9KB/s 00:00
验证信任关系
ssh pdd1 date
ssh pdd1-priv date
ssh pdd2 date
ssh pdd2-priv date
两个节点都要验证
grid用户步骤同上
10.建立yum软件仓库
[root@pdd1 ~]# cd /etc/yum.repos.d/
[root@pdd1 yum.repos.d]# ls
rhel-debuginfo.repo
[root@pdd1 yum.repos.d]# cp rhel-debuginfo.repo yum.repo
[root@pdd1 yum.repos.d]# vi yum.repo
清空内容写入
[Base]
name=Red Hat Enterprise Linux
baseurl=file:///media/Server
enabled=1
gpgcheck=0
gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-redhat-release
[root@pdd1 yum.repos.d]# scp yum.repo pdd2:/etc/yum.repos.d
root@pdd2's password:
yum.repo 100% 146 0.1KB/s 00:00
挂载光盘
mount /dev/cdrom /media/
11.校验安装环境
首先解压grid软件包
然后以grid用户校验
[root@pdd1 grid]# su - grid
[grid@pdd1 ~]$ cd /soft/grid/
[grid@pdd1 grid]$ ls
doc install response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
[grid@pdd1 grid]$ ./runcluvfy.sh stage -pre crsinst -n pdd1,pdd2 -fixup -verbose
然后安装缺失的软件，两个节点都要安！
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "pdd1"
Destination Node Reachable?
------------------------------------ ------------------------
pdd2 yes
pdd1 yes
Result: Node reachability check passed from node "pdd1"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Comment
------------------------------------ ------------------------
pdd2 passed
pdd1 passed
Result: User equivalence check passed for user "grid"
Checking node connectivity...
Checking hosts config file...
Node Name Status Comment
------------ ------------------------ ------------------------
pdd2 passed
pdd1 passed
Verification of the hosts config file successful
Interface information for node "pdd2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.6.111 192.168.6.0 0.0.0.0 192.168.6.1 08:00:27:FA:0A:B3 1500
eth1 8.8.8.9 8.8.8.0 0.0.0.0 192.168.6.1 08:00:27:F8:0B:47 1500
Interface information for node "pdd1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.6.110 192.168.6.0 0.0.0.0 192.168.6.1 08:00:27:AF:18:71 1500
eth1 8.8.8.8 8.8.8.0 0.0.0.0 192.168.6.1 08:00:27:41:C7:24 1500
Check: Node connectivity of subnet "192.168.6.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
pdd2:eth0 pdd1:eth0 yes
Result: Node connectivity passed for subnet "192.168.6.0" with node(s) pdd2,pdd1
Check: TCP connectivity of subnet "192.168.6.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
pdd1:192.168.6.110 pdd2:192.168.6.111 passed
Result: TCP connectivity check passed for subnet "192.168.6.0"
Check: Node connectivity of subnet "8.8.8.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
pdd2:eth1 pdd1:eth1 yes
Result: Node connectivity passed for subnet "8.8.8.0" with node(s) pdd2,pdd1
Check: TCP connectivity of subnet "8.8.8.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
pdd1:8.8.8.8 pdd2:8.8.8.9 passed
Result: TCP connectivity check passed for subnet "8.8.8.0"
Interfaces found on subnet "192.168.6.0" that are likely candidates for VIP are:
pdd2 eth0:192.168.6.111
pdd1 eth0:192.168.6.110
Interfaces found on subnet "8.8.8.0" that are likely candidates for VIP are:
pdd2 eth1:8.8.8.9
pdd1 eth1:8.8.8.8
WARNING:
Could not find a suitable set of interfaces for the private interconnect
Result: Node connectivity check passed
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 1.53GB (1599992.0KB) 1.5GB (1572864.0KB) passed
pdd1 1.53GB (1599992.0KB) 1.5GB (1572864.0KB) passed
Result: Total memory check passed
Check: Available memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 1.44GB (1508400.0KB) 50MB (51200.0KB) passed
pdd1 1.41GB (1478396.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 4GB (4194288.0KB) 2.29GB (2399988.0KB) passed
pdd1 4GB (4194288.0KB) 2.29GB (2399988.0KB) passed
Result: Swap space check passed
Check: Free disk space for "pdd2:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp pdd2 / 2.5GB 1GB passed
Result: Free disk space check passed for "pdd2:/tmp"
Check: Free disk space for "pdd1:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp pdd1 / 9.78GB 1GB passed
Result: Free disk space check passed for "pdd1:/tmp"
Check: User existence for "grid"
Node Name Status Comment
------------ ------------------------ ------------------------
pdd2 exists passed
pdd1 exists passed
Result: User existence check passed for "grid"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
pdd2 exists passed
pdd1 exists passed
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
pdd2 exists passed
pdd1 exists passed
Result: Group existence check passed for "dba"
Check: Membership of user "grid" in group "oinstall" [as Primary]
Node Name User Exists Group Exists User in Group Primary Comment
---------------- ------------ ------------ ------------ ------------ ------------
pdd2 yes yes yes yes passed
pdd1 yes yes yes yes passed
Result: Membership check for user "grid" in group "oinstall" [as Primary] passed
Check: Membership of user "grid" in group "dba"
Node Name User Exists Group Exists User in Group Comment
---------------- ------------ ------------ ------------ ----------------
pdd2 yes yes yes passed
pdd1 yes yes yes passed
Result: Membership check for user "grid" in group "dba" passed
Check: Run level
Node Name run level Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 5 3,5 passed
pdd1 5 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
pdd2 hard 65536 65536 passed
pdd1 hard 65536 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
pdd2 soft 1024 1024 passed
pdd1 soft 1024 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
pdd2 hard 16384 16384 passed
pdd1 hard 16384 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
pdd2 soft 2047 2047 passed
pdd1 soft 2047 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 i686 x86 passed
pdd1 i686 x86 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 2.6.18-194.el5 2.6.18 passed
pdd1 2.6.18-194.el5 2.6.18 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 250 250 passed
pdd1 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 32000 32000 passed
pdd1 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 100 100 passed
pdd1 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 128 128 passed
pdd1 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 536870912 536870912 passed
pdd1 536870912 536870912 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 4096 4096 passed
pdd1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 2097152 2097152 passed
pdd1 2097152 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 6815744 6815744 passed
pdd1 6815744 6815744 passed
Result: Kernel parameter check passed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 between 9000 & 65500 between 9000 & 65500 passed
pdd1 between 9000 & 65500 between 9000 & 65500 passed
Result: Kernel parameter check passed for "ip_local_port_range"
Check: Kernel parameter for "rmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 262144 262144 passed
pdd1 262144 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 4194304 4194304 passed
pdd1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 262144 262144 passed
pdd1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 1048586 1048576 passed
pdd1 1048586 1048576 passed
Result: Kernel parameter check passed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 1048576 1048576 passed
pdd1 1048576 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "make-3.81"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 make-3.81-3.el5 make-3.81 passed
pdd1 make-3.81-3.el5 make-3.81 passed
Result: Package existence check passed for "make-3.81"
Check: Package existence for "binutils-2.17.50.0.6"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 binutils-2.17.50.0.6-14.el5 binutils-2.17.50.0.6 passed
pdd1 binutils-2.17.50.0.6-14.el5 binutils-2.17.50.0.6 passed
Result: Package existence check passed for "binutils-2.17.50.0.6"
Check: Package existence for "gcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 gcc-4.1.2-48.el5 gcc-4.1.2 passed
pdd1 gcc-4.1.2-48.el5 gcc-4.1.2 passed
Result: Package existence check passed for "gcc-4.1.2"
Check: Package existence for "gcc-c++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 gcc-c++-4.1.2-48.el5 gcc-c++-4.1.2 passed
pdd1 gcc-c++-4.1.2-48.el5 gcc-c++-4.1.2 passed
Result: Package existence check passed for "gcc-c++-4.1.2"
Check: Package existence for "libgomp-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
pdd1 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
Result: Package existence check passed for "libgomp-4.1.2"
Check: Package existence for "libaio-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 libaio-0.3.106-5 libaio-0.3.106 passed
pdd1 libaio-0.3.106-5 libaio-0.3.106 passed
Result: Package existence check passed for "libaio-0.3.106"
Check: Package existence for "glibc-2.5-24"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 glibc-2.5-49 glibc-2.5-24 passed
pdd1 glibc-2.5-49 glibc-2.5-24 passed
Result: Package existence check passed for "glibc-2.5-24"
Check: Package existence for "compat-libstdc++-33-3.2.3"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
pdd1 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
Result: Package existence check passed for "compat-libstdc++-33-3.2.3"
Check: Package existence for "elfutils-libelf-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
pdd1 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
Result: Package existence check passed for "elfutils-libelf-0.125"
Check: Package existence for "elfutils-libelf-devel-0.125"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
pdd1 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
Result: Package existence check passed for "elfutils-libelf-devel-0.125"
Check: Package existence for "glibc-common-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 glibc-common-2.5-49 glibc-common-2.5 passed
pdd1 glibc-common-2.5-49 glibc-common-2.5 passed
Result: Package existence check passed for "glibc-common-2.5"
Check: Package existence for "glibc-devel-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 glibc-devel-2.5-49 glibc-devel-2.5 passed
pdd1 glibc-devel-2.5-49 glibc-devel-2.5 passed
Result: Package existence check passed for "glibc-devel-2.5"
Check: Package existence for "glibc-headers-2.5"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 glibc-headers-2.5-49 glibc-headers-2.5 passed
pdd1 glibc-headers-2.5-49 glibc-headers-2.5 passed
Result: Package existence check passed for "glibc-headers-2.5"
Check: Package existence for "libaio-devel-0.3.106"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 missing libaio-devel-0.3.106 failed
pdd1 missing libaio-devel-0.3.106 failed
Result: Package existence check failed for "libaio-devel-0.3.106"
Check: Package existence for "libgcc-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 libgcc-4.1.2-48.el5 libgcc-4.1.2 passed
pdd1 libgcc-4.1.2-48.el5 libgcc-4.1.2 passed
Result: Package existence check passed for "libgcc-4.1.2"
Check: Package existence for "libstdc++-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 libstdc++-4.1.2-48.el5 libstdc++-4.1.2 passed
pdd1 libstdc++-4.1.2-48.el5 libstdc++-4.1.2 passed
Result: Package existence check passed for "libstdc++-4.1.2"
Check: Package existence for "libstdc++-devel-4.1.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 libstdc++-devel-4.1.2-48.el5 libstdc++-devel-4.1.2 passed
pdd1 libstdc++-devel-4.1.2-48.el5 libstdc++-devel-4.1.2 passed
Result: Package existence check passed for "libstdc++-devel-4.1.2"
Check: Package existence for "sysstat-7.0.2"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 missing sysstat-7.0.2 failed
pdd1 missing sysstat-7.0.2 failed
Result: Package existence check failed for "sysstat-7.0.2"
Check: Package existence for "unixODBC-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 missing unixODBC-2.2.11 failed
pdd1 missing unixODBC-2.2.11 failed
Result: Package existence check failed for "unixODBC-2.2.11"
Check: Package existence for "unixODBC-devel-2.2.11"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 missing unixODBC-devel-2.2.11 failed
pdd1 missing unixODBC-devel-2.2.11 failed
Result: Package existence check failed for "unixODBC-devel-2.2.11"
Check: Package existence for "ksh-20060214"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 ksh-20100202-1.el5 ksh-20060214 passed
pdd1 ksh-20100202-1.el5 ksh-20060214 passed
Result: Package existence check passed for "ksh-20060214"
Checking for multiple users with UID value 0
Result: Check for multiple users with UID value 0 passed
Check: Current group ID
Result: Current group ID check passed
Checking Core file name pattern consistency...
Core file name pattern consistency check passed.
Checking to make sure user "grid" is not in "root" group
Node Name Status Comment
------------ ------------------------ ------------------------
pdd2 does not exist passed
pdd1 does not exist passed
Result: User "grid" is not part of "root" group. Check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
pdd2 0022 0022 passed
pdd1 0022 0022 passed
Result: Default user file creation mask check passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
Network Time Protocol(NTP) configuration file not found on any of the nodes. Oracle Cluster Time Synchronization Service(CTSS) can be used instead of NTP for time synchronization on the cluster nodes
Result: Clock synchronization check using Network Time Protocol(NTP) passed
Pre-check for cluster services setup was unsuccessful on all the nodes.
安装缺失的软件包(两个节点都要装！)
[grid@pdd1 grid]$ su -
Password:
[root@pdd1 ~]# yum install unixODBC* -y
[root@pdd1 ~]# yum install systat* -y
[root@pdd1 ~]# yum install libaio* -y
重新校验，通过
至此准备工作结束
12.安装grid软件，一grid用户
屏幕剪辑的捕获时间: 2014/4/19 18:38
屏幕剪辑的捕获时间: 2014/4/19 18:39
屏幕剪辑的捕获时间: 2014/4/19 18:39
屏幕剪辑的捕获时间: 2014/4/19 18:39
屏幕剪辑的捕获时间: 2014/4/19 18:39
屏幕剪辑的捕获时间: 2014/4/19 18:40
屏幕剪辑的捕获时间: 2014/4/19 18:43
屏幕剪辑的捕获时间: 2014/4/19 18:43
屏幕剪辑的捕获时间: 2014/4/19 18:43
屏幕剪辑的捕获时间: 2014/4/19 18:43
选择第二个设置密码，这里提示密码过于简单，不用管，yes
屏幕剪辑的捕获时间: 2014/4/19 18:44
屏幕剪辑的捕获时间: 2014/4/19 18:44
屏幕剪辑的捕获时间: 2014/4/19 18:44
屏幕剪辑的捕获时间: 2014/4/19 18:46
屏幕剪辑的捕获时间: 2014/4/19 18:48
点击finish开始安装
屏幕剪辑的捕获时间: 2014/4/19 19:00
这里提示以ROOT用户跑两个脚本
注意两个节点要按顺序跑完第一个脚本，再按顺序跑完第二个脚本，不可同时跑脚本
pdd1 sh /u01/app/oraInventory/orainstRoot.sh
pdd2 sh /u01/app/oraInventory/orainstRoot.sh
pdd1 sh /u01/11.2.0/grid/root.sh
pdd2 sh /u01/11.2.0/grid/root.sh
屏幕剪辑的捕获时间: 2014/4/19 19:16
这里报了两个错误不用理会
安装结束
在root用户的/etc/profile中添加
export PATH=$PATH:/u01/11.2.0/grid/bin
以使用下面两条命令
[root@fan1 oracleasm]# crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[root@fan1 oracleasm]# crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora....ER.lsnr ora....er.type ONLINE ONLINE fan1
ora....N1.lsnr ora....er.type ONLINE ONLINE fan1
ora....VOTE.dg ora....up.type ONLINE ONLINE fan1
ora.asm ora.asm.type ONLINE ONLINE fan1
ora.eons ora.eons.type ONLINE ONLINE fan1
ora....SM1.asm application ONLINE ONLINE fan1
ora....N1.lsnr application ONLINE ONLINE fan1
ora.fan1.gsd application OFFLINE OFFLINE
ora.fan1.ons application ONLINE ONLINE fan1
ora.fan1.vip ora....t1.type ONLINE ONLINE fan1
ora....SM2.asm application ONLINE ONLINE fan2
ora....N2.lsnr application ONLINE ONLINE fan2
ora.fan2.gsd application OFFLINE OFFLINE
ora.fan2.ons application ONLINE ONLINE fan2
ora.fan2.vip ora....t1.type ONLINE ONLINE fan2
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE fan1
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE fan1
ora....ry.acfs ora....fs.type ONLINE ONLINE fan1
ora.scan1.vip ora....ip.type ONLINE ONLINE fan1
13.建立磁盘组（放数据库的）
grid用户
[grid@pdd1 ~]$ asmca
屏幕剪辑的捕获时间: 2014/4/19 19:22
点击create
屏幕剪辑的捕获时间: 2014/4/19 19:22
ok
屏幕剪辑的捕获时间: 2014/4/19 19:22
继续create
屏幕剪辑的捕获时间: 2014/4/19 19:23
屏幕剪辑的捕获时间: 2014/4/19 19:23
mount all
屏幕剪辑的捕获时间: 2014/4/19 19:24
完事退出
14.安装ORACLE软件
oracle软件这里就不截图了，这张是脚本的截图
屏幕剪辑的捕获时间: 2014/4/19 20:05
15.DBCA建库
屏幕剪辑的捕获时间: 2014/4/19 20:06
屏幕剪辑的捕获时间: 2014/4/19 20:07
select all
屏幕剪辑的捕获时间: 2014/4/19 20:08
屏幕剪辑的捕获时间: 2014/4/19 20:10
屏幕剪辑的捕获时间: 2014/4/19 20:10
之后就开始安装了
安完就可以完事了
11G RAC安装.pdf
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/29492784/viewspace-1145589/ ，如需转载，请注明出处，否则将追究法律责任。
