• 博客访问: 1912938
  • 博文数量: 580
  • 博客积分: 10716
  • 博客等级: 上将
  • 技术积分: 7226
  • 用 户 组: 普通用户
  • 注册时间: 2008-04-01 22:35
文章分类

全部博文(580)

文章存档

2017年(35)

2016年(22)

2015年(1)

2013年(12)

2012年(20)

2011年(18)

2010年(18)

2009年(271)

2008年(183)

微信关注

IT168企业级官微



微信号:IT168qiye



系统架构师大会



微信号:SACC2013

订阅
热词专题
AIX7.1+11.2.0.4RAC实施 2017-04-07 22:21:02

分类: Oracle

文档说明:以#开始命令表示root用户执行,$开始命令以oracle/grid执行(前面都有切换用户的动作)
==================================================
一.基础环境准备(两个节点都需要做)
==================================================
--------------------------------------------------
1.1.操作系统检查(录屏:<nodename>_os_check.log)
--------------------------------------------------
1).操作系统版本及内核
====================
# bootinfo -K
# uname -s
# oslevel -s

====================
2).系统软件包检查
====================
a).必须软件包
--------------------
# lslpp -l bos.adt.base bos.adt.lib  bos.adt.libm bos.perf.libperfstat \
bos.perf.perfstat bos.perf.proctools xlC.rte
注:xlC.rte 11.1.0.2 or later

--------------------
b).JAVA、C++、Xwindows、ssh
--------------------
# lslpp -l | grep -i ssh

# lslpp -l | grep -i java
注:JAVA建议安装java6_64bit

# lslpp -l | grep -i C++
注:C/C++建议9.0以上

# lslpp -l | grep -i x11|grep -i dt
注:X11需要包含以下包:
  X11.Dt.ToolTalk   
  X11.Dt.bitmaps    
  X11.Dt.helpmin    
  X11.Dt.helprun    
  X11.Dt.lib        
  X11.Dt.rte        
  X11.Dt.ToolTalk          
  X11.Dt.bitmaps            
  X11.Dt.helpmin           
  X11.Dt.rte

====================
3).系统补丁包检查
====================
--------------------
a).ARPAs
--------------------
IZ87216
IZ87564
IZ89165
IZ97035

# instfix -i -k "IZ87216 IZ87564 IZ89165 IZ97035"
注:安装补丁包的时候参考下面的命令
# emgr -e IZ89302.101121.epkg.Z 

--------------------
b).PTFs
--------------------
none

====================
4).内核参数检查
====================
a).ncargs>=256
--------------------
# lsattr -El sys0 -a ncargs
ncargs 256 ARG/ENV list size in 4K byte blocks True
注:修改方式
# chdev -l sys0 -a ncargs='256'

--------------------
b).maxuproc>=16384
--------------------
# lsattr -E -l sys0 -a maxuproc
maxuproc 16384 Maximum number of PROCESSES allowed per user True
注:修改方式
# chdev -l sys0 -a maxuproc=16384

--------------------
c).aio_maxreqs>=65536
--------------------
#  ioo -o aio_maxreqs
aio_maxreqs = 131072
注:修改方式
# ioo –p -o aio_maxreqs=65536

====================
5).检查系统资源限制
====================
确认 /etc/security/limits文件包含:
fsize = -1
core = -1
cpu = -1
data = -1
rss = -1
stack = -1
nofiles = -1

# more /etc/security/limits
注:修改方式
# vi /etc/security/limits

====================
6).网络参数与端口
====================
--------------------
a).网络参数
--------------------
Network Preparation
=======================================
PARAMETER RECOMMENDED              VALUE
ipqmaxlen                         512
rfc1323                           1
sb_max                                41943040
tcp_recvspace                      1048576
tcp_sendspace                      1048576
udp_recvspace                         20971520
udp_sendspace                     2097152

注意:
udp_recvspace:应该是udp_sendspace的10倍,但是必须小于sb_max
udp_sendspace:这个值至少应该是4K+(db_block_size*db_multiblock_read_count)的大小。
--
查看所有的:
# no –a | more
分项查看:
# no -a | fgrep ipqmaxlen
# no -a | fgrep rfc1323
# no -a | fgrep sb_max
# no -a | fgrep tcp_recvspace
# no -a | fgrep tcp_sendspace
# no -a | fgrep udp_recvspace
# no -a | fgrep udp_sendspace

