ITPub博客

首页 > 数据库 > Oracle > VMWARE8+RHEL54+Oracle11g+ASM+RAC

VMWARE8+RHEL54+Oracle11g+ASM+RAC

原创 Oracle 作者:jingwei269 时间:2014-04-15 11:04:14 0 删除 编辑

VMWARE8+RHEL54+ORACLE11G+ASM+RAC安装文档:

文件安装包:

地址:http://www.oracle.com/technetwork/products/clusterware/downloads/index.html

GRID:Oracle Grid Infrastructure 11g Release 2 (11.2.0.1.0)

Oracle:Oracle Database 11g Release 2 
Standard Edition, Standard Edition One, and Enterprise Edition

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

 

  1. 安装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

  2. 安装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等。


 

配置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/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-06-17

  • 博文量
    5
  • 访问量
    26075