文件安装包:
地址:http://www.oracle.com/technetwork/products/clusterware/downloads/index.html
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html
安装REDHAT(本地磁盘空间25G)
[oracle@node1 oracle]$ df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 8.0G 6.2G 1.5G 82% /
/dev/sda2 15G 6.7G 6.8G 50% /u01
/dev/sda1 99M 14M 80M 15% /boot
tmpfs 1.5G 638M 863M 43% /dev/shm
安装VMTool,关闭sendmail。
IP规划:
#public ip
#public
192.168.204.208 node1
192.168.204.209 node2
#private
192.168.101.101 node1-priv
192.168.101.102 node2-priv
#vip
192.168.204.210 node1-vip
192.168.204.211 node2-vip
#scan
192.168.204.212 scan-ip
[root@node1 ~]# cat /etc/sysconfig/network
NETWORKING=yes
NETWORKING_IPV6=no
HOSTNAME=node1
GATEWAY=192.168.204.2
磁盘规划:
+CRS 三个1G的盘;
+DATA 4个5G的盘
添加共享磁盘,使用workstat添加,vmplayer添加磁盘时没有Independent选项
修改虚拟机配置:
首先到虚拟机工作目录,打开.vmx文件,添加一下内容:
disk.locking = "false"
diskLib.dataCacheMaxsize = "0"
diskLib.dataCacheMaxReadAheadSize = "0"
diskLib.dataCacheMinReadAheadSize = "0"
diskLib.dataCachePageSize = "4096"
diskLib.maxUnsyncedWrites = "0"
scsi0:1.deviceType = "disk"
scsi0:2.deviceType = "disk"
scsi0:3.deviceType = "disk"
scsi0:4.deviceType = "disk"
scsi0:5.deviceType = "disk"
scsi0:6.deviceType = "disk"
scsi0:8.deviceType = "disk"
scsi0:9.deviceType = "disk"
添加用户:
[root@node1 ~]# groupadd -g 501 oinstall
[root@node1 ~]# groupadd -g 502 dba
[root@node1 ~]# groupadd -g 503 oper
[root@node1 ~]# groupadd -g 504 asmadmin
[root@node1 ~]# groupadd -g 505 asmoper
[root@node1 ~]# groupadd -g 506 asmdba
[root@node1 ~]# useradd -g oinstall -G dba,asmdba,oper oracle
[root@node1 ~]# useradd -g oinstall -G asmadmin,asmdba,asmoper,oper,dba grid
[root@node1 ~]# id oracle
uid=500(oracle) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),506(asmdba)
[root@node1 ~]# id grid
uid=501(grid) gid=501(oinstall) groups=501(oinstall),502(dba),503(oper),504(asmadmin),505(asmoper),506(asmdba)
修改用户密码:
[root@node1 app]# passwd grid
Changing password for user grid.
New UNIX password:
BAD PASSWORD: it is too short
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
[root@node1 app]# passwd oracle
Changing password for user oracle.
New UNIX password:
BAD PASSWORD: it is based on a dictionary word
Retype new UNIX password:
passwd: all authentication tokens updated successfully.
创建目录:
[root@node1 ~]# mkdir -p /u01/app/{oraInventory,grid,oracle}
[root@node1 ~]# chown -R grid:oinstall /u01/app/grid
[root@node1 ~]# chown -R oracle:oinstall /u01/app/oracle
[root@node1 ~]# chown -R grid:oinstall /u01/app/oraInventory
修改系统参数:
Vim /etc/security/limits.conf
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid soft nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
[root@node1 app]# vim /etc/sysctl.conf
[root@node1 app]# sysctl –p
net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 4294967295
kernel.shmall = 268435456
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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
#关闭linux时间同步服务:
[root@node1 app]# service ntpd stop
Shutting down ntpd: [FAILED]
[root@node1 app]# chkconfig ntpd off
[root@node1 app]# mv /etc/ntp.conf /etc/ntp.conf_bak
/dev/shm共享内存不足的处理:
[root@node1 app]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 8.0G 3.0G 4.7G 40% /
/dev/sda2 15G 165M 14G 2% /u01
/dev/sda1 99M 12M 83M 12% /boot
tmpfs 506M 0 506M 0% /dev/shm
修改/etc/fstab 添加size=1024m
[root@node1 app]# cat /etc/fstab |grep tmpfs
tmpfs /dev/shm tmpfs defaults,size=1024m 0 0
重新mount /dev/shm使之生效:
# mount -o remount /dev/shm
[root@node1 app]# df -h
Filesystem Size Used Avail Use% Mounted on
/dev/sda3 8.0G 3.0G 4.7G 40% /
/dev/sda2 15G 165M 14G 2% /u01
/dev/sda1 99M 12M 83M 12% /boot
tmpfs 1.0G 0 1.0G 0% /dev/shm
修改用户的.bash_profile文件:
[grid@node1 ~]$ vim .bash_profile
[grid@node1 ~]$ source .bash_profile
[grid@node1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_SID=+ASM1;export ORACLE_SID
ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
ORACLE_HOME=/u01/app/grid/product/11.2.0; export ORACLE_HOME
NLS_DATA_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATA_FORMAT
PATH=$ORACLE_HOME/bin:$PATH
export PATH
[oracle@node1 ~]$ vim .bash_profile
[oracle@node1 ~]$ source .bash_profile
[oracle@node1 ~]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
PATH=$PATH:$HOME/bin
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_SID=bule1;export ORACLE_SID
ORACLE_BASE=/u01/app/oracle;export ORACLE_BASE
ORACLE_HOME=/u01/app/oracle/product/11.2.0; export ORACLE_HOME
NLS_DATA_FORMAT="yyyy-mm-dd HH24:MI:SS"; export NLS_DATA_FORMAT
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK; export NLS_LANG
PATH=$ORACLE_HOME/bin:$PATH:/usr/sbin
export PATH
格式化硬盘:
Fdisk /dev/sdb n p 1 w
Partprobe
[root@node1 ~]# fdisk -l
Disk /dev/sda: 26.8 GB, 26843545600 bytes
255 heads, 63 sectors/track, 3263 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sda1 * 1 13 104391 83 Linux
/dev/sda2 1352 3263 15358140 83 Linux
/dev/sda3 14 1090 8651002+ 83 Linux
/dev/sda4 1091 1351 2096482+ 5 Extended
/dev/sda5 1091 1351 2096451 82 Linux swap / Solaris
Partition table entries are not in disk order
Disk /dev/sdb: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdb1 1 130 1044193+ 83 Linux
Disk /dev/sdc: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdc1 1 130 1044193+ 83 Linux
Disk /dev/sdd: 1073 MB, 1073741824 bytes
255 heads, 63 sectors/track, 130 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdd1 1 130 1044193+ 83 Linux
Disk /dev/sde: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sde1 1 652 5237158+ 83 Linux
Disk /dev/sdf: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdf1 1 652 5237158+ 83 Linux
Disk /dev/sdg: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdg1 1 652 5237158+ 83 Linux
Disk /dev/sdh: 5368 MB, 5368709120 bytes
255 heads, 63 sectors/track, 652 cylinders
Units = cylinders of 16065 * 512 = 8225280 bytes
Device Boot Start End Blocks Id System
/dev/sdh1 1 652 5237158+ 83 Linux
配置裸设备:
[root@node1 rules.d]# start_udev
Starting udev: [ OK ]
[root@node1 rules.d]# raw -qa
/dev/raw/raw1: bound to major 8, minor 17
/dev/raw/raw2: bound to major 8, minor 33
/dev/raw/raw3: bound to major 8, minor 49
/dev/raw/raw4: bound to major 8, minor 65
/dev/raw/raw5: bound to major 8, minor 81
/dev/raw/raw6: bound to major 8, minor 97
/dev/raw/raw7: bound to major 8, minor 113
[root@node1 rules.d]# ls -l /dev/raw
total 0
crw------- 1 oracle oinstall 162, 1 Apr 11 15:13 raw1
crw------- 1 oracle oinstall 162, 2 Apr 11 15:13 raw2
crw------- 1 oracle oinstall 162, 3 Apr 11 15:13 raw3
crw------- 1 oracle oinstall 162, 4 Apr 11 15:13 raw4
crw------- 1 oracle oinstall 162, 5 Apr 11 15:13 raw5
crw------- 1 oracle oinstall 162, 6 Apr 11 15:13 raw6
crw------- 1 oracle oinstall 162, 7 Apr 11 15:13 raw7
[root@node1 rules.d]# cat 60-raw.rules
# Enter raw device bindings here.
#
# An example would be:
# ACTION=="add", KERNEL=="sda", RUN+="/bin/raw /dev/raw/raw1 %N"
# to bind /dev/raw/raw1 to /dev/sda, or
# ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="1", RUN+="/bin/raw /dev/raw/raw2 %M %m"
#a to bind /dev/raw/raw2 to the device with major 8, minor 1.
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="17", RUN+="/bin/raw /dev/raw/raw1 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="33", RUN+="/bin/raw /dev/raw/raw2 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="49", RUN+="/bin/raw /dev/raw/raw3 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="65", RUN+="/bin/raw /dev/raw/raw4 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="81", RUN+="/bin/raw /dev/raw/raw5 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="97", RUN+="/bin/raw /dev/raw/raw6 %M %m"
ACTION=="add", ENV{MAJOR}=="8", ENV{MINOR}=="113", RUN+="/bin/raw /dev/raw/raw7 %M %m"
ACTION=="add",KERNEL=="raw[1-7]",OWNER="oracle",GROUP="oinstall",MODE=”0660”
生成节点2:
拷贝文件或者workstation的full clone(full clone会将共享磁盘拷贝入内,full clone完毕后在节点2中删除这些共享磁盘文件,在启动节点2时,会提示重新找寻这些磁盘的路径,指定到节点1目录。)
修改IP(/etc/sysconfig/network-script/),节点名字(/etc/sysconfig/network)
修改/etc/hosts 将127.0.0.1 修改为node2
配置节点互信:(使用grid,oracle分别配置)
主实施节点:
[root@node2 app]# su - oracle
[oracle@node2 ~]$ mkdir .ssh
[oracle@node2 ~]$ cd .ssh
[oracle@node2 .ssh]$ 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:
a6:c6:3d:b3:0c:e0:7e:c0:e7:3a:de:ad:df:29:3d:a1 oracle@node2
[oracle@node2 .ssh]$ 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:
7b:7a:d8:ec:24:da:2e:d8:82:11:2a:52:25:9f:14:03 oracle@node2
[oracle@node2 .ssh]$ ls
id_dsa id_dsa.pub id_rsa id_rsa.pub
[oracle@node2 .ssh]$ cat id_rsa.pub >> authorized_keys
[oracle@node2 .ssh]$ cat id_dsa.pub >> authorized_keys
从实施节点:
[root@node1 ~]# su - oracle
[oracle@node1 ~]$ mkdir .ssh
[oracle@node1 ~]$ ls
[oracle@node1 ~]$ 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:
45:01:d5:26:c0:ff:57:55:28:67:ce:6b:96:9a:48:a4 oracle@node1
[oracle@node1 ~]$ 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:
a0:23:f8:c5:72:48:2e:cf:c6:bc:98:a4:d0:ce:6e:5c oracle@node1
主实施节点:
[oracle@node2 .ssh]$ ssh node1 cat ~/.ssh/id_rsa.pub >>authorized_keys
The authenticity of host 'node1 (192.168.204.208)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node1,192.168.204.208' (RSA) to the list of known hosts.
oracle@node1's password:
[oracle@node2 .ssh]$ ssh node1 cat ~/.ssh/id_dsa.pub >>authorized_keys
oracle@node1's password:
[oracle@node2 .ssh]$ scp authorized_keys node1:~/.ssh/authorized_keys
oracle@node1's password:
authorized_keys 100% 1992 2.0KB/s 00:00
主实施节点测试互信:
[oracle@node2 .ssh]$ ssh node1 date
Thu Apr 11 16:02:41 CST 2013
[oracle@node2 .ssh]$ ssh node2 date
The authenticity of host 'node2 (192.168.204.209)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node2,192.168.204.209' (RSA) to the list of known hosts.
Thu Apr 11 16:02:46 CST 2013
[oracle@node2 .ssh]$ ssh node1-priv date
The authenticity of host 'node1-priv (192.168.101.101)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node1-priv,192.168.101.101' (RSA) to the list of known hosts.
Thu Apr 11 16:02:55 CST 2013
[oracle@node2 .ssh]$ ssh node2-priv date
The authenticity of host 'node2-priv (192.168.101.102)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node2-priv,192.168.101.102' (RSA) to the list of known hosts.
从实施节点测试互信:
[oracle@node1 ~]$ ssh node1 date
The authenticity of host 'node1 (127.0.0.1)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node1' (RSA) to the list of known hosts.
Thu Apr 11 16:03:23 CST 2013
[oracle@node1 ~]$ ssh node2 date
The authenticity of host 'node2 (192.168.204.209)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node2,192.168.204.209' (RSA) to the list of known hosts.
Thu Apr 11 16:03:28 CST 2013
[oracle@node1 ~]$ ssh node1-priv
The authenticity of host 'node1-priv (192.168.101.101)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node1-priv,192.168.101.101' (RSA) to the list of known hosts.
[oracle@node1 ~]$ ssh node1-priv date
Thu Apr 11 16:03:44 CST 2013
[oracle@node1 ~]$ ssh node2-priv date
The authenticity of host 'node2-priv (192.168.101.102)' can't be established.
RSA key fingerprint is 69:dc:b9:40:f5:fa:fe:75:4f:cb:2c:52:86:7f:ec:8b.
Are you sure you want to continue connecting (yes/no)? yes
Warning: Permanently added 'node2-priv,192.168.101.102' (RSA) to the list of known hosts.
Thu Apr 11 16:03:49 CST 2013
安装GRID:
[grid@node1 ~]$ cd grid/
[grid@node1 grid]$ ls
doc install response rpm runcluvfy.sh runInstaller sshsetup stage welcome.html
装前脚本检查:
[grid@node1 grid]$ ./runcluvfy.sh stage -pre crsinst -n node1,node2 -fixup –verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "node1"
Destination Node Reachable?
------------------------------------ ------------------------
node1 yes
node2 yes
Result: Node reachability check passed from node "node1"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Comment
------------------------------------ ------------------------
node2 passed
node1 passed
Result: User equivalence check passed for user "grid"
Checking node connectivity...
Checking hosts config file...
Node Name Status Comment
------------ ------------------------ ------------------------
node2 passed
node1 passed
Verification of the hosts config file successful
Interface information for node "node2"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.204.209 192.168.204.0 0.0.0.0 192.168.204.2 00:0C:29:B7:97:10 1500
eth1 192.168.101.102 192.168.101.0 0.0.0.0 192.168.204.2 00:0C:29:B7:97:1A 1500
Interface information for node "node1"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.204.208 192.168.204.0 0.0.0.0 192.168.204.2 00:0C:29:B6:3A:0F 1500
eth1 192.168.101.101 192.168.101.0 0.0.0.0 192.168.204.2 00:0C:29:B6:3A:19 1500
Check: Node connectivity of subnet "192.168.204.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
node2:eth0 node1:eth0 yes
Result: Node connectivity passed for subnet "192.168.204.0" with node(s) node2,node1
Check: TCP connectivity of subnet "192.168.204.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
node1:192.168.204.208 node2:192.168.204.209 passed
Result: TCP connectivity check passed for subnet "192.168.204.0"
Check: Node connectivity of subnet "192.168.101.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
node2:eth1 node1:eth1 yes
Result: Node connectivity passed for subnet "192.168.101.0" with node(s) node2,node1
Check: TCP connectivity of subnet "192.168.101.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
node1:192.168.101.101 node2:192.168.101.102 passed
Result: TCP connectivity check passed for subnet "192.168.101.0"
Interfaces found on subnet "192.168.204.0" that are likely candidates for VIP are:
node2 eth0:192.168.204.209
node1 eth0:192.168.204.208
Interfaces found on subnet "192.168.101.0" that are likely candidates for a private interconnect are:
node2 eth1:192.168.101.102
node1 eth1:192.168.101.101
Result: Node connectivity check passed
Check: Total memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
node2 1010.88MB (1035140.0KB) 1.5GB (1572864.0KB) failed
node1 1010.88MB (1035140.0KB) 1.5GB (1572864.0KB) failed
Result: Total memory check failed
Check: Available memory
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
node2 891.89MB (913292.0KB) 50MB (51200.0KB) passed
node1 863.35MB (884068.0KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
Result: Swap space check failed
Check: Free disk space for "node2:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp node2 / 4.82GB 1GB passed
Result: Free disk space check passed for "node2:/tmp"
Check: Free disk space for "node1:/tmp"
Path Node Name Mount point Available Required Comment
---------------- ------------ ------------ ------------ ------------ ------------
/tmp node1 / 2.79GB 1GB passed
Result: Free disk space check passed for "node1:/tmp"
Check: User existence for "grid"
Node Name Status Comment
------------ ------------------------ ------------------------
node2 exists passed
node1 exists passed
Result: User existence check passed for "grid"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
node2 exists passed
node1 exists passed
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
node2 exists passed
node1 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
---------------- ------------ ------------ ------------ ------------ ------------
node2 yes yes yes yes passed
node1 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
---------------- ------------ ------------ ------------ ----------------
node2 yes yes yes passed
node1 yes yes yes passed
Result: Membership check for user "grid" in group "dba" passed
Check: Run level
Node Name run level Required Comment
------------ ------------------------ ------------------------ ----------
node2 5 3,5 passed
node1 5 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
node2 hard 1024 65536 failed
node1 hard 1024 65536 failed
Result: Hard limits check failed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Comment
---------------- ------------ ------------ ------------ ----------------
node2 soft 1024 1024 passed
node1 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
---------------- ------------ ------------ ------------ ----------------
node2 hard 16384 16384 passed
node1 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
---------------- ------------ ------------ ------------ ----------------
node2 soft 2047 2047 passed
node1 soft 2047 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
node2 i686 x86 passed
node1 i686 x86 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
node2 2.6.18-164.el5 2.6.18 passed
node1 2.6.18-164.el5 2.6.18 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 250 250 passed
node1 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 32000 32000 passed
node1 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 100 100 passed
node1 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 128 128 passed
node1 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 4294967295 536870912 passed
node1 4294967295 536870912 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 4096 4096 passed
node1 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 268435456 2097152 passed
node1 268435456 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 6815744 6815744 passed
node1 6815744 6815744 passed
Result: Kernel parameter check passed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 between 9000 & 65500 between 9000 & 65500 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 262144 262144 passed
node1 262144 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 4194304 4194304 passed
node1 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 262144 262144 passed
node1 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 1048586 1048576 passed
node1 1048586 1048576 passed
Result: Kernel parameter check passed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Configured Required Comment
------------ ------------------------ ------------------------ ----------
node2 1048576 1048576 passed
node1 1048576 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "make-3.81"
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
node2 make-3.81-3.el5 make-3.81 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 binutils-2.17.50.0.6-12.el5 binutils-2.17.50.0.6 passed
node1 binutils-2.17.50.0.6-12.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
------------ ------------------------ ------------------------ ----------
node2 gcc-4.1.2-46.el5 gcc-4.1.2 passed
node1 gcc-4.1.2-46.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
------------ ------------------------ ------------------------ ----------
node2 gcc-c++-4.1.2-46.el5 gcc-c++-4.1.2 passed
node1 gcc-c++-4.1.2-46.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
------------ ------------------------ ------------------------ ----------
node2 libgomp-4.4.0-6.el5 libgomp-4.1.2 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 libaio-0.3.106-3.2 libaio-0.3.106 passed
node1 libaio-0.3.106-3.2 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
------------ ------------------------ ------------------------ ----------
node2 glibc-2.5-42 glibc-2.5-24 passed
node1 glibc-2.5-42 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
------------ ------------------------ ------------------------ ----------
node2 compat-libstdc++-33-3.2.3-61 compat-libstdc++-33-3.2.3 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 elfutils-libelf-0.137-3.el5 elfutils-libelf-0.125 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 elfutils-libelf-devel-0.137-3.el5 elfutils-libelf-devel-0.125 passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 glibc-common-2.5-42 glibc-common-2.5 passed
node1 glibc-common-2.5-42 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
------------ ------------------------ ------------------------ ----------
node2 glibc-devel-2.5-42 glibc-devel-2.5 passed
node1 glibc-devel-2.5-42 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
------------ ------------------------ ------------------------ ----------
node2 glibc-headers-2.5-42 glibc-headers-2.5 passed
node1 glibc-headers-2.5-42 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
------------ ------------------------ ------------------------ ----------
node2 missing libaio-devel-0.3.106 failed
node1 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
------------ ------------------------ ------------------------ ----------
node2 libgcc-4.1.2-46.el5 libgcc-4.1.2 passed
node1 libgcc-4.1.2-46.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
------------ ------------------------ ------------------------ ----------
node2 libstdc++-4.1.2-46.el5 libstdc++-4.1.2 passed
node1 libstdc++-4.1.2-46.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
------------ ------------------------ ------------------------ ----------
node2 libstdc++-devel-4.1.2-46.el5 libstdc++-devel-4.1.2 passed
node1 libstdc++-devel-4.1.2-46.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
------------ ------------------------ ------------------------ ----------
node2 missing sysstat-7.0.2 failed
node1 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
------------ ------------------------ ------------------------ ----------
node2 missing unixODBC-2.2.11 failed
node1 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
------------ ------------------------ ------------------------ ----------
node2 missing unixODBC-devel-2.2.11 failed
node1 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
------------ ------------------------ ------------------------ ----------
node2 ksh-20080202-14.el5 ksh-20060214 passed
node1 ksh-20080202-14.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
------------ ------------------------ ------------------------
node2 does not exist passed
node1 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
------------ ------------------------ ------------------------ ----------
node2 0022 0022 passed
node1 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
Fixup information has been generated for following node(s):
node2,node1
Please run the following script on each node as "root" user to execute the fixups:
'/tmp/CVU_11.2.0.1.0_grid/runfixup.sh'
Pre-check for cluster services setup was unsuccessful on all the nodes.
修补安装包后开始安装:
[grid@node1 grid]$ ./runInstaller
安装完成后,使用root运行脚本:
[root@node1 app]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@node1 app]# /u01/app/grid/product/11.2.0/root.sh
Running Oracle 11g root.sh script...
The following environment variables are set as:
ORACLE_OWNER= grid
ORACLE_HOME= /u01/app/grid/product/11.2.0
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
2013-04-12 15:07:44: Parsing the host name
2013-04-12 15:07:44: Checking for super user privileges
2013-04-12 15:07:44: User has super user privileges
Using configuration parameter file: /u01/app/grid/product/11.2.0/crs/install/crsconfig_params
Creating trace directory
LOCAL ADD MODE
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding daemon to inittab
CRS-4123: Oracle High Availability Services has been started.
ohasd is starting
CRS-2672: Attempting to start 'ora.gipcd' on 'node1'
CRS-2672: Attempting to start 'ora.mdnsd' on 'node1'
CRS-2676: Start of 'ora.gipcd' on 'node1' succeeded
CRS-2676: Start of 'ora.mdnsd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node1'
CRS-2676: Start of 'ora.gpnpd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'
CRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node1'
CRS-2672: Attempting to start 'ora.diskmon' on 'node1'
CRS-2676: Start of 'ora.diskmon' on 'node1' succeeded
CRS-2676: Start of 'ora.cssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node1'
CRS-2676: Start of 'ora.ctssd' on 'node1' succeeded
ASM created and started successfully.
DiskGroup CRS created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-2672: Attempting to start 'ora.crsd' on 'node1'
CRS-2676: Start of 'ora.crsd' on 'node1' succeeded
CRS-4256: Updating the profile
Successful addition of voting disk 44b8f3ba5ac94f39bf00df714cf8050b.
Successful addition of voting disk ac3966cb6f704f70bfcc5076e85f846d.
Successful addition of voting disk 0803f35ce1634fb0bf2ace2ea5d73620.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 44b8f3ba5ac94f39bf00df714cf8050b (/dev/raw/raw1) [CRS]
2. ONLINE ac3966cb6f704f70bfcc5076e85f846d (/dev/raw/raw2) [CRS]
3. ONLINE 0803f35ce1634fb0bf2ace2ea5d73620 (/dev/raw/raw3) [CRS]
Located 3 voting disk(s).
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'node1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gpnpd' on 'node1'
CRS-2677: Stop of 'ora.gpnpd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.gipcd' on 'node1'
CRS-2677: Stop of 'ora.gipcd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 'node1'
CRS-2677: Stop of 'ora.mdnsd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.mdnsd' on 'node1'
CRS-2676: Start of 'ora.mdnsd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.gipcd' on 'node1'
CRS-2676: Start of 'ora.gipcd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'node1'
CRS-2676: Start of 'ora.gpnpd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'
CRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node1'
CRS-2672: Attempting to start 'ora.diskmon' on 'node1'
CRS-2676: Start of 'ora.diskmon' on 'node1' succeeded
CRS-2676: Start of 'ora.cssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node1'
CRS-2676: Start of 'ora.ctssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node1'
CRS-2676: Start of 'ora.asm' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node1'
CRS-2676: Start of 'ora.crsd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node1'
CRS-2676: Start of 'ora.evmd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node1'
CRS-2676: Start of 'ora.asm' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.CRS.dg' on 'node1'
CRS-2676: Start of 'ora.CRS.dg' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.registry.acfs' on 'node1'
CRS-2676: Start of 'ora.registry.acfs' on 'node1' succeeded
node1 2013/04/12 15:24:28 /u01/app/grid/product/11.2.0/cdata/node1/backup_20130412_152428.olr
Preparing packages for installation...
cvuqdisk-1.0.7-1
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Updating inventory properties for clusterware
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 957 MB Passed
The inventory pointer is located at /etc/oraInst.loc
The inventory is located at /u01/app/oraInventory
'UpdateNodeList' was successful.
完成后查看CRS_STAT查看状态:
[grid@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node1
ora.asm ora.asm.type ONLINE ONLINE node1
ora.eons ora.eons.type ONLINE ONLINE node1
ora.gsd ora.gsd.type OFFLINE OFFLINE
ora....network ora....rk.type ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora.node1.gsd application OFFLINE OFFLINE
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip ora....t1.type ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora.node2.gsd application OFFLINE OFFLINE
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip ora....t1.type ONLINE ONLINE node2
ora.oc4j ora.oc4j.type OFFLINE OFFLINE
ora.ons ora.ons.type ONLINE ONLINE node1
ora....ry.acfs ora....fs.type ONLINE ONLINE node1
ora.scan1.vip ora....ip.type ONLINE ONLINE node1
安装完毕后:oc4j,gsd两个服务是disable的。
[grid@node1 ~]$ srvctl enable oc4j
[grid@node1 ~]$ srvctl enable nodeapps
PRKO-2415 : VIP is already enabled on node(s): node1,node2
PRKO-2416 : Network resource is already enabled.
PRKO-2417 : ONS is already enabled on node(s): node1,node2
PRKO-2418 : eONS is already enabled on node(s): node1,node2
[grid@node1 ~]$ srvctl start oc4j
[grid@node1 ~]$ crs_start ora.node1.gsd
Attempting to start `ora.gsd` on member `node1`
Start of `ora.gsd` on member `node1` succeeded.
[grid@node1 ~]$ crs_start ora.node2.gsd
Attempting to start `ora.gsd` on member `node2`
Start of `ora.gsd` on member `node2` succeeded.
[grid@node1 ~]$ crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.CRS.dg ora....up.type ONLINE ONLINE node1
ora....N1.lsnr ora....er.type ONLINE ONLINE node1
ora.asm ora.asm.type ONLINE ONLINE node1
ora.eons ora.eons.type ONLINE ONLINE node1
ora.gsd ora.gsd.type ONLINE ONLINE node1
ora....network ora....rk.type ONLINE ONLINE node1
ora....SM1.asm application ONLINE ONLINE node1
ora.node1.gsd application ONLINE ONLINE node1
ora.node1.ons application ONLINE ONLINE node1
ora.node1.vip ora....t1.type ONLINE ONLINE node1
ora....SM2.asm application ONLINE ONLINE node2
ora.node2.gsd application ONLINE ONLINE node2
ora.node2.ons application ONLINE ONLINE node2
ora.node2.vip ora....t1.type ONLINE ONLINE node2
ora.oc4j ora.oc4j.type ONLINE ONLINE node2
ora.ons ora.ons.type ONLINE ONLINE node1
ora....ry.acfs ora....fs.type ONLINE ONLINE node1
ora.scan1.vip ora....ip.type ONLINE ONLINE node1
[grid@node1 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
Version : 3
Total space (kbytes) : 262120
Used space (kbytes) : 2256
Available space (kbytes) : 259864
ID : 166320402
Device/File Name : +CRS
Device/File integrity check succeeded
Device/File not configured
Device/File not configured
Device/File not configured
Device/File not configured
Cluster registry integrity check succeeded
Logical corruption check bypassed due to non-privileged user
[grid@node1 ~]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 44b8f3ba5ac94f39bf00df714cf8050b (/dev/raw/raw1) [CRS]
2. ONLINE ac3966cb6f704f70bfcc5076e85f846d (/dev/raw/raw2) [CRS]
3. ONLINE 0803f35ce1634fb0bf2ace2ea5d73620 (/dev/raw/raw3) [CRS]
脚本运行完毕后,配置网络,ASM等。
[grid@node1 ~]$ asmca
安装数据库软件:
[oracle@node1 database]$ cd database/
[oracle@node1 database]$ ls
doc install response rpm runInstaller sshsetup stage welcome.html
[oracle@node1 database]$ ./runInstaller
在最后使用root用户,在两个节点运行脚本之后,完成数据库软件的安装。
建库:
dbca
[grid@node1 oracle]$ crs_stat -t -v
Name Type R/RA F/FT Target State Host
----------------------------------------------------------------------
ora.CRS.dg ora....up.type 0/5 0/ ONLINE ONLINE node1
ora.DATA.dg ora....up.type 0/5 0/ ONLINE ONLINE node1
ora....ER.lsnr ora....er.type 0/5 0/ ONLINE ONLINE node1
ora....N1.lsnr ora....er.type 0/5 0/0 ONLINE ONLINE node1
ora.asm ora.asm.type 0/5 0/ ONLINE ONLINE node1
ora.bule.db ora....se.type 0/2 0/1 ONLINE ONLINE node1
ora.eons ora.eons.type 0/3 0/ ONLINE ONLINE node1
ora.gsd ora.gsd.type 0/5 0/ ONLINE ONLINE node1
ora....network ora....rk.type 0/5 0/ ONLINE ONLINE node1
ora....SM1.asm application 0/5 0/0 ONLINE ONLINE node1
ora....E1.lsnr application 0/5 0/0 ONLINE ONLINE node1
ora.node1.gsd application 0/5 0/0 ONLINE ONLINE node1
ora.node1.ons application 0/3 0/0 ONLINE ONLINE node1
ora.node1.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node1
ora....SM2.asm application 0/5 0/0 ONLINE ONLINE node2
ora....E2.lsnr application 0/5 0/0 ONLINE ONLINE node2
ora.node2.gsd application 0/5 0/0 ONLINE ONLINE node2
ora.node2.ons application 0/3 0/0 ONLINE ONLINE node2
ora.node2.vip ora....t1.type 0/0 0/0 ONLINE ONLINE node2
ora.oc4j ora.oc4j.type 0/5 0/0 ONLINE ONLINE node1
ora.ons ora.ons.type 0/3 0/ ONLINE ONLINE node1
ora....ry.acfs ora....fs.type 0/5 0/ ONLINE ONLINE node1
ora.scan1.vip ora....ip.type 0/0 0/0 ONLINE ONLINE node1
C:\Users\20201131>tnsping rac_bule_1
TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-4月 -2013 15:08:23
Copyright (c) 1997, 2010, Oracle. All rights reserved.
已使用的参数文件:
D:\oracle\product\11.2.0\dbhome_1\network\admin\sqlnet.ora
已使用 TNSNAMES 适配器来解析别名
尝试连接 (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.204.210)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME
= bule) (INSTANCE_NAME = bule1)))
OK (10 毫秒)
C:\Users\20201131>sqlplus /nolog
SQL*Plus: Release 11.2.0.1.0 Production on 星期一 4月 15 15:08:27 2013
Copyright (c) 1982, 2010, Oracle. All rights reserved.
@>conn scott/tiger@rac_bule_1
ERROR:
ORA-28001: the password has expired
更改 scott 的口令
新口令:
重新键入新口令:
口令已更改
已连接。
SCOTT@rac_bule_1>
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/15173958/viewspace-1142336/ ,如需转载,请注明出处,否则将追究法律责任。