若有值不满足,进行修改:
no -r -o ipqmaxlen=512            
no -p -o rfc1323=1                  
no -p -o sb_max=41943040
no -p -o tcp_recvspace=1048576
no -p -o tcp_sendspace=1048576
no -p -o udp_recvspace=20971520
no -p -o udp_sendspace=2097152

也可以在/etc/rc.net文件里面加入如下内容
if [ -f /usr/sbin/no ] ; then
/usr/sbin/no -o udp_sendspace=2097152
/usr/sbin/no -o udp_recvspace=20971520
/usr/sbin/no -o tcp_sendspace=1048576
/usr/sbin/no -o tcp_recvspace=1048576
/usr/sbin/no -o rfc1323=1
/usr/sbin/no -o sb_max=41943040
/usr/sbin/no -o ipqmaxlen=512
fi

--------------------
b).端口范围
--------------------
# no -a | fgrep ephemeral
       tcp_ephemeral_high = 65500
        tcp_ephemeral_low = 9000
       udp_ephemeral_high = 65500
        udp_ephemeral_low = 9000
调整方式:
#no -p -o tcp_ephemeral_low=9000 -o tcp_ephemeral_high=65500
#no -p -o udp_ephemeral_low=9000 -o udp_ephemeral_high=65500


====================
7).虚拟内存优化
====================
检查:
# vmo -L minperm%
# vmo -L maxperm%
# vmo -L maxclient%
# vmo -L lru_file_repage //此参数已经不是可优化参数
# vmo -L strict_maxclient
# vmo -L strict_maxperm

调整:
# vmo -p -o minperm%=3
# vmo -p -o maxperm%=90
# vmo -p -o maxclient%=90
# vmo -p -o lru_file_repage=0
# vmo -p -o strict_maxclient=1
# vmo -p -o strict_maxperm=0

====================
8).内存和paging space
====================
--------------------
a).检查内存(至少2.5G):
--------------------
# lsattr -E -l sys0 -a realmem

--------------------
b).检查交换空间:
--------------------
# lsps -a
注:内存小于16G建议设置成内存大小,内存大于16G则设置成16G
# chps -s 10 hd6 (lsvg rootvg查看PP SIZE大小,扩展10个PP)

====================
9).文件系统空间检查
====================
# df -g
临时文件系统至少1G;
安装软件文件系统至少50G

====================
10).重启
====================
如果在check过程中对以上参数进行过修改,建议进行重启之后再进行后续操作
# shutdown -Fr
--------------------------------------------------
1.2.配置IP地址解析(录屏:<node_name>_pre-install.log)
--------------------------------------------------
# vi /etc/hosts
保留回环地址之外加入:
#public ip
129.1.1.124   p740a
129.1.1.125   p740b

#private ip
1.1.1.9       p740a-priv
1.1.1.10      p740b-priv

#vip
129.1.1.224   p740a-vip
129.1.1.225   p740b-vip

#scanip
129.1.1.226    cluster-scanip

--------------------------------------------------
1.3.时间同步配置
--------------------------------------------------
1).确认时区和NTP状态
====================
# echo $TZ                                                       确认时区是否和原生产系统一致
# lssrc -s xntpd                          查看NTP服务的状态
# stopsrc -s xntpd                        关闭NTP服务

====================
2).使用ctssd服务配置方式
====================
##使用ctssd服务进行时间同步:
# mv /etc/ntp.conf /etc/ntp.conf.bak          重命名NTP的配置文件,防止ctss安装成observer状态
在Grid Infrastructure软件安装以后,用grid用户查看时间同步服务是否处于活动状态:
# su - grid
$ crsctl stat resource ora.ctssd -t -init

====================
3).使用NTP配置方式
====================
为了保证NTP不往回同步时间需要编辑以下内容:
# vi /etc/rc.tcpip
start  /usr/sbin/xntpd  "$src_running"  "-x"
##启动xntpd服务:
# startsrc -s xntpd -a "-x"

--------------------------------------------------
1.4.创建系统组、用户
--------------------------------------------------
====================
1).存在性检查
====================
--------------------
a).检查
--------------------
# id oracle
# id grid
# more /etc/passwd
# more /etc/group
//如果用户已经存在,需要确认这些参数。最好是删除重建用户和组,保证正确性

--------------------
b).删除用户方案
--------------------
# rmuser -p oracle
# rmuser -p grid
# rm -rf /home/oracle
# rm -rf /home/grid
注:跳过步骤c)到创建用户

