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 要求各節點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.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

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 soft nofile 131072

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 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/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" ?>

<VERSION_INFO>

<SAVED_WITH>11.2.0.3.0</SAVED_WITH>

<MINIMUM_VER>2.1.0.6.0</MINIMUM_VER>

</VERSION_INFO>

<HOME_LIST>

<NODE_LIST>

</NODE_LIST>

</HOME>

<NODE_LIST>

</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.

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環境搭建成功，資料庫建立完成！

Oracle 11gr2 RAC on OEL6.4靜默安裝

1 安裝前準備

1.1 檢查硬體

1.2 檢查軟體

1.3 使用者的配置

1.4 網路配置

1.5 核心引數

1.6 SSH等效性

1.7 時間同步（NTP、CTSS）

1.8 raw裝置配置

1.9 關閉防火牆

1.10 準備安裝介質

1.11 校驗cluster安裝環境

2 靜默安裝Grid

3 靜默安裝RDBMS軟體

4 靜默安裝監聽

5 靜默建立資料庫

相關文章