加入收藏 | 设为首页 | 会员中心 | 我要投稿 李大同 （https://www.lidatong.com.cn/）- 科技、建站、经验、云计算、5G、大数据,站长网!
当前位置： 首页 > 百科 > 正文

转 AIX7.2+11.2.0.4RAC实施

发布时间：2020-12-12 13:17:03 所属栏目：百科 来源：网络整理
导读：? ? ? 参考 https://blog.csdn.net/alangmei/article/details/18310381 https://blog.csdn.net/smasegain/article/details/47049955 ? 文档说明:以#开始命令表示root用户执行，$开始命令以oracle/grid执行(前面都有切换用户的动作) ========================

?

?

?

参考

https://blog.csdn.net/alangmei/article/details/18310381

https://blog.csdn.net/smasegain/article/details/47049955

?

文档说明:以#开始命令表示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_PROPAGATE grid
# mkuser id=‘502‘ pgrp=‘oinstall‘ groups=‘dba,oper‘ home=‘/home/oracle‘ fsize=-1 cpu=-1 data=-1 rss=-1 stack=-1 stack_hard=-1 capabilities=CAP_NUMA_ATTACH,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--------------------- 作者：司马松儆 来源：CSDN 原文：https://blog.csdn.net/smasegain/article/details/47049955 版权声明：本文为博主原创文章，转载请附上博文链接！

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!
    相关内容
      推荐文章
        站长推荐
        热点阅读

          【免责声明】本站内容转载自互联网，其发布内容言论不代表本站观点，如果其链接、内容的侵犯您的权益，烦请提交相关链接至邮箱bqsm@foxmail.com我们将及时予以处理。

          建议您使用1920×1080分辨率、谷歌浏览器Google Chrome、Microsoft Edge以获得本站的最佳浏览效果

          Copygight © 2008-2022 https://www.lidatong.com.cn/ All Rights Reserved. 李大同