--------------------
c).保留用户方案
--------------------
# lsuser -a capabilities grid
# lsuser -a capabilities oracle
# chuser -a capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid|oracle
# grep oinstall /etc/group
# more /etc/oraInst.loc
注:查看是否有用户,组,是否安装过Oracle的产品,如果检查通过则跳过创建用户步骤。

====================
2).创建系统组、用户
====================
a).创建系统组
--------------------
# mkgroup -'A' id='501' adms='root' oinstall
# mkgroup -'A' id='502' adms='root' asmadmin
# mkgroup -'A' id='503' adms='root' asmdba
# mkgroup -'A' id='504' adms='root' asmoper
# mkgroup -'A' id='505' adms='root' dba
# mkgroup -'A' id='506' adms='root' oper

--------------------
b).创建用户
--------------------
# mkuser id='501' pgrp='oinstall' groups='dba,asmadmin,asmdba,asmoper' home='/home/grid' fsize=-1 cpu=-1 data=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE grid
# mkuser id='502' pgrp='oinstall' groups='dba,asmdba,oper' home='/home/oracle' fsize=-1 cpu=-1 data=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,CAP_BYPASS_RAC_VMM,CAP_PROPAGATE oracle

--------------------
c).检查用户
--------------------
# id oracle
# id grid
# lsuser -a capabilities grid
# lsuser -a capabilities oracle

--------------------
d).修改用户密码
--------------------
# passwd grid
# passwd oracle
# su - grid
# su - oracle
注:建议登录一次图形界面

--------------------------------------------------
1.5.创建安装目录
--------------------------------------------------
以root用户一次执行可跳过后续创建步骤:
mkdir -p /orastg/app/oraInventory
chown -R grid:oinstall /orastg/app/oraInventory
chmod -R 775 /orastg/app/oraInventory
mkdir -p /orastg/app/grid
chown grid:oinstall /orastg/app/grid
chmod -R 775 /orastg/app/grid
mkdir -p /orastg/app/11.2.0/grid
chown -R grid:oinstall /orastg/app/11.2.0/grid
chmod -R 775 /orastg/app/11.2.0/grid
mkdir -p /orastg/app/oracle
mkdir /orastg/app/oracle/cfgtoollogs
chown -R oracle:oinstall /orastg/app/oracle
chmod -R 775 /orastg/app/oracle
mkdir -p /orastg/app/oracle/product/11.2.0/db_1
chown -R oracle:oinstall /orastg/app/oracle/product/11.2.0/db_1
chmod -R 775 /orastg/app/oracle/product/11.2.0/db_1
mkdir -p /home/oracle/upgrdtools
chown -R oracle:oinstall /home/oracle/upgrdtools          //此命令创建存放升级相关文件目录

====================
1).创建oraInventory:
====================
# mkdir -p /orastg/app/oraInventory
# chown -R grid:oinstall /orastg/app/oraInventory
# chmod -R 775 /orastg/app/oraInventory

====================
2).GI_BASE目录
====================
# mkdir -p /orastg/app/grid
# chown grid:oinstall /orastg/app/grid
# chmod -R 775 /orastg/app/grid

====================
3).GI_HOME目录
====================
# mkdir -p /orastg/app/11.2.0/grid
# chown -R grid:oinstall /orastg/app/11.2.0/grid
# chmod -R 775 /orastg/app/11.2.0/grid

====================
4).ORACLE_BASE目录
====================
# mkdir -p /orastg/app/oracle
# mkdir /orastg/app/oracle/cfgtoollogs
# chown -R oracle:oinstall /orastg/app/oracle
# chmod -R 775 /orastg/app/oracle

====================
5).ORACLE_HOME目录
====================
# mkdir -p /orastg/app/oracle/product/11.2.0/db_1
# chown -R oracle:oinstall /orastg/app/oracle/product/11.2.0/db_1
# chmod -R 775 /orastg/app/oracle/product/11.2.0/db_1

--------------------------------------------------
1.6.grid、oracle用户环境变量
--------------------------------------------------
1).grid用户环境变量
====================
# su - grid
$ vi /home/grid/.profile
--加入以下内容:
export ORACLE_BASE=/orastg/app/grid
export ORACLE_HOME=/orastg/app/11.2.0/grid
export JAVA_HOME=/usr/java6_64
#export ORACLE_SID=+ASM2
export AIXTHREAD_SCOPE=S
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$JAVA_HOME/bin:$PATH
umask 022
export PATH=$PATH:$JAVA_HOME/bin

====================
2).oracle用户环境变量:
====================
# su - oracle
$ vi /home/oracle/.profile
--加入以下内容:
export ORACLE_BASE=/orastg/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export JAVA_HOME=/usr/java6_64
export PATH=$ORACLE_HOME/OPatch:$ORACLE_HOME/bin:$JAVA_HOME/bin:$PATH
umask 022
#export ORACLE_SID=addr11g1
export NLS_LANG=AMERICAN_AMERICA.AL32UTF8
export AIXTHREAD_SCOPE=S
export EDITOR=vi

--------------------------------------------------
1.7.grid、oracle用户等同性配置
--------------------------------------------------
1).等同性配置(一个节点root)
====================
# cd /orastg/software/grid/sshsetup
# ./sshUserSetup.sh -user grid -hosts "p740a p740b" -advanced -noPromptPassphrase
# ./sshUserSetup.sh -user oracle -hosts "p740a p740b" -advanced -noPromptPassphrase

====================
2).等同性检查(两个节点oracle,grid)
====================
$ ssh p740a date
$ ssh p740b date
$ ssh p740a-priv date
$ ssh p740b-priv date

--------------------------------------------------
1.8.ASM磁盘准备
--------------------------------------------------
1).检查磁盘映射路径是否一致
====================
# sanlun lun show -p

注:需要保证两边的PVID和盘符对应,不对应则需要用mknod
语法:mknod Name {b|c} Major Minor
mknod datavg b 44 0 表示创建主从设备号44 0的块设备:datatvg
mknod orahdisk c 16 27
ls -l orahdisk
chown oracle:oinstall orahdisk
chmod orahdisk 660

====================
2).检查磁盘的reserve_policy属性
====================
a).检查(确保为:no_reserve)
--------------------
# echo "hdisk2:  `lsattr -E -l hdisk2  |grep reserve_ `" >/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk3:  `lsattr -E -l hdisk3  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk4:  `lsattr -E -l hdisk4  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk5:  `lsattr -E -l hdisk5  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk6:  `lsattr -E -l hdisk6  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk7:  `lsattr -E -l hdisk7  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk8:  `lsattr -E -l hdisk8  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk9:  `lsattr -E -l hdisk9  |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk10: `lsattr -E -l hdisk10 |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log
# echo "hdisk11: `lsattr -E -l hdisk11 |grep reserve_ `" >>/home/oracle/upgrdtools/reserve_policy.log

# cat /home/oracle/upgrdtools/reserve_policy.log

--------------------
b).修改
--------------------
# chdev -l hdisk2  -a reserve_policy=no_reserve
# chdev -l hdisk3  -a reserve_policy=no_reserve
# chdev -l hdisk4  -a reserve_policy=no_reserve
# chdev -l hdisk5  -a reserve_policy=no_reserve
# chdev -l hdisk6  -a reserve_policy=no_reserve
# chdev -l hdisk7  -a reserve_policy=no_reserve
# chdev -l hdisk8  -a reserve_policy=no_reserve
# chdev -l hdisk9  -a reserve_policy=no_reserve
# chdev -l hdisk10 -a reserve_policy=no_reserve
# chdev -l hdisk11 -a reserve_policy=no_reserve

====================
3).PVID处理
====================
a).检查
--------------------
# lspv

--------------------
b).清理
--------------------
# chdev -l hdisk2  -a pv=clear
# chdev -l hdisk3  -a pv=clear
# chdev -l hdisk4  -a pv=clear
# chdev -l hdisk5  -a pv=clear
# chdev -l hdisk6  -a pv=clear
# chdev -l hdisk7  -a pv=clear
# chdev -l hdisk8  -a pv=clear
# chdev -l hdisk9  -a pv=clear
# chdev -l hdisk10 -a pv=clear
# chdev -l hdisk11 -a pv=clear
# lspv

====================
4).格式化磁盘头
====================
# dd if=/dev/zero of=/dev/rhdisk2  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk3  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk4  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk5  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk6  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk7  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk8  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk9  bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk10 bs=1024K count=1
# dd if=/dev/zero of=/dev/rhdisk11 bs=1024K count=1

====================
5).修改磁盘权限
====================
a).修改读写权限
--------------------
# chmod 660 /dev/rhdisk2
# chmod 660 /dev/rhdisk3
# chmod 660 /dev/rhdisk4
# chmod 660 /dev/rhdisk5
# chmod 660 /dev/rhdisk6
# chmod 660 /dev/rhdisk7
# chmod 660 /dev/rhdisk8
# chmod 660 /dev/rhdisk9
# chmod 660 /dev/rhdisk10
# chmod 660 /dev/rhdisk11

--------------------
b).修改属主
--------------------
# chown grid:asmadmin /dev/rhdisk2
# chown grid:asmadmin /dev/rhdisk3
# chown grid:asmadmin /dev/rhdisk4
# chown grid:asmadmin /dev/rhdisk5
# chown grid:asmadmin /dev/rhdisk6
# chown grid:asmadmin /dev/rhdisk7
# chown grid:asmadmin /dev/rhdisk8
# chown grid:asmadmin /dev/rhdisk9
# chown grid:asmadmin /dev/rhdisk10
# chown grid:asmadmin /dev/rhdisk11 

# ls -ltr /dev/ |grep rhdisk

==================================================
二.GI/RDBMS安装配置
==================================================
2.1.安装准备工作
--------------------------------------------------
1).CUV安装预检查(录屏:<nodename>_cuvout.log)
====================
$ cd /orastg/software/
$ unzip p13390677_112040_AIX64-5L_3of7.zip 1>/dev/zero 2>gi.err
$ cd /orastg/software/grid
$ ./runcluvfy.sh stage -pre crsinst -n p740a,p740b -fixup -verbose

====================
2).清理sockets
====================
# rm -rf /tmp/.oracle
# rm –rf /var/tmp/.oracle
# rm -rf /tmp/OraInst*
# rm –rf /opt/ ORCL*

--------------------------------------------------
2.2.GI安装步骤(录屏:<nodename>_gi_isntall.log)
--------------------------------------------------
====================
1).开始安装
====================
# su - grid
$ export DISPLAY=10.1.25.30:0.0 <此IP地址为当前主机IP>
$ cd /orastg/software/grid
$ ./runInstaller
##按照提示,【2个节点】以root执行rootpre.sh脚本
# cd /orastg/software/grid/
# ./rootpre.sh

====================
2).图形化界面
====================
-skip software updates
-Install and Configure Oracle Infrastructure for a Cluster
-Advanced Installation
-增加简体中文后下一步
-关闭GNS后设置集群名和SCAN参数
-添加添加其他节点信息(检测ssh连通性)
-配置网卡
-选择Oracle ASM存放OCR
-选择磁盘创建磁盘组
-设置ASM密码
-确认系统组
-确认ORACLE_BASE和ORACLE_HOME
-确认oraInventory
-等待CUV检测
-check检测不通过问题
-确认基础信息
-等待安装过程中的脚本
-以root用户按照脚本顺序和主机顺序运行脚本(录屏:<nodename>_root_script_out.log)
-等待安装完成

====================
3).后检查工作
====================
a).检查集群状态
--------------------
$ crsctl status resource -t -init
$ crsctl check crs
--------------------
b).检查CTSSD服务
--------------------
$ crsctl check ctss
注:不使用ntp需要确保ctssd服务不是observe状态

--------------------------------------------------
2.3.安装RDBMS(oracle 用户)(录屏:<nodename>_rdbms_install.log)
--------------------------------------------------
1).开始安装
====================
# su - oracle
$ cd /orastg/software
$ unzip p13390677_112040_AIX64-5L_1of7.zip 1>/dev/zero 2>db1.err
$ unzip p13390677_112040_AIX64-5L_2of7.zip 1>/dev/zero 2>db2.err
$ cd /orastg/software/database
$ export DISPLAY=10.1.25.30:0.0
$ ./runInstaller

所有节点按照要求以root用户执行rootpre.sh脚本(两个节点都需要)
# cd /orastg/software/database
# ./rootpre.sh

====================
2).图形界面
====================
-不接受安全更新
-skip software updates
-Install database software only
-Oracle RAC database Installation(还要选择节点)
-增加简体中文到下一步
-选择企业版
-确认ORACLE_BASE,ORACLE_HOME无误
-确认用户组
-等待CVU检查
-检查check不通过问题
-确认配置信息
-等待安装过程
-以root用户按照主机顺序执行root脚本(录屏:<nodename>_root_script_out.log)
--------------------------------------------------
2.4.配置ASM(grid用户)
--------------------------------------------------
$ export DISPLAY=10.1.25.30:0.0
$ asmca
1).创建磁盘组

====================
2.调整ASM参数
====================
# su – grid
# sqlplus / as sysasm
# alter system set memory_max_target=4g sid='*' scope=spfile;
# alter system set memory_target=4g sid='*' scope=spfile;
# alter system  set processes=500 sid='*' scope=spfile;

==================================================
三.GI/RDBMS补丁安装(以下操作两个节点都需要进行)
==================================================
3.1.补丁准备工作录屏:(录屏:<nodename>_pre-patch.log)
--------------------------------------------------
1).停集群
====================
#     /orastg/app/11.2.0/grid/bin/crsctl stop crs -f
====================
2).准备介质
====================
# su - oracle
$ cd /orastg/software/
$ unzip p6880880_112000_AIX64-5L-OPatch_patch.zip 1>/dev/zero 2>optach.err
$ unzip p17478514_112040_AIX64-5L-PSU112041.zip 1>/dev/zero 2>psu.err
$ unzip p18180390_112041_AIX64-5L.zip 1>dev/zero 2>oneoff.err

注:确认所有.err的日志输出文件中无报错

--------------------------------------------------
3.2.安装Opatch(录屏:<nodename>_opatch-patch.log)
--------------------------------------------------
1).OPatch安装(两个节点root)
====================
a).备份原有OPatch并确认
--------------------
# mv /orastg/app/11.2.0/grid/OPatch /orastg/app/11.2.0/grid/OPatch_old
# mv /orastg/app/oracle/product/11.2.0/db_1/OPatch /orastg/app/oracle/product/11.2.0/db_1/OPatch_old
# ls -ltr /orastg/app/11.2.0/grid/ |grep OPatch
# ls -ltr /orastg/app/oracle/product/11.2.0/db_1/ |grep OPatch

--------------------
b).patch安装
--------------------
# cp -r OPatch /orastg/app/11.2.0/grid/
# cp -r OPatch /orastg/app/oracle/product/11.2.0/db_1/
# chown -R oracle:oinstall /orastg/app/oracle/product/11.2.0/db_1/OPatch
# chown -R grid:oinstall /orastg/app/11.2.0/grid/OPatch

====================
2).OPatch版本确认
====================
分别以grid和oracle确认opatch 版本
$ opatch lsinventory

--------------------------------------------------
3.3.安装PSU
--------------------------------------------------
1).清理Lib
====================
a).清理
--------------------
# slibclean

--------------------
b).确认lib是否被占用
--------------------
# genkld |grep oracle
注:需要没有返回结果

====================
2).GI PSU安装(录屏:<nodename>_gi-psu-patch.log)
====================
a).GI_HOME解锁
--------------------
# /orastg/app/11.2.0/grid/crs/install/rootcrs.pl -unlock

--------------------
b).PSU安装检测
--------------------
# su - grid
$ opatch prereq CheckConflictAgainstOHWithDetail -ph /orastg/software/17478514

--------------------
c).正式安装
--------------------
$ opatch apply -oh /orastg/app/11.2.0/grid -local /orastg/software/17478514

--------------------
d).完成
--------------------
# /orastg/app/11.2.0/grid/crs/install/rootcrs.pl -patch
# su - grid
$ opatch lsinventory

====================
3).RDBMS PSU安装(录屏:<nodename>_rdbms-psu-patch.log)
====================
a).停集群
--------------------
# /orastg/app/11.2.0/grid/bin/crsctl stop crs

--------------------
b).PSU安装检测
--------------------
# su - oracle
$ opatch prereq CheckConflictAgainstOHWithDetail -ph /orastg/software/17478514

-------------------
c).正式安装
-------------------
$ opatch apply -oh /orastg/app/oracle/product/11.2.0/db_1 -local /orastg/software/17478514
--检查日志:
cat <file_name> |grep -i error
cat <file_name> |grep -i warning|grep -iv error|grep -v 773|grep -v 224|grep -v 345|grep -v 783|grep -v 415
--------------------
d).完成
--------------------
opatch lsinventory

--------------------------------------------------
3.4.安装one-off补丁(录屏:<nodename>_rdbms-oneoff-patch.log)
--------------------------------------------------
# su - oracle
$ opatch prereq CheckConflictAgainstOHWithDetail -ph /orastg/software/18180390
$ opatch apply -oh /orastg/app/oracle/product/11.2.0/db_1 -local /orastg/software/18180390

--------------------------------------------------
3.5.完成Patch安装(录屏:<nodename>_finish-patch.log)
--------------------------------------------------
1).确认所有Patch
====================
在各个节点以oracle、grid都执行
$ opatch lsinventory

====================
2).启动集群
====================
# /orastg/app/11.2.0/grid/bin/crsctl start crs
阅读(241) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~
评论热议
请登录后评论。

登录 注册