签到成功

知道了

CNDBA社区CNDBA社区

Oracle RAC升级小补丁

2022-06-02 22:19 1065 0 原创 oracle
作者： hbhe0316
本文链接：http://www.cndba.cn/hbhe0316/article/108046

一.OPatch升级步骤http://www.cndba.cn/hbhe0316/article/108046

1.查看当前环境http://www.cndba.cn/hbhe0316/article/108046

su - grid
crsctl query crs softwareversion
crsctl query crs releaseversion
crsctl check crs
/u01/app/oracle/product/19.3.0.0/dbhome_1/OPatch/opatch lspatches

2.查看OPatch版本

su - oracle
cd $ORACLE_HOME/OPatch/
./opatch version

确保OPatch大于12.2.0.1.23http://www.cndba.cn/hbhe0316/article/108046

3.验证Oracle Inventory的有效性
在node01节点和node02节点

http://www.cndba.cn/hbhe0316/article/108046 

su - grid
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

su - oracle
$ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME

4.在node01节点和node02节点解压patch

su - oracle 
unzip -d /tmp  p32076305_1911000DBRU_Linux-x86-64.zip 
unzip -d /tmp  p33148846_1911000DBRU_Linux-x86-64.zip 
cd /tmp/32076305
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
cd /tmp/33148846
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./

5.停止node01

su - grid
srvctl disable listener -n node01
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

srvctl stop listener -n node01
srvctl status listener -n node01
ps -ef | grep -i "local=no" | grep -v grep 

su - oracle
cd /u01/app/oracle/product/19.3.0/dbhome_1/bin/
./srvctl stop instance -d orcl -i orcl1 -o immediate

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl stop crs

ps -ef | grep ora | grep -v grep

6.node01节点升级

su - oracle
cd /tmp/32076305
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory

cd /tmp/33148846
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33148846

7.node01节点启动

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl start crs
/u01/app/19.3.0.0/grid_1/bin/crsctl stat res -t

su - oracle
/u01/app/oracle/product/19.3.0/dbhome_1/bin/srvctl start instance -d orcl -i orcl1


su - grid
srvctl enable listener -n node01
srvctl start listener -n node01
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

8.停止node02

su - grid
srvctl disable listener -n node02
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

srvctl stop listener -n node02
srvctl status listener -n node02
ps -ef | grep -i "local=no" | grep -v grep 

su - oracle
cd /u01/app/oracle/product/19.3.0/dbhome_1/bin/
./srvctl stop instance -d orcl -i orcl2 -o immediate

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl stop crs

ps -ef | grep ora | grep -v grep

9.node02节点升级

su - oracle
cd /tmp/32076305
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory | grep 32076305

cd /tmp/33148846
$ORACLE_HOME/OPatch/opatch apply
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33148846

10.node02节点启动

http://www.cndba.cn/hbhe0316/article/108046 

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl start crs
/u01/app/19.3.0.0/grid_1/bin/crsctl stat res -t

su - oracle
/u01/app/oracle/product/19.3.0/dbhome_1/bin/srvctl start instance -d orcl -i orcl2

su - grid
srvctl enable listener -n node02
srvctl start listener -n node02
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

—————————————-如下为回退步骤—————————————————————————-

二.ROLLBAK
1.停止node01http://www.cndba.cn/hbhe0316/article/108046http://www.cndba.cn/hbhe0316/article/108046

su - grid
srvctl disable listener -n node01
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable
srvctl stop listener -n node01
srvctl status listener -n node01
ps -ef | grep -i "local=no" | grep -v grep 

su - oracle
cd /u01/app/oracle/product/19.3.0/dbhome_1/bin/
./srvctl stop instance -d orcl -i orcl1 -o immediate

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl stop crs

ps -ef | grep ora | grep -v grep

2.node01回退

su - oracle
cd /tmp/32076305
$ORACLE_HOME/OPatch/opatch rollback -id 32076305
$ORACLE_HOME/OPatch/opatch lsinventory | grep 32076305

cd /tmp/33148846
$ORACLE_HOME/OPatch/opatch rollback -id 33148846
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33148846

3.node01节点启动http://www.cndba.cn/hbhe0316/article/108046

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl start crs
/u01/app/19.3.0.0/grid_1/bin/crsctl stat res -t

su - oracle
/u01/app/oracle/product/19.3.0/dbhome_1/bin/srvctl start instance -d orcl -i orcl1


su - grid
srvctl enable listener -n node01
srvctl start listener -n node01
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

4.停止node02

su - grid
srvctl disable listener -n node02
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable
srvctl stop listener -n node02
srvctl status listener -n node02
ps -ef | grep -i "local=no" | grep -v grep 

su - oracle
cd /u01/app/oracle/product/19.3.0/dbhome_1/bin/
./srvctl stop instance -d orcl -i orcl2 -o immediate

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl stop crs


ps -ef | grep ora | grep -v grep

5.node02回退http://www.cndba.cn/hbhe0316/article/108046http://www.cndba.cn/hbhe0316/article/108046

su - oracle
cd /tmp/32076305
$ORACLE_HOME/OPatch/opatch rollback -id 32076305
$ORACLE_HOME/OPatch/opatch lsinventory | grep 32076305

cd /tmp/33148846
$ORACLE_HOME/OPatch/opatch rollback -id 33148846
$ORACLE_HOME/OPatch/opatch lsinventory | grep 33148846

6.node02节点启动

su - root
/u01/app/19.3.0.0/grid_1/bin/crsctl start crs
/u01/app/19.3.0.0/grid_1/bin/crsctl stat res -t

su - oracle
/u01/app/oracle/product/19.3.0/dbhome_1/bin/srvctl start instance -d orcl -i orcl1


su - grid
srvctl enable listener -n node01
srvctl start listener -n node01
crsctl stat res ora.LISTENER.lsnr -p | grep -i enable

版权声明：本文为博主原创文章，未经博主允许不得转载。

oracle

用户评论
* 以下用户言论只代表其个人观点，不代表CNDBA社区的观点或立场
hbhe0316

hbhe0316

关注

1.只有承认无知，才能装下新的东西； 2.进步来自一点点滴滴的积累； 3.广博让你更优秀，而专业让你无法替代； 4.挫折和失败能够转换为一种财富。

  • 889
    原创
  • 1
    翻译
  • 13
    转载
  • 24
    评论
  • 访问：1157856次
  • 积分：1523
  • 等级：核心会员
  • 排名：第6名
精华文章

    达梦数据库运维实战

    Oracle 18c 必须掌握的新特性：管理与实战

    Oracle数据库问题解决方案和故障排除手册
    最新问题
    查看更多+
    热门文章
      热门用户
      推荐用户
        友情链接： CNDBA社区 | openGauss | openEuler | openAnolis | 广告联系: database@ustc.edu
        Copyright © 2016 All Rights Reserved. Powered by CNDBA · 皖ICP备2022006297号-1·

        QQ交流群

        注册联系QQ