Oracle 11gr2 RAC on OEL6.4静默安装
1 安装前准备
1.1 检查硬件
内存：安装grid infrastructure最少需要1.5GB的内存，安装grid infrastructure和RAC最少需要2.5GB的内存
swap：最少需要1.5GB
temp：最少1GB
安装目录：grid infrastructure、ASM、clusterware最少需要12GB；
network：双网卡
1.2 检查软件
1. OS : Oracle Linux 6 Update 4
Oracle 要求各节点OS相同，强烈推荐集群中的各节点软件相同
2. RPM包检查
[root@db2 ~]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat
[root@vm5 app]# rpm -q --qf '%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n' binutils compat-libcap1 compat-libstdc++-33 gcc gcc-c++ glibc glibc-devel ksh libgcc libstdc++ libstdc++-devel libaio libaio-devel make sysstat
binutils-2.20.51.0.2-5.36.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
gcc-4.4.7-3.el6 (x86_64)
gcc-c++-4.4.7-3.el6 (x86_64)
glibc-2.12-1.107.el6 (x86_64)
glibc-devel-2.12-1.107.el6 (x86_64)
ksh-20100621-19.el6 (x86_64)
libgcc-4.4.7-3.el6 (x86_64)
libstdc++-4.4.7-3.el6 (x86_64)
libstdc++-devel-4.4.7-3.el6 (x86_64)
libaio-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6 (x86_64)
make-3.81-20.el6 (x86_64)
sysstat-9.0.4-20.el6 (x86_64)
参考：
Oracle? Grid Infrastructure Installation Guide 11g Release 2 (11.2) for Linux(E22489-08)
【Table 2-9 Linux x86-64 Oracle Grid Infrastructure and Oracle RAC Package Requirements】
Oracle Linux 6 and Red Hat Enterprise Linux 6必须要安装的包:
binutils-2.20.51.0.2-5.11.el6 (x86_64)
compat-libcap1-1.10-1 (x86_64)
compat-libstdc++-33-3.2.3-69.el6 (x86_64)
compat-libstdc++-33-3.2.3-69.el6.i686
gcc-4.4.4-13.el6 (x86_64)
gcc-c++-4.4.4-13.el6 (x86_64)
glibc-2.12-1.7.el6 (i686)
glibc-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6 (x86_64)
glibc-devel-2.12-1.7.el6.i686
ksh
libgcc-4.4.4-13.el6 (i686)
libgcc-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6 (x86_64)
libstdc++-4.4.4-13.el6.i686
libstdc++-devel-4.4.4-13.el6 (x86_64)
libstdc++-devel-4.4.4-13.el6.i686
libaio-0.3.107-10.el6 (x86_64)
libaio-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6 (x86_64)
libaio-devel-0.3.107-10.el6.i686
make-3.81-19.el6
sysstat-9.0.4-11.el6 (x86_64)
1.3 用户的配置
1. 创建 grid、oracle 用户与组
groupadd -g 506 oinstall
groupadd -g 505 dba
groupadd -g 502 asmdba
groupadd -g 503 asmadmin
groupadd -g 504 asmoper
useradd -u 506 -g oinstall -G dba,asmdba oracle
useradd -u 505 -g oinstall -G asmadmin,asmdba,asmoper grid
passwd grid
passwd oracle
mkdir -p /data/app/grid
mkdir -p /data/app/11.2.0/grid
chown -R grid:oinstall /data/app/grid
chown -R grid:oinstall /data/app/11.2.0/grid
chown -R grid:oinstall /data/app
mkdir -p /data/app/oracle
chown oracle:oinstall /data/app/oracle
chmod -R 775 /data/app
2. grid、oracle 用户环境变量
配置grid和oracle用户的profile，编辑2个用户下的.bash_profile文件。需要注意，在grid用户中，ORACLE_BASE的设置不能包含ORACLE_HOME目录，否则在安装时会报错，也就是不能是ORACLE_HOME的上级目录，和oracle用户不同。
grid用户.bash_profile：
export ORACLE_BASE=/data/app/grid
export ORACLE_HOME=/data/app/11.2.0/grid
export ORACLE_SID=+ASM1
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:${PATH}:$HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
export SQLPATH=/app/oracle/login
umask 022
oracle用户.bash_profile:
export ORACLE_BASE=/data/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=racdb1
export PATH=.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:${PATH}:$HOME/bin
export PATH=${PATH}:/usr/bin:/bin:/usr/bin/X11:/usr/local/bin
export PATH=${PATH}:$ORACLE_BASE/common/oracle/bin
export ORACLE_TERM=xterm
export TNS_ADMIN=$ORACLE_HOME/network/admin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:$ORACLE_HOME/oracm/lib
export LD_LIBRARY_PATH=${LD_LIBRARY_PATH}:/lib:/usr/lib:/usr/local/lib
export CLASSPATH=$ORACLE_HOME/JRE
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/rdbms/jlib
export CLASSPATH=${CLASSPATH}:$ORACLE_HOME/network/jlib
export THREADS_FLAG=native
export TEMP=/tmp
export TMPDIR=/tmp
export SQLPATH=/app/oracle/login
umask 022
1.4 网络配置
1. 刀片服务器 eth0 为心跳地址， eth1 为pub 地址。禁止使用DHCP 自动获得IP
2. 使用ifconfig –a 进行检查
3. 配置 /etc/hosts
[root@vm4 ~]# vi /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
#::1 localhost localhost.localdomain localhost6 localhost6.localdomain6
192.168.12.181 vm1
192.168.12.182 vm2
192.168.12.183 vm3
192.168.12.184 vm4
192.168.12.84 vm4-vip
10.1.1.184 vm4-priv
192.168.12.185 vm5
192.168.12.85 vm5-vip
10.1.1.185 vm5-priv
192.168.12.83 scanip
1.5 内核参数
1. /etc/sysctl.conf
[root@db2 Packages]# cat /etc/sysctl.conf | egrep -v "#|^$"
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
net.bridge.bridge-nf-call-ip6tables = 0
net.bridge.bridge-nf-call-iptables = 0
net.bridge.bridge-nf-call-arptables = 0
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 68719476736
kernel.shmall = 4294967296
kernel.shmmni = 4096
fs.aio-max-nr = 1048576
fs.file-max = 6815744
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 = 1048576
立即生效:
# /sbin/sysctl -p
2. /etc/security/limits.conf
oracle hard nofile 131072
oracle soft nproc 131072
oracle hard nproc 131072
oracle soft core unlimited
oracle hard core unlimited
oracle soft memlock 50000000
oracle hard memlock 50000000
grid soft nofile 131072
grid hard nofile 131072
grid soft nproc 131072
grid hard nproc 131072
grid soft core unlimited
grid hard core unlimited
grid soft memlock 50000000
grid hard memlock 50000000
/*参考值：
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
*/
1.6 SSH等效性
需要配置 oracle 用户的等效性。
ssh-keygen -t dsa
ssh vm5 ssh-keygen -t rsa
ssh vm5 ssh-keygen -t dsa
touch authorized_keys
cat ~/.ssh/id_rsa.pub >> authorized_keys
cat ~/.ssh/id_dsa.pub >> authorized_keys
ssh vm5 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh vm5 cat ~/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys vm5:/home/oracle/.ssh/
cp authorized_keys ~/.ssh/
需要配置 grid 用户的等效性。
ssh-keygen -t rsa
ssh-keygen -t dsa
ssh vm5 ssh-keygen -t rsa
ssh vm5 ssh-keygen -t dsa
touch authorized_keys
cat ~/.ssh/id_rsa.pub >> authorized_keys
cat ~/.ssh/id_dsa.pub >> authorized_keys
ssh vm5 cat ~/.ssh/id_rsa.pub >> authorized_keys
ssh vm5 cat ~/.ssh/id_dsa.pub >> authorized_keys
scp authorized_keys vm5:/home/grid/.ssh/
cp authorized_keys ~/.ssh/
1.7 时间同步（NTP、CTSS）
NTP:
RAC 集群的时间需要保持同步，采用crontab 每小时和时间服务器同步。
[root@db1 tmp]# crontab -l
0 * * * * /usr/sbin/ntpdate 20.1.2.250 > /dev/null 2>&1
CTSS:
1.8 raw设备配置
[root]#vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="sdb1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdc1", RUN+="/bin/raw /dev/raw/raw2 %N"
KERNEL=="raw[1-9]", OWNER="grid", GROUP="asmadmin", MODE="0660"
#ACTION=="add", KERNEL=="/dev/mapper/disk101", RUN+="/bin/raw /dev/raw/raw101 %N"
#ACTION=="add", KERNEL=="/dev/mapper/disk102", RUN+="/bin/raw /dev/raw/raw102 %N"
#ACTION=="add", KERNEL=="/dev/mapper/disk103", RUN+="/bin/raw /dev/raw/raw103 %N"
# KERNEL=="raw{1..200}", OWNER="grid", GROUP="asmadmin", MODE="0660"
[root]#start_udev
[root]#raw -a
Linux 4：
1. # /usr/bin/raw -qa
2. /etc/sysconfig/rawdevices
/dev/raw/raw1 /dev/sdb1
3. # chown root:oinstall /dev/raw/rawn
# chmod 640 /dev/raw/rawn
修改 /etc/udev/permissions.d/50-udev.permissions
原始设备在引导时会重新映射。默认情况下，在引导时原始设备的拥有者将更改为 root 用户。如果拥有者不是 oracle 用户，则 ASM 在访问共享分区时会出现问题
在 /etc/udev/permissions.d/50-udev.permissions 中为原始行“raw/*:root:disk:0660”添加注释，然后添加一个新行“raw/*:oracle:dba:0660”。
/etc/udev/permissions.d/50-udev.permissions
# raw devices
ram*:root:disk:0660
#raw/*:root:disk:0660
raw/*:oracle:dba:0660
4. # /sbin/service rawdevices restart
Linux 5 或 linux 6：
[root]#vi /etc/udev/rules.d/60-raw.rules
ACTION=="add", KERNEL=="sdj1", RUN+="/bin/raw /dev/raw/raw1 %N"
ACTION=="add", KERNEL=="sdk1", RUN+="/bin/raw /dev/raw/raw2 %N"
KERNEL=="raw[1-9]", OWNER="oracle", GROUP="dba", MODE="660"
[root]#start_udev
[root]#raw -a
或者：
#raw /dev/raw/raw14 /dev/sdc10
#vi /etc/rc.local #重启时执行
raw /dev/raw/raw14 /dev/sdc10
chmod 660 /dev/raw/raw14
chown oracle.dba /dev/raw/raw14
1.9 关闭防火墙
设置：SELINUX=disabled
[root@db1 ~]# vi /etc/selinux/config
# This file controls the state of SELinux on the system.
# SELINUX= can take one of these three values:
# enforcing - SELinux security policy is enforced.
# permissive - SELinux prints warnings instead of enforcing.
# disabled - No SELinux policy is loaded.
#SELINUX=enforcing
SELINUX=disabled
# SELINUXTYPE= can take one of these two values:
# targeted - Targeted processes are protected,
# mls - Multi Level Security protection.
SELINUXTYPE=targeted
设置防火墙：iptables
[root@db1 ~]# chkconfig --list |grep iptable
iptables 0:off 1:off 2:on 3:on 4:on 5:on 6:off
[root@db1 ~]# service iptables stop
iptables: Flushing firewall rules: [ OK ]
iptables: Setting chains to policy ACCEPT: filter [ OK ]
iptables: Unloading modules: [ OK ]
[root@db1 ~]# chkconfig iptables off
[root@db1 ~]# chkconfig --list |grep iptable
iptables 0:off 1:off 2:off 3:off 4:off 5:off 6:off
1.10 准备安装介质
使用ssh或ftp协议上传，上传时注意通过二进制bin方式。
Installation Type Zip File
Oracle Database (includes Oracle Database and Oracle RAC)
Note: you must download both zip files to install Oracle Database.
p10404530_112030_platform_1of7.zip
p10404530_112030_platform_2of7.zip
Oracle Grid Infrastructure (includes Oracle ASM, Oracle Clusterware, and Oracle Restart)
p10404530_112030_platform_3of7.zip
1.11 校验cluster安装环境
校验cluster环境，使用grid用户执行，脚本在安装包中。
./runcluvfy.sh stage -pre crsinst -n vm4,vm5 -fixup -verbose
检查内容：
[grid@vm4 grid]$ ./runcluvfy.sh stage -pre crsinst -n vm4,vm5 -fixup -verbose
Performing pre-checks for cluster services setup
Checking node reachability...
Check: Node reachability from node "vm4"
Destination Node Reachable?
------------------------------------ ------------------------
vm4 yes
vm5 yes
Result: Node reachability check passed from node "vm4"
Checking user equivalence...
Check: User equivalence for user "grid"
Node Name Status
------------------------------------ ------------------------
vm5 passed
vm4 passed
Result: User equivalence check passed for user "grid"
Checking node connectivity...
Checking hosts config file...
Node Name Status
------------------------------------ ------------------------
vm5 passed
vm4 passed
Verification of the hosts config file successful
Interface information for node "vm5"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.12.185 192.168.12.0 0.0.0.0 192.168.12.12 08:00:27:1E:B5:E6 1500
eth1 10.1.1.185 10.1.1.0 0.0.0.0 192.168.12.12 08:00:27:00:5F:F9 1500
Interface information for node "vm4"
Name IP Address Subnet Gateway Def. Gateway HW Address MTU
------ --------------- --------------- --------------- --------------- ----------------- ------
eth0 192.168.12.184 192.168.12.0 0.0.0.0 192.168.12.12 08:00:27:67:B1:D3 1500
eth1 10.1.1.184 10.1.1.0 0.0.0.0 192.168.12.12 08:00:27:3F:6A:93 1500
Check: Node connectivity of subnet "192.168.12.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
vm5[192.168.12.185] vm4[192.168.12.184] yes
Result: Node connectivity passed for subnet "192.168.12.0" with node(s) vm5,vm4
Check: TCP connectivity of subnet "192.168.12.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
vm4:192.168.12.184 vm5:192.168.12.185 passed
Result: TCP connectivity check passed for subnet "192.168.12.0"
Check: Node connectivity of subnet "10.1.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
vm5[10.1.1.185] vm4[10.1.1.184] yes
Result: Node connectivity passed for subnet "10.1.1.0" with node(s) vm5,vm4
Check: TCP connectivity of subnet "10.1.1.0"
Source Destination Connected?
------------------------------ ------------------------------ ----------------
vm4:10.1.1.184 vm5:10.1.1.185 passed
Result: TCP connectivity check passed for subnet "10.1.1.0"
Interfaces found on subnet "192.168.12.0" that are likely candidates for VIP are:
vm5 eth0:192.168.12.185
vm4 eth0:192.168.12.184
Interfaces found on subnet "10.1.1.0" that are likely candidates for a private interconnect are:
vm5 eth1:10.1.1.185
vm4 eth1:10.1.1.184
Checking subnet mask consistency...
Subnet mask consistency check passed for subnet "192.168.12.0".
Subnet mask consistency check passed for subnet "10.1.1.0".
Subnet mask consistency check passed.
Result: Node connectivity check passed
Checking multicast communication...
Checking subnet "192.168.12.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "192.168.12.0" for multicast communication with multicast group "230.0.1.0" passed.
Checking subnet "10.1.1.0" for multicast communication with multicast group "230.0.1.0"...
Check of subnet "10.1.1.0" for multicast communication with multicast group "230.0.1.0" passed.
Check of multicast communication passed.
Checking ASMLib configuration.
Node Name Status
------------------------------------ ------------------------
vm5 passed
vm4 passed
Result: Check for ASMLib configuration passed.
Check: Total memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 11.7578GB (1.2328976E7KB) 1.5GB (1572864.0KB) passed
vm4 11.7578GB (1.2328976E7KB) 1.5GB (1572864.0KB) passed
Result: Total memory check passed
Check: Available memory
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 11.52GB (1.2079592E7KB) 50MB (51200.0KB) passed
vm4 11.1911GB (1.1734768E7KB) 50MB (51200.0KB) passed
Result: Available memory check passed
Check: Swap space
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 1.9531GB (2047996.0KB) 11.7578GB (1.2328976E7KB) failed
vm4 1.9531GB (2047996.0KB) 11.7578GB (1.2328976E7KB) failed
Result: Swap space check failed
Check: Free disk space for "vm5:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp vm5 / 9.0576GB 1GB passed
Result: Free disk space check passed for "vm5:/tmp"
Check: Free disk space for "vm4:/tmp"
Path Node Name Mount point Available Required Status
---------------- ------------ ------------ ------------ ------------ ------------
/tmp vm4 / 8.6251GB 1GB passed
Result: Free disk space check passed for "vm4:/tmp"
Check: User existence for "grid"
Node Name Status Comment
------------ ------------------------ ------------------------
vm5 passed exists(505)
vm4 passed exists(505)
Checking for multiple users with UID value 505
Result: Check for multiple users with UID value 505 passed
Result: User existence check passed for "grid"
Check: Group existence for "oinstall"
Node Name Status Comment
------------ ------------------------ ------------------------
vm5 passed exists
vm4 passed exists
Result: Group existence check passed for "oinstall"
Check: Group existence for "dba"
Node Name Status Comment
------------ ------------------------ ------------------------
vm5 passed exists
vm4 passed exists
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 Status
---------------- ------------ ------------ ------------ ------------ ------------
vm5 yes yes yes yes passed
vm4 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 Status
---------------- ------------ ------------ ------------ ----------------
vm5 yes yes no failed
vm4 yes yes no failed
Result: Membership check for user "grid" in group "dba" failed
Check: Run level
Node Name run level Required Status
------------ ------------------------ ------------------------ ----------
vm5 3 3,5 passed
vm4 3 3,5 passed
Result: Run level check passed
Check: Hard limits for "maximum open file descriptors"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
vm5 hard 131072 65536 passed
vm4 hard 131072 65536 passed
Result: Hard limits check passed for "maximum open file descriptors"
Check: Soft limits for "maximum open file descriptors"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
vm5 soft 131072 1024 passed
vm4 soft 131072 1024 passed
Result: Soft limits check passed for "maximum open file descriptors"
Check: Hard limits for "maximum user processes"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
vm5 hard 131072 16384 passed
vm4 hard 131072 16384 passed
Result: Hard limits check passed for "maximum user processes"
Check: Soft limits for "maximum user processes"
Node Name Type Available Required Status
---------------- ------------ ------------ ------------ ----------------
vm5 soft 131072 2047 passed
vm4 soft 131072 2047 passed
Result: Soft limits check passed for "maximum user processes"
Check: System architecture
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 x86_64 x86_64 passed
vm4 x86_64 x86_64 passed
Result: System architecture check passed
Check: Kernel version
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 2.6.39-400.17.1.el6uek.x86_64 2.6.32 passed
vm4 2.6.39-400.17.1.el6uek.x86_64 2.6.32 passed
Result: Kernel version check passed
Check: Kernel parameter for "semmsl"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 250 250 250 passed
vm4 250 250 250 passed
Result: Kernel parameter check passed for "semmsl"
Check: Kernel parameter for "semmns"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 32000 32000 32000 passed
vm4 32000 32000 32000 passed
Result: Kernel parameter check passed for "semmns"
Check: Kernel parameter for "semopm"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 100 100 100 passed
vm4 100 100 100 passed
Result: Kernel parameter check passed for "semopm"
Check: Kernel parameter for "semmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 128 128 128 passed
vm4 128 128 128 passed
Result: Kernel parameter check passed for "semmni"
Check: Kernel parameter for "shmmax"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 68719476736 68719476736 4294967295 passed
vm4 68719476736 68719476736 4294967295 passed
Result: Kernel parameter check passed for "shmmax"
Check: Kernel parameter for "shmmni"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 4096 4096 4096 passed
vm4 4096 4096 4096 passed
Result: Kernel parameter check passed for "shmmni"
Check: Kernel parameter for "shmall"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 4294967296 4294967296 2097152 passed
vm4 4294967296 4294967296 2097152 passed
Result: Kernel parameter check passed for "shmall"
Check: Kernel parameter for "file-max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 6815744 6815744 6815744 passed
vm4 6815744 6815744 6815744 passed
Result: Kernel parameter check passed for "file-max"
Check: Kernel parameter for "ip_local_port_range"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed
vm4 between 9000.0 & 65500.0 between 9000.0 & 65500.0 between 9000.0 & 65500.0 passed
Result: Kernel parameter check passed for "ip_local_port_range"
Check: Kernel parameter for "rmem_default"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 262144 262144 262144 passed
vm4 262144 262144 262144 passed
Result: Kernel parameter check passed for "rmem_default"
Check: Kernel parameter for "rmem_max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 4194304 4194304 4194304 passed
vm4 4194304 4194304 4194304 passed
Result: Kernel parameter check passed for "rmem_max"
Check: Kernel parameter for "wmem_default"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 262144 262144 262144 passed
vm4 262144 262144 262144 passed
Result: Kernel parameter check passed for "wmem_default"
Check: Kernel parameter for "wmem_max"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 1048576 1048576 1048576 passed
vm4 1048576 1048576 1048576 passed
Result: Kernel parameter check passed for "wmem_max"
Check: Kernel parameter for "aio-max-nr"
Node Name Current Configured Required Status Comment
---------------- ------------ ------------ ------------ ------------ ------------
vm5 1048576 1048576 1048576 passed
vm4 1048576 1048576 1048576 passed
Result: Kernel parameter check passed for "aio-max-nr"
Check: Package existence for "binutils"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 binutils-2.20.51.0.2-5.36.el6 binutils-2.20.51.0.2 passed
vm4 binutils-2.20.51.0.2-5.36.el6 binutils-2.20.51.0.2 passed
Result: Package existence check passed for "binutils"
Check: Package existence for "compat-libcap1"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 compat-libcap1-1.10-1 compat-libcap1-1.10 passed
vm4 compat-libcap1-1.10-1 compat-libcap1-1.10 passed
Result: Package existence check passed for "compat-libcap1"
Check: Package existence for "compat-libstdc++-33(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 compat-libstdc++-33(x86_64)-3.2.3-69.el6 compat-libstdc++-33(x86_64)-3.2.3 passed
vm4 compat-libstdc++-33(x86_64)-3.2.3-69.el6 compat-libstdc++-33(x86_64)-3.2.3 passed
Result: Package existence check passed for "compat-libstdc++-33(x86_64)"
Check: Package existence for "libgcc(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 libgcc(x86_64)-4.4.7-3.el6 libgcc(x86_64)-4.4.4 passed
vm4 libgcc(x86_64)-4.4.7-3.el6 libgcc(x86_64)-4.4.4 passed
Result: Package existence check passed for "libgcc(x86_64)"
Check: Package existence for "libstdc++(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 libstdc++(x86_64)-4.4.7-3.el6 libstdc++(x86_64)-4.4.4 passed
vm4 libstdc++(x86_64)-4.4.7-3.el6 libstdc++(x86_64)-4.4.4 passed
Result: Package existence check passed for "libstdc++(x86_64)"
Check: Package existence for "libstdc++-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 libstdc++-devel(x86_64)-4.4.7-3.el6 libstdc++-devel(x86_64)-4.4.4 passed
vm4 libstdc++-devel(x86_64)-4.4.7-3.el6 libstdc++-devel(x86_64)-4.4.4 passed
Result: Package existence check passed for "libstdc++-devel(x86_64)"
Check: Package existence for "sysstat"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 sysstat-9.0.4-20.el6 sysstat-9.0.4 passed
vm4 sysstat-9.0.4-20.el6 sysstat-9.0.4 passed
Result: Package existence check passed for "sysstat"
Check: Package existence for "gcc"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 gcc-4.4.7-3.el6 gcc-4.4.4 passed
vm4 gcc-4.4.7-3.el6 gcc-4.4.4 passed
Result: Package existence check passed for "gcc"
Check: Package existence for "gcc-c++"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 gcc-c++-4.4.7-3.el6 gcc-c++-4.4.4 passed
vm4 gcc-c++-4.4.7-3.el6 gcc-c++-4.4.4 passed
Result: Package existence check passed for "gcc-c++"
Check: Package existence for "ksh"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 ksh-20100621-19.el6 ksh-20100621 passed
vm4 ksh-20100621-19.el6 ksh-20100621 passed
Result: Package existence check passed for "ksh"
Check: Package existence for "make"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 make-3.81-20.el6 make-3.81 passed
vm4 make-3.81-20.el6 make-3.81 passed
Result: Package existence check passed for "make"
Check: Package existence for "glibc(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 glibc(x86_64)-2.12-1.107.el6 glibc(x86_64)-2.12 passed
vm4 glibc(x86_64)-2.12-1.107.el6 glibc(x86_64)-2.12 passed
Result: Package existence check passed for "glibc(x86_64)"
Check: Package existence for "glibc-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 glibc-devel(x86_64)-2.12-1.107.el6 glibc-devel(x86_64)-2.12 passed
vm4 glibc-devel(x86_64)-2.12-1.107.el6 glibc-devel(x86_64)-2.12 passed
Result: Package existence check passed for "glibc-devel(x86_64)"
Check: Package existence for "libaio(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 libaio(x86_64)-0.3.107-10.el6 libaio(x86_64)-0.3.107 passed
vm4 libaio(x86_64)-0.3.107-10.el6 libaio(x86_64)-0.3.107 passed
Result: Package existence check passed for "libaio(x86_64)"
Check: Package existence for "libaio-devel(x86_64)"
Node Name Available Required Status
------------ ------------------------ ------------------------ ----------
vm5 libaio-devel(x86_64)-0.3.107-10.el6 libaio-devel(x86_64)-0.3.107 passed
vm4 libaio-devel(x86_64)-0.3.107-10.el6 libaio-devel(x86_64)-0.3.107 passed
Result: Package existence check passed for "libaio-devel(x86_64)"
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
Starting check for consistency of primary group of root user
Node Name Status
------------------------------------ ------------------------
vm5 passed
vm4 passed
Check for consistency of root user's primary group passed
Starting Clock synchronization checks using Network Time Protocol(NTP)...
NTP Configuration file check started...
The NTP configuration file "/etc/ntp.conf" is available on all nodes
NTP Configuration file check passed
No NTP Daemons or Services were found to be running
PRVF-5507 : NTP daemon or service is not running on any node but NTP configuration file exists on the following node(s):
vm5,vm4
Result: Clock synchronization check using Network Time Protocol(NTP) failed
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
------------ ------------------------ ------------------------
vm5 passed does not exist
vm4 passed does not exist
Result: User "grid" is not part of "root" group. Check passed
Check default user file creation mask
Node Name Available Required Comment
------------ ------------------------ ------------------------ ----------
vm5 0022 0022 passed
vm4 0022 0022 passed
Result: Default user file creation mask check passed
Checking consistency of file "/etc/resolv.conf" across nodes
Checking the file "/etc/resolv.conf" to make sure only one of domain and search entries is defined
File "/etc/resolv.conf" does not have both domain and search entries defined
Checking if domain entry in file "/etc/resolv.conf" is consistent across the nodes...
domain entry in file "/etc/resolv.conf" is consistent across nodes
Checking if search entry in file "/etc/resolv.conf" is consistent across the nodes...
search entry in file "/etc/resolv.conf" is consistent across nodes
Checking DNS response time for an unreachable node
Node Name Status
------------------------------------ ------------------------
vm5 failed
vm4 failed
PRVF-5636 : The DNS response time for an unreachable node exceeded "15000" ms on following nodes: vm5
File "/etc/resolv.conf" is not consistent across nodes
Check: Time zone consistency
Result: Time zone consistency check passed
Fixup information has been generated for following node(s):
vm5,vm4
Please run the following script on each node as "root" user to execute the fixups:
'/tmp/CVU_11.2.0.3.0_grid/runfixup.sh'
Pre-check for cluster services setup was unsuccessful on all the nodes.
2 静默安装Grid
用grid用户运行grid安装包内的runInstaller。
[grid@node1 grid]$ ./runInstaller -silent -responseFile /home/grid/grid_install.rsp -ignorePrereq -showProgress
[grid@vm4 ~]$ egrep -v '^$|#' grid_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_crsinstall_response_schema_v11_2_0
ORACLE_HOSTNAME=
INVENTORY_LOCATION=/data/app/oraInventory
SELECTED_LANGUAGES=en
oracle.install.option=CRS_CONFIG
ORACLE_BASE=/data/app/grid
ORACLE_HOME=/data/app/11.2.0/grid
oracle.install.asm.OSDBA=asmdba
oracle.install.asm.OSOPER=asmoper
oracle.install.asm.OSASM=asmadmin
oracle.install.crs.config.gpnp.scanName=scanip
oracle.install.crs.config.gpnp.scanPort=1521
oracle.install.crs.config.clusterName=rac-cluster
oracle.install.crs.config.gpnp.configureGNS=false
oracle.install.crs.config.gpnp.gnsSubDomain=
oracle.install.crs.config.gpnp.gnsVIPAddress=
oracle.install.crs.config.autoConfigureClusterNodeVIP=
oracle.install.crs.config.clusterNodes=vm4:vm4-vip,vm5:vm5-vip
oracle.install.crs.config.networkInterfaceList=eth0:192.168.12.0:1,eth1:10.1.1.0:2
oracle.install.crs.config.storageOption=ASM_STORAGE
oracle.install.crs.config.sharedFileSystemStorage.diskDriveMapping=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskLocations=
oracle.install.crs.config.sharedFileSystemStorage.votingDiskRedundancy=NORMAL
oracle.install.crs.config.sharedFileSystemStorage.ocrLocations=
oracle.install.crs.config.sharedFileSystemStorage.ocrRedundancy=NORMAL
oracle.install.crs.config.useIPMI=false
oracle.install.crs.config.ipmi.bmcUsername=
oracle.install.crs.config.ipmi.bmcPassword=
oracle.install.asm.SYSASMPassword=oracle
oracle.install.asm.diskGroup.name=dg1
oracle.install.asm.diskGroup.redundancy=NORMAL
oracle.install.asm.diskGroup.AUSize=1
oracle.install.asm.diskGroup.disks=/dev/raw/raw1,/dev/raw/raw2
oracle.install.asm.diskGroup.diskDiscoveryString=/dev/raw/*
oracle.install.asm.monitorPassword=oracle
oracle.install.crs.upgrade.clusterNodes=
oracle.install.asm.upgradeASM=false
oracle.installer.autoupdates.option=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
[grid@vm4 grid]$ ./runInstaller -silent -responseFile /home/grid/grid_install.rsp -ignorePrereq -showProgress
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 8449 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1999 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-20_02-33-47PM. Please wait ...
[WARNING] [INS-30011] The SYS password entered does not conform to the Oracle recommended standards.
CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
ACTION: Provide a password that conforms to the Oracle recommended standards.
[WARNING] [INS-30011] The ASMSNMP password entered does not conform to the Oracle recommended standards.
CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
ACTION: Provide a password that conforms to the Oracle recommended standards.
You can find the log of this install session at:
/data/app/oraInventory/logs/installActions2016-12-20_02-33-47PM.log
Prepare in progress.
.................................................. 5% Done.
Prepare successful.
Copy files in progress.
.................................................. 10% Done.
.................................................. 16% Done.
..... ..... ...................................... 21% Done.
.................................................. 26% Done.
Copy files successful.
..........
Link binaries in progress.
Link binaries successful.
.................................................. 34% Done.
Setup files in progress.
Setup files successful.
.................................................. 41% Done.
Perform remote operations in progress.
.................................................. 48% Done.
Perform remote operations successful.
The installation of Oracle Grid Infrastructure was successful.
Please check '/data/app/oraInventory/logs/silentInstall2016-12-20_02-33-47PM.log' for more details.
.................................................. 97% Done.
Execute Root Scripts in progress.
As a root user, execute the following script(s):
1. /data/app/oraInventory/orainstRoot.sh
2. /data/app/11.2.0/grid/root.sh
Execute /data/app/oraInventory/orainstRoot.sh on the following nodes:
[vm4, vm5]
Execute /data/app/11.2.0/grid/root.sh on the following nodes:
[vm4, vm5]
.................................................. 100% Done.
Execute Root Scripts successful.
As install user, execute the following script to complete the configuration.
1. /data/app/11.2.0/grid/cfgtoollogs/configToolAllCommands
Note:
1. This script must be run on the same system from where installer was run.
2. This script needs a small password properties file for configuration assistants that require passwords (refer to install guide documentation).
3 静默安装RDBMS软件
#cd /data/database
#./runInstaller -silent -responseFile /home/oracle/db_install.rsp -ignorePrereq -showProgress
[oracle@vm4 ~]$ egrep -v '^$|#' db_install.rsp
oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
oracle.install.option=INSTALL_DB_AND_CONFIG
ORACLE_HOSTNAME=
UNIX_GROUP_NAME=oinstall
INVENTORY_LOCATION=/data/app/oraInventory
SELECTED_LANGUAGES=en
ORACLE_HOME=/data/app/oracle/product/11.2.0/db_1
ORACLE_BASE=/data/app/oracle
oracle.install.db.InstallEdition=EE
oracle.install.db.EEOptionsSelection=false
oracle.install.db.optionalComponents=oracle.rdbms.partitioning:11.2.0.3.0,oracle.oraolap:11.2.0.3.0,oracle.rdbms.dm:11.2.0.3.0,oracle.rdbms.dv:11.2.0.3.0,oracle.rdbms.lbac:11.2.0.3.0,oracle.rdbms.rat:11.2.0.3.0
oracle.install.db.DBA_GROUP=dba
oracle.install.db.OPER_GROUP=oinstall
oracle.install.db.CLUSTER_NODES=vm4,vm5
oracle.install.db.isRACOneInstall=false
oracle.install.db.racOneServiceName=
oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
oracle.install.db.config.starterdb.globalDBName=racdb
oracle.install.db.config.starterdb.SID=racdb1
oracle.install.db.config.starterdb.characterSet=ZHS16GBK
oracle.install.db.config.starterdb.memoryOption=true
oracle.install.db.config.starterdb.memoryLimit=5000
oracle.install.db.config.starterdb.installExampleSchemas=false
oracle.install.db.config.starterdb.enableSecuritySettings=true
oracle.install.db.config.starterdb.password.ALL=oracle
oracle.install.db.config.starterdb.password.SYS=
oracle.install.db.config.starterdb.password.SYSTEM=
oracle.install.db.config.starterdb.password.SYSMAN=
oracle.install.db.config.starterdb.password.DBSNMP=
oracle.install.db.config.starterdb.control=DB_CONTROL
oracle.install.db.config.starterdb.gridcontrol.gridControlServiceURL=
oracle.install.db.config.starterdb.automatedBackup.enable=false
oracle.install.db.config.starterdb.automatedBackup.osuid=
oracle.install.db.config.starterdb.automatedBackup.ospwd=
oracle.install.db.config.starterdb.storageType=ASM_STORAGE
oracle.install.db.config.starterdb.fileSystemStorage.dataLocation=
oracle.install.db.config.starterdb.fileSystemStorage.recoveryLocation=
oracle.install.db.config.asm.diskGroup=DG1
oracle.install.db.config.asm.ASMSNMPPassword=oracle
MYORACLESUPPORT_USERNAME=
MYORACLESUPPORT_PASSWORD=
SECURITY_UPDATES_VIA_MYORACLESUPPORT=
DECLINE_SECURITY_UPDATES=true
PROXY_HOST=
PROXY_PORT=
PROXY_USER=
PROXY_PWD=
PROXY_REALM=
COLLECTOR_SUPPORTHUB_URL=
oracle.installer.autoupdates.option=
oracle.installer.autoupdates.downloadUpdatesLoc=
AUTOUPDATES_MYORACLESUPPORT_USERNAME=
AUTOUPDATES_MYORACLESUPPORT_PASSWORD=
[oracle@vm4 database]$ ./runInstaller -silent -responseFile /home/oracle/db_install.rsp -ignorePrereq -showProgress
Starting Oracle Universal Installer...
Checking Temp space: must be greater than 120 MB. Actual 8231 MB Passed
Checking swap space: must be greater than 150 MB. Actual 1999 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-12-20_04-52-03PM. Please wait ...[oracle@vm4 database]$ [WARNING] [INS-30011] The ADMIN password entered does not conform to the Oracle recommended standards.
CAUSE: Oracle recommends that the password entered should be at least 8 characters in length, contain at least 1 uppercase character, 1 lower case character and 1 digit [0-9].
ACTION: Provide a password that conforms to the Oracle recommended standards.
You can find the log of this install session at:
/data/app/oraInventory/logs/installActions2016-12-20_04-52-03PM.log
Prepare in progress.
.................................................. 8% Done.
Prepare successful.
Copy files in progress.
.................................................. 13% Done.
.................................................. 18% Done.
.................................................. 23% Done.
..........
[oracle@vm4 database]$
[oracle@vm4 database]$ ........................................ 28% Done.
.................................................. 33% Done.
.................................................. 38% Done.
.................................................. 43% Done.
....................
Copy files successful.
Link binaries in progress.
..........
Link binaries successful.
.................................................. 53% Done.
Setup files in progress.
Setup files successful.
.................................................. 65% Done.
Perform remote operations in progress.
.................................................. 76% Done.
Perform remote operations successful.
The installation of Oracle Database 11g was successful.
Please check '/data/app/oraInventory/logs/silentInstall2016-12-20_04-52-03PM.log' for more details.
Oracle Database Configuration Assistant in progress.
.................................................. 95% Done.
Oracle Database Configuration Assistant failed.
[WARNING] [INS-32091] Some of the configuration assistants failed.
CAUSE: Software installation was successful. But some configuration assistants failed, were cancelled or skipped.
ACTION: Refer to the logs or contact Oracle Support Services.
注意：本次安装想一次性安装软件和创建数据库的，在response file时也是给定的oracle.install.option=INSTALL_DB_AND_CONFIG的配置，但是该步骤只安装成功软件，所以建议只安装软件，选择oracle.install.option= INSTALL_DB_SWONLY，同时后面的oracle.install.db.*等选项都可以不配置。
l 安装过程中遇到的问题：
安装Oracle 11.2.0.3 RAC数据库时出现了INS-35354的问题
INS-35354: The system on which you are attempting to install Oracle RAC is not part of a valid cluster.
Cause: Prior to installing Oracle RAC, you must create a valid cluster.
解决方法：在inventory.xml中的HOME NAME项增加CRS="true"，如下：
[root@vm4 db_1]# cat /data/app/oraInventory/ContentsXML/inventory.xml
<?xml version="1.0" standalone="yes" ?>
<!-- Copyright (c) 1999, 2011, Oracle. All rights reserved. -->
<!-- Do not modify the contents of this file by hand. -->
<INVENTORY>
<VERSION_INFO>
<SAVED_WITH>11.2.0.3.0</SAVED_WITH>
<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>
</VERSION_INFO>
<HOME_LIST>
<HOME NAME="Ora11g_gridinfrahome1" LOC="/data/app/11.2.0/grid" TYPE="O" IDX="1" CRS="true">
<NODE_LIST>
<NODE NAME="vm4"/>
<NODE NAME="vm5"/>
</NODE_LIST>
</HOME>
<HOME NAME="OraDb11g_home1" LOC="/data/app/oracle/product/11.2.0/db_1" TYPE="O" IDX="2">
<NODE_LIST>
<NODE NAME="vm4"/>
<NODE NAME="vm5"/>
</NODE_LIST>
</HOME>
</HOME_LIST>
<COMPOSITEHOME_LIST>
</COMPOSITEHOME_LIST>
</INVENTORY>
4 静默安装监听
在用户grid配置监听：
$GRID_HOME/bin/netca -silent -responsefile /home/grid/netca.rsp
$ more /u02/soft/database/response/netca.rsp
[GENERAL]
RESPONSEFILE_VERSION="11.2"
CREATE_TYPE="CUSTOM"
[oracle.net.ca]
INSTALLED_COMPONENTS={"server","net8","javavm"}
INSTALL_TYPE=""typical""
LISTENER_NUMBER=1
LISTENER_NAMES={"LISTENER"}
LISTENER_PROTOCOLS={"TCP;1521"}
LISTENER_START=""LISTENER""
NAMING_METHODS={"TNSNAMES","ONAMES","HOSTNAME"}
NSN_NUMBER=1
NSN_NAMES={"EXTPROC_CONNECTION_DATA"}
NSN_SERVICE={"PLSExtProc"}
NSN_PROTOCOLS={"TCP;HOSTNAME;1521"}
[grid@vm4 ~]$ netca -silent -responsefile /home/grid/netca.rsp
Parsing command line arguments:
Parameter "silent" = true
Parameter "responsefile" = /home/grid/netca.rsp
Done parsing command line arguments.
Oracle Net Services Configuration:
Profile configuration complete.
Profile configuration complete.
vm4...
vm5...
Oracle Net Listener Startup:
Listener started successfully.
Listener configuration complete.
Oracle Net Services configuration successful. The exit code is 0
5 静默创建数据库
$ORACLE_HOME/bin/dbca -silent -responseFile /home/oracle/dbca.rsp
[oracle@vm4 database]$ egrep -v '^$|#' ~/dbca.rsp
[GENERAL]
RESPONSEFILE_VERSION = "11.2.0"
OPERATION_TYPE = "createDatabase"
[CREATEDATABASE]
GDBNAME = "racdb"
SID = "racdb"
NODELIST=vm4,vm5
TEMPLATENAME = "General_Purpose.dbc"
SYSPASSWORD = "oracle"
SYSTEMPASSWORD = "oracle"
EMCONFIGURATION = "CENTRAL" --CENTRAL参数导致配置失败，应该LOCAL
SYSMANPASSWORD = "oracle"
DBSNMPPASSWORD = "oracle"
STORAGETYPE=ASM
DISKGROUPNAME=DG1
ASMSNMP_PASSWORD="oracle"
CHARACTERSET = "ZHS16GBK"
NATIONALCHARACTERSET= "AL16UTF16"
SAMPLESCHEMA=TRUE
MEMORYPERCENTAGE = "40"
DATABASETYPE = "MULTIPURPOSE"
AUTOMATICMEMORYMANAGEMENT = "TRUE"
TOTALMEMORY = "5000"
[oracle@vm4 database]$ cat /data/app/oracle/cfgtoollogs/dbca/racdb/racdb.log
Copying database files
Unable to copy the file "vm5:/tmp/oratab.vm5" to "/etc/oratab".
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 3%
DBCA_PROGRESS : 9%
DBCA_PROGRESS : 15%
DBCA_PROGRESS : 21%
DBCA_PROGRESS : 27%
DBCA_PROGRESS : 30%
Creating and starting Oracle instance
DBCA_PROGRESS : 32%
DBCA_PROGRESS : 36%
DBCA_PROGRESS : 40%
DBCA_PROGRESS : 44%
DBCA_PROGRESS : 45%
DBCA_PROGRESS : 48%
DBCA_PROGRESS : 50%
Creating cluster database views
DBCA_PROGRESS : 52%
DBCA_PROGRESS : 70%
Completing Database Creation
DBCA_PROGRESS : 73%
DBCA_PROGRESS : 76%
DBCA_PROGRESS : 85%
Enterprise manager configuration failed due to the following error -
Error configuring central management. This target will not be centrally managed
Refer to the log file at /data/app/oracle/cfgtoollogs/dbca/racdb/emConfig.log for more details.
You can retry configuring this database with Enterprise Manager later by manually running /data/app/oracle/product/11.2.0/db_1/bin/emca script.
DBCA_PROGRESS : 94%
DBCA_PROGRESS : 100%
Database creation complete. For details check the logfiles at:
/data/app/oracle/cfgtoollogs/dbca/racdb.
Database Information:
Global Database Name:racdb
System Identifier(SID) Prefix:racdb
至此，11g RAC环境搭建成功，数据库创建完成！
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16976507/viewspace-2131325/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/16976507/viewspace-2131325/
扫一扫
1371
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
