Oracle Cluster Install

Troubleshooting

Cluster Verification Utility

rpm -q --queryformat="%{NAME}-%{VERSION}-%{ARCH}\n" setarch
[root@OCM RPMS]# cat /etc/hosts
# Do not remove the following line, or various programs
# that require network functionality will fail.
127.0.0.1               OCM.localdomain OCM localhost.localdomain localhost
#Public
192.168.0.101           rac1.localdomain        rac1
192.168.0.102           rac2.localdomain        rac2
#Private
192.168.2.101           rac1-priv.localdomain   rac1-priv
192.168.2.102           rac2-priv.localdomain   rac2-priv
#Virtual
192.168.0.111           rac1-vip.localdomain    rac1-vip
192.168.0.112           rac2-vip.localdomain    rac2-vip
rsh Config
chkconfig rsh on
chkconfig rlogin on
service xinetd reload
touch /etc/hosts.equiv
chmod 600 /etc/hosts.equiv
chown root:root /etc/hosts.equiv
vi /etc/hosts.equiv
+rac1 oracle
+rac2 oracle
+rac1-priv oracle
+rac2-priv oracle
oracle user and nobody user config
# groupadd oinstall
# groupadd dba
# useradd -g oinstall -G dba oracle
# passwd oracle
# id nobody
Oracle user .bash_profile
export EDITOR=vi
export ORACLE_SID=racdb1
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH
umask 022

export EDITOR=vi
export ORACLE_SID=racdb2
export ORACLE_BASE=/home/oracle/app
export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1
export ORA_CRS_HOME=$ORACLE_BASE/product/10.2.0/crs_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$ORA_CRS_HOME/bin:$PATH
umask 022
A.hangcheck timer模块配置
在 /etc/modprobe.conf 中添加以下行,以设置 hangcheck 内核模块参数。 
options hangcheck-timer hangcheck_tick=30 hangcheck_margin=180
B.shell limits和PAM配置
/etc/security/limits.conf 
* soft nproc 2047
* hard nproc 16384
* soft nofile 1024
* hard nofile 65536
/etc/pam.d/login 
Session required /lib/security/pam_limits.so
C.操作系统PACKAGE和KERNEL参数
rpm -q binutils compat-db control-center gcc gcc-c++ glibc gnome-libs libstdc++ libstdc++-devel make openmotif21
------按ORACLE文档
# more /etc/sysctl.conf
kernel.shmall = 2097152
kernel.shmmax = 2147483648
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 65536
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default = 1048576
net.core.rmem_max = 1048576
net.core.wmem_default = 262144
net.core.wmem_max = 262144
配置ocr,voting disk,ASM将要使用的裸设备以及相关裸设备的所有者和权限。
用fdisk创建分区
编辑/etc/sysconfig/rawdevices文件,
/dev/raw/raw1 /dev/sdb1
/dev/raw/raw2 /dev/sdc1
/dev/raw/raw3 /dev/sdd1
执行service rawdevices restart
chown root:oinstall /dev/raw/raw1
chown oracle:dba /dev/raw/raw2
chown oracle:dba /dev/raw/raw3
chmod 660 /dev/raw/raw1
chmod 660 /dev/raw/raw2
chmod 660 /dev/raw/raw3
voting disk的所有者是oracle:dba,权限是660
OCR的所有者是root:oinstall,权限是660
/etc/udev/permissions.d/50-udev.permissions 
# raw devices
ram*:root:disk:0660
#raw/*:root:disk:0660
raw/*:oracle:dba:0660
/etc/init.d/init.crs stop
/etc/init.d/init.crs start
crs_start -all
crs_stat -t

dd if=/dev/null of=/dev/raw/raw1 bs=1024 count=100

dd if=/dev/zero of=/dev/raw/raw1 bs=1024 count=1024

http://www.eygle.com/archives/2007/12/crs_0184_crs_start.html

/etc/init.d/init.crs start
/etc/init.d/init.crs disable crs
/etc/init.d/init.crs stop crs
1 Install Clusterware Software
OraCrs10g_home
/u01/app/oracle/product/10.2.0/crs
Elapse:22:15-

2 crsctl check crs

3 Install Database Software

4 Install ASM

5 Create Database
Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License