整理时间:2013年10月
1.准备工作
安装环境说明:
OS:RHEL5.5 x86_64
Oracle:oracle 11.2.0.3.5
Oracle:oracle 11.2.0.3.5
OCR+Vote Disk | 至少需要3块5G的共享盘,因为vote disk需要奇数个盘,用来进行仲裁,其中2个盘与1个盘效果一样,4个盘与3个盘效果一样。 如果为3个盘,则DG创建为normal,若为5个盘,则创建high,若外外部冗余,不管DG有多少个盘,votedisk只能是一个。 |
网卡信息 | ?至少需要2个网卡,一个为公用对外提供访问的网卡,一个为内部私用通信网卡 |
DATA数据盘 | ?大小要一致,且单个盘建议不超过500G,本系统暂时使用1T的盘 |
SCAN IP | ?由于本库还是采用VIP访问数据库,因此采用/etc/hosts绑定 |
| |
134.64.114.91 hbdb1
134.64.114.92 hbdb2
134.64.114.93 hbdb3
134.64.114.94 hbdb4
134.64.114.97 hbdb1-vip
134.64.114.98 hbdb2-vip
134.64.114.99 hbdb3-vip
134.64.114.100 hbdb4-vip
134.64.114.101 hbdb-cluster hbdb-cluster-scan
192.168.114.91 hbdb1-priv
192.168.114.92 hbdb2-priv
192.168.114.93 hbdb3-priv
192.168.114.94 hbdb4-priv
--配置私有通信网络
#
vi /etc/sysconfig/network-scripts/ifcfg-eth1
--修改
BOOTPROTO=none 并添加:
IPADDR=192.168.114.91
NETMASK=255.255.255.0
IPV6INIT=no
PEERDNS=yes
# service network restart --或者
#
/etc/init.d/network restart
- 关闭防火墙
#
chkconfig iptables off
#chkconfig ip6tables off
--检查状态
#
chkconfig --list iptables
- 关闭SELinux
#
vi /etc/selinux/config
==>SELINUX=disabled
--生效
#
setenforce 0
groupadd -g 5000 asmadmin
groupadd -g 5001 asmdba
groupadd -g 5002 asmoper
groupadd -g 6000 oinstall
groupadd -g 6001 dba
groupadd -g 6002 oper
useradd -g oinstall -G asmadmin,asmdba,asmoper grid
useradd -g oinstall -G dba,asmdba oracle
passwd oracle
passwd grid
mkdir -p /oracle11/app/grid
mkdir -p /oracle11/app/11.2.0/grid
chown -R grid:oinstall /oracle11
mkdir -p /oracle11/app/oracles
mkdir -p /oracle11/app/oracle/product/11.2.0/db_1
chown oracle:oinstall /oracle11/app/oracle
chmod -R 775 /oracle11
Oracle在安装linux 5下所需要的安装包:
Asianux Server 3, Oracle Linux 5, and Red Hat Enterprise Linux 5 | The following packages (or later versions) must be installed:
binutils-2.17.50.0.6
compat-libstdc++-33-3.2.3
compat-libstdc++-33-3.2.3 (32 bit)
elfutils-libelf-0.125
elfutils-libelf-devel-0.125
gcc-4.1.2
gcc-c++-4.1.2
glibc-2.5-24
glibc-2.5-24 (32 bit)
glibc-common-2.5
glibc-devel-2.5
glibc-devel-2.5 (32 bit)
glibc-headers-2.5
ksh-20060214
libaio-0.3.106
libaio-0.3.106 (32 bit)
libaio-devel-0.3.106
libaio-devel-0.3.106 (32 bit)
libgcc-4.1.2
libgcc-4.1.2 (32 bit)
libstdc++-4.1.2
libstdc++-4.1.2 (32 bit)
libstdc++-devel 4.1.2
make-3.81
numactl-devel-0.9.8.x86_64
sysstat-7.0.2
unixODBC-2.2.11 (32 bit) or later
unixODBC-devel-2.2.11 (64 bit) or later
unixODBC-2.2.11 (64 bit) or later |
rpm -Uvh binutils-2.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh elfutils-libelf-devel-*
rpm -Uvh gcc-4.*
rpm -Uvh gcc-c++-4.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh glibc-devel-2.*
rpm -Uvh glibc-headers-2.*
rpm -Uvh ksh-2*
rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh libgcc-4.*
rpm -Uvh libstdc++-4.*
rpm -Uvh libstdc++-devel-4.*
rpm -Uvh make-3.*
rpm -Uvh sysstat-7.*
rpm -Uvh unixODBC-2.*
rpm -Uvh unixODBC-devel-2.*
#vi /etc/security/limits.conf
oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536
oracle soft stack 10240
grid soft nproc 2047
grid hard nproc 16384
grid soft nofile 1024
grid hard nofile 65536
grid soft stack 10240
#vi /etc/sysctl.conf中添加如下信息:kernel.shmall如果设置太小则修改,其它均需要添加到这个文件中。
kernel.shmall = 4294967296
kernel.shmmni=4096
kernel.sem=250 32000 100 128
fs.file-max=6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range=9000 65500
net.core.rmem_default=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586
--使此内核更改立即生效:
#sysctl -p
在Linux,Memory Size (SGA and PGA)不能大于/dev/shm,因此需要调大共享内存大小:
--
查看系统内存、交换分区信息:
#grep MemTotal /proc/meminfo
#grep SwapTotal /proc/meminfo
#free
--调整共享内存
#umount tmpfs
#mount -t tmpfs shmfs -o size=25G /dev/shm
#df -h /dev/shm
#vi /etc/fstab
shms /dev/shm tmpfs size=25G 0
--oracle
export ORACLE_UNQNAME =hbdb
export ORACLE_BASE = /oracle11 /app /oracle
export ORACLE_HOME =$ORACLE_BASE /product / 11. 2. 0 /dbhome_1
export PATH =$ORACLE_HOME /bin :$ORACLE_HOME /OPatch : /sbin : /bin : /usr /sbin : /usr /bin
export ORACLE_SID =hbdb2
export LD_LIBRARY_PATH =$ORACLE_HOME /lib :$ORACLE_HOME /lib32
export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
alias log = 'cd ${ORACLE_BASE}/diag/rdbms/hbdb/${ORACLE_SID}/trace'
--grid
export ORACLE_SID = +ASM2
export ORACLE_BASE = /oracle11 /app /grid
export ORACLE_HOME = /oracle11 /app / 11. 2. 0 /grid
export ORA_NLS10 =$ORACLE_HOME /nls /data
export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export PATH =$GRID_HOME /bin :$ORACLE_HOME /bin :$ORACLE_HOME /OPatch : /sbin : /bin : /usr /sbin : /usr /bin
export LD_LIBRARY_PATH =$GRID_HOME /lib :$ORACLE_HOME /lib :$ORACLE_HOME /lib32
alias log = 'cd $ORACLE_BASE/diag/asm/+asm/$ORACLE_SID/trace'
alias crslog = 'cd $ORACLE_HOME/log/`hostname`
export ORACLE_UNQNAME =hbdb
export ORACLE_BASE = /oracle11 /app /oracle
export ORACLE_HOME =$ORACLE_BASE /product / 11. 2. 0 /dbhome_1
export PATH =$ORACLE_HOME /bin :$ORACLE_HOME /OPatch : /sbin : /bin : /usr /sbin : /usr /bin
export ORACLE_SID =hbdb2
export LD_LIBRARY_PATH =$ORACLE_HOME /lib :$ORACLE_HOME /lib32
export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
alias log = 'cd ${ORACLE_BASE}/diag/rdbms/hbdb/${ORACLE_SID}/trace'
--grid
export ORACLE_SID = +ASM2
export ORACLE_BASE = /oracle11 /app /grid
export ORACLE_HOME = /oracle11 /app / 11. 2. 0 /grid
export ORA_NLS10 =$ORACLE_HOME /nls /data
export NLS_LANG = "SIMPLIFIED CHINESE_CHINA.ZHS16GBK"
export PATH =$GRID_HOME /bin :$ORACLE_HOME /bin :$ORACLE_HOME /OPatch : /sbin : /bin : /usr /sbin : /usr /bin
export LD_LIBRARY_PATH =$GRID_HOME /lib :$ORACLE_HOME /lib :$ORACLE_HOME /lib32
alias log = 'cd $ORACLE_BASE/diag/asm/+asm/$ORACLE_SID/trace'
alias crslog = 'cd $ORACLE_HOME/log/`hostname`
#AS5版本下执行此进行绑定
for i in c d e;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id -g -u -s %p\", RESULT==\"`/sbin/scsi_id -g -u -s /block/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc /udev /rules.d / 99 -oracle -asmdevices.rules
done
#more /etc/udev/rules.d/99-oracle-asmdevices.rules
--生效
#/sbin/start_udev
--验证
# ls -l /dev/asm*
for i in c d e;
do
echo "KERNEL==\"sd*\", BUS==\"scsi\", PROGRAM==\"/sbin/scsi_id -g -u -s %p\", RESULT==\"`/sbin/scsi_id -g -u -s /block/sd$i`\", NAME=\"asm-disk$i\", OWNER=\"grid\", GROUP=\"asmadmin\", MODE=\"0660\"" >> /etc /udev /rules.d / 99 -oracle -asmdevices.rules
done
#more /etc/udev/rules.d/99-oracle-asmdevices.rules
--生效
#/sbin/start_udev
--验证
# ls -l /dev/asm*
--根据需求,设置NTP同步服务。
修改ntpd参数:
#vi /etc/sysconfig/ntpd
将:OPTIONS = "-u ntp:ntp -p /var/run/ntpd.pid" 修改成:OPTIONS = "-x -u ntp:ntp -p /var/run/ntpd.pid"
如果时钟服务器比同步的服务器时间慢,则同步服务器会做一个很大的减小时间的调整,这样会导致数据库shutdown,当添加 -x参数后,ntp会自动的减慢同步服务器的时钟速度,直到时钟服务器与同步服务器的时间一致。
修改ntpd参数:
#vi /etc/sysconfig/ntpd
将:OPTIONS = "-u ntp:ntp -p /var/run/ntpd.pid" 修改成:OPTIONS = "-x -u ntp:ntp -p /var/run/ntpd.pid"
如果时钟服务器比同步的服务器时间慢,则同步服务器会做一个很大的减小时间的调整,这样会导致数据库shutdown,当添加 -x参数后,ntp会自动的减慢同步服务器的时钟速度,直到时钟服务器与同步服务器的时间一致。
2.数据库安装
2.1.cluster安装
#su - grid
$unzip p10404530_112030_Linux -x86 - 64_3of7.zip -d grid_11203
--在每个节点安装此rpm包
#cd /oracle11/grid_11203/grid/rpm
#rpm -Uvh cvuqdisk-1.0.9-1.rpm
$export DISPLAY = 134. 64. 93. 153 : 0. 0
打开xmanager passive
. /grid_11203 /grid /runInstaller
$unzip p10404530_112030_Linux -x86 - 64_3of7.zip -d grid_11203
--在每个节点安装此rpm包
#cd /oracle11/grid_11203/grid/rpm
#rpm -Uvh cvuqdisk-1.0.9-1.rpm
$export DISPLAY = 134. 64. 93. 153 : 0. 0
打开xmanager passive
. /grid_11203 /grid /runInstaller
![25704976_1402458033sNfB.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458033sNfB.png)
![25704976_140245799879lP.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_140245799879lP.png)
![25704976_1402458035VneV.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458035VneV.png)
![25704976_14024579991ZtE.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024579991ZtE.png)
![25704976_1402458036I2z2.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458036I2z2.png)
![25704976_14024580009G0W.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580009G0W.png)
![25704976_1402458037qqY4.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458037qqY4.png)
![25704976_1402458001aer4.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458001aer4.png)
![25704976_1402458039msYZ.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458039msYZ.png)
![25704976_1402458003D093.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458003D093.png)
![25704976_1402458040UfIz.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458040UfIz.png)
![25704976_14024580040Qw3.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580040Qw3.png)
![25704976_140245804128Yt.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_140245804128Yt.jpg)
![25704976_14024580052uqz.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580052uqz.png)
![25704976_14024580427S4f.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580427S4f.png)
![25704976_14024580431Yzh.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580431Yzh.png)
![25704976_140245804470SU.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_140245804470SU.png)
![25704976_1402458007buT8.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458007buT8.jpg)
![25704976_1402458008iM4D.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458008iM4D.png)
![25704976_1402458046SreI.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458046SreI.png)
![25704976_1402458010JAQY.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458010JAQY.png)
![25704976_1402458047Z61S.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458047Z61S.jpg)
![25704976_1402458010M3ZO.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458010M3ZO.jpg)
大致步骤如下:
1.skip software updates
2.install and configure oracle grid infrastructure for a cluster
3.advanced installation
4.english
5.修改scan name为/etc/hosts下的scan name,并取消GNS
6.add node2,并设置 ssh connectivity的grid 密码,setup安装ssh,完成后,点击test
7.next
8.Oracle Automastic Storage Management
9.创建卷组、选择镜像模式、添加disk
10.设置密码
11.do not user ipmi
12.next
13.next
14.next
15.自检后,若存在警告等,点击 fixed&check again 执行里面的脚本(其中asm warning,和ntp、resolv.conf failed 一般可以忽略)
16.install
17.安装中(其中ins-20802可以忽略)
18.安装完毕
CRS与VOTE DISK检查:
[grid@hbdb1 oracle11]$ ocrcheck
Oracle 集群注册表的状态如下:
版本 : 3
总空间 (KB) : 262120
已用空间 (KB) : 2896
可用空间 (KB): 259224
ID : 607428685
设备/文件名 : +CRS
设备/文件完整性检查成功
设备/文件尚未配置
设备/文件尚未配置
设备/文件尚未配置
设备/文件尚未配置
集群注册表完整性检查成功
由于用户未经授权, 因此忽略逻辑损坏检查
[grid@hbdb1 oracle11]$ crsctl query css votedisk
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 7092be7fdea64f3abf4eaee22c70a28f (/dev/asm-diskc) [CRS]
找到了 1 个表决磁盘。
#su - oracle
$unzip p10404530_112030_Linux-x86-64_1of7.zip -d orabase_11203
$unzip p10404530_112030_Linux-x86-64_2of7.zip -d orabase_11203
$export DISPLAY=134.64.93.153:0.0
打开xmanager passive
./
orabase_11203
/database/runInstaller
![25704976_1402458048k4Gk.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458048k4Gk.png)
![25704976_1402458012y0hX.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458012y0hX.png)
![25704976_14024580125E4R.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580125E4R.png)
![25704976_14024580509jOo.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580509jOo.png)
![25704976_140245801460dD.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_140245801460dD.png)
![25704976_1402458014xI3I.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458014xI3I.png)
![25704976_1402458015BM8K.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458015BM8K.png)
![25704976_1402458052rpKV.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458052rpKV.png)
![25704976_1402458016yo0Z.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458016yo0Z.png)
![25704976_1402458054sPYO.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458054sPYO.png)
![25704976_1402458054M2Gp.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458054M2Gp.png)
![25704976_14024580186gu9.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580186gu9.jpg)
大致安装过程如下:
1.取消support,next
2.skip software updates
3.install database software only
4.设置ssh connectivity
5.english
6.enterprise edition
7.next
8.next
9.忽略掉3个错误
10.instll
11.安装中
12.安装完毕
Oracle Grid Infrastructure Patch Set Update 11.2.0.3.5 (Includes Database PSU 11.2.0.3.5) - 14727347
默认安装完成后,opatch的版本为11.2.0.1.7,安装PSU需要11.2.0.3.0或者以上版本
[grid@hbdb1 ~]$
opatch version
Invoking OPatch 11.2.0.1.7
OPatch Version: 11.2.0.1.7
OPatch succeeded.
升级opatch,注:opatch auto存在问题,建议local一个个升级
[
grid@hbdb1 oracle11]$
unzip /oracle11/p6880880_112000_Linux-x86-64.zip -d
$ORACLE_HOME
--选择ALL替换
[grid@hbdb1 oracle11]$
opatch version
OPatch Version: 11.2.0.3.3
OPatch succeeded.
[oracle@hbdb1 oracle11]$
unzip /oracle11/p6880880_112000_Linux-x86-64.zip -d $ORACLE_HOME
--选择ALL替换
[
oracle@hbdb1 oracle11]$
opatch version
OPatch Version: 11.2.0.3.3
OPatch succeeded.
升级cluster
[grid@hbdb1 oracle11]$
opatch lspatches --检查PSU补丁
There are no Interim patches installed in this Oracle Home.
OPatch Version: 11.2.0.3.3
OPatch succeeded.
--停CRS等服务,并且释放一下grid文件的一些权限
[root@hbdb1 ~]#
/oracle11/app/11.2.0/grid/crs/install/rootcrs.pl -unlock
su - grid
[grid@hbdb1 oracle11]$
unzip p14727347_112030_Linux-x86-64.zip -d p14727347
opatch napply -oh $ORACLE_HOME -local /oracle11/p14727347/14727310
opatch napply -oh $ORACLE_HOME -local /oracle11/p14727347/15876003
--分别在后面的节点执行以上命令,升级cluster
[grid@hbdb1 p14727347]$
opatch lspatches
15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347)
14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
升级数据库
[oracle@hbdb1 oracle11]$
opatch lspatches
There are no Interim patches installed in this Oracle Home.
--保存一些重要的配置信息
[oracle@hbdb1 oracle11]$
/oracle11/p14727347/15876003/custom/server/15876003/custom/scripts/prepatch.sh -dbhome $ORACLE_HOME
/oracle11/p14727347/15876003/custom/server/15876003/custom/scripts/prepatch.sh completed successfully.
opatch napply -oh $ORACLE_HOME -local /oracle11/p14727347/15876003/custom/server/15876003
opatch napply -oh $ORACLE_HOME -local /oracle11/p14727347/14727310
--
[oracle@hbdb2 ~]$
/oracle11/p14727347/15876003/custom/server/15876003/custom/scripts/postpatch.sh -dbhome $ORACLE_HOME
--分别在后面的节点执行以上命令,升级数据库软件
[oracle@hbdb1 oracle11]$ opatch lspatches
14727310;Database Patch Set Update : 11.2.0.3.5 (14727310)
15876003;Grid Infrastructure Patch Set Update : 11.2.0.3.5 (14727347)
su - root
/oracle11/app/11.2.0/grid/rdbms/install/rootadd_rdbms.sh
--启动CRS资源,并添加grid的一些文件权限等
/oracle11/app/11.2.0/grid/crs/install/rootcrs.pl -patch
--至此升级完成
检查资源状态
[grid@hbdb1 ~]$ crsctl stat res -t
admca创建DATA DG
![25704976_140245805565Z1.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_140245805565Z1.png)
dbca
![25704976_1402458019HXo4.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458019HXo4.jpg)
![25704976_1402458020a4Jy.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458020a4Jy.jpg)
![25704976_1402458057FPWg.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458057FPWg.png)
![25704976_1402458021RcuU.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458021RcuU.png)
![25704976_1402458058g2V1.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458058g2V1.png)
![25704976_1402458022oOWU.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458022oOWU.jpg)
![25704976_1402458059IywW.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458059IywW.png)
![25704976_1402458023PETe.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458023PETe.png)
![25704976_1402458064im26.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458064im26.png)
![25704976_1402458064e1w7.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458064e1w7.png)
![25704976_1402458028eCEC.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458028eCEC.jpg)
![25704976_1402458066eE8J.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458066eE8J.png)
![25704976_1402458032lLns.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458032lLns.png)
![25704976_14024580696IYn.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580696IYn.png)
![25704976_1402458033UpLU.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458033UpLU.jpg)
![25704976_1402458033VPUy.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458033VPUy.png)
![25704976_1402458070e1PP.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458070e1PP.png)
--资源检查:
[grid@hbdb1 dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRS_VOTE_01.dg
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.CRS_VOTE_02.dg
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.DATA.dg
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.LISTENER.lsnr
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.asm
ONLINE ONLINE hbdb1 Started
ONLINE ONLINE hbdb2 Started
ONLINE ONLINE hbdb3 Started
ONLINE ONLINE hbdb4 Started
ora.gsd
OFFLINE OFFLINE hbdb1
OFFLINE OFFLINE hbdb2
OFFLINE OFFLINE hbdb3
OFFLINE OFFLINE hbdb4
ora.net1.network
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.ons
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
ora.registry.acfs
ONLINE ONLINE hbdb1
ONLINE ONLINE hbdb2
ONLINE ONLINE hbdb3
ONLINE ONLINE hbdb4
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE hbdb4
ora.cvu
1 ONLINE ONLINE hbdb1
ora.hbdb.db
1 ONLINE ONLINE hbdb1 Open
2 ONLINE ONLINE hbdb2 Open
3 ONLINE ONLINE hbdb3 Open
4 ONLINE ONLINE hbdb4 Open
ora.hbdb1.vip
1 ONLINE ONLINE hbdb1
ora.hbdb2.vip
1 ONLINE ONLINE hbdb2
ora.hbdb3.vip
1 ONLINE ONLINE hbdb3
ora.hbdb4.vip
1 ONLINE ONLINE hbdb4
ora.oc4j
1 ONLINE ONLINE hbdb1
ora.scan1.vip
1 ONLINE ONLINE hbdb4
3.安装中问题:
3.1.SSH等效性问题![25704976_1402458034gvTr.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458034gvTr.png)
INS-06006 错误:原因未知,查看setupssh 日志,也未发现问题,最后手工创建SSH等效性:
[grid@hbdb1 ~]$
mkdir ~/.ssh
[grid@hbdb1 ~]$
chmod 700 ~/.ssh
[grid@hbdb1 ~]$
ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/home/grid/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/grid/.ssh/id_rsa.
Your public key has been saved in /home/grid/.ssh/id_rsa.pub.
The key fingerprint is:
e7:82:1c:e6:f7:e7:1e:5f:0b:28:e8:1c:3b:51:ff:3a grid@hbdb1
The key's randomart image is:
+--[ RSA 2048]----+
| |
| |
| |
| . |
| o S o |
| + +.o .. |
| +o+...o. .|
| oooo.E.+...|
| +. .== .. |
+-----------------+
[grid@hbdb1 ~]$
ssh-keygen -t dsa
Generating public/private dsa key pair.
Enter file in which to save the key (/home/grid/.ssh/id_dsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /home/grid/.ssh/id_dsa.
Your public key has been saved in /home/grid/.ssh/id_dsa.pub.
The key fingerprint is:
be:3c:c3:d8:f8:c7:54:f5:6f:1d:b1:03:49:36:94:3f grid@hbdb1
The key's randomart image is:
+--[ DSA 1024]----+
| o=o |
| .+o. |
| .o.o|
| . E.|
| S . *|
| . . +|
| =.o . |
| o.=.o |
| .++ |
+-----------------+
以上命令在各个节点下依次执行,以下命令在第一个节点执行。
cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh hbdb2 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh hbdb3 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh hbdb4 cat ~/.ssh/id_rsa.pub >> ~/.ssh/authorized_keys
ssh hbdb2 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh hbdb3 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
ssh hbdb4 cat ~/.ssh/id_dsa.pub >> ~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys hbdb2:~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys hbdb3:~/.ssh/authorized_keys
scp ~/.ssh/authorized_keys hbdb4:~/.ssh/authorized_keys
--确保以下执行无问题
$ssh hbdb1 date
$ssh hbdb2 date
$ssh hbdb3 date
$ssh hbdb4 date
$ssh hbdb1-priv date
$ssh hbdb2-priv date
$ssh hbdb3-priv date
$ssh hbdb4-priv date
![25704976_1402458071bbgQ.jpg](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458071bbgQ.jpg)
此问题由于我们采用 /etc/hosts解析 scanip导致,没有采用DNS或者GNS,所以会报错,此错误可以忽略。
![25704976_1402458034dRz5.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_1402458034dRz5.png)
创建OCR的normal的DG,至少需要3个磁盘,创建high的DG,至少需要5个盘。具体原因参考:《A Closer Look inside Oracle ASM》
创建DATA的normal DG,需要2个盘以上,high需要3个盘以上。
3.4.升级中的warning
opatch napply -oh $ORACLE_HOME -local /oracle11/p14727347/14727310 中:
OPatch found the word "warning" in the stderr of the make command.
Please look at this stderr. You can re-run this make command.
Stderr output:
ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/oracle11/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/oracle11/app/oracle/product/11.2.0/dbhome_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/oracle11/app/oracle/product/11.2.0/dbhome_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
参考metalink [ID 1448337.1]:Opatch warning: overriding commands for target xxxx
Solution
This is a warning only which opatch is reporting. The Patch has applied successfully and the warning output can be safely ignored.
![25704976_14024580356Icg.png](http://img.blog.itpub.net/blog/attachment/201406/11/25704976_14024580356Icg.png)
[grid@hbdb1 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): hbdb4,hbdb1,hbdb2
[grid@hbdb3 ~]$ lsnrctl start 后正常
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/25704976/viewspace-1180323/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/25704976/viewspace-1180323/