Oracle 11.2.0 PSU补丁(20201020)

妖狐艹你老母 2022-08-28 13:55 97阅读 0赞

## 准备补丁包 ##

mkdir /tmp/psu
    上传补丁包

## 备份原有目录 ##

mv /opt/grid/products/11.2.0/OPatch /opt/grid/products/11.2.0/OPatch_bpx
    mv /opt/oracle/products/11.2.0/OPatch /opt/oracle/products/11.2.0/OPatch_bpx

## 解压 ##

cd /tmp/psu
    unzip p6880880_112000_Linux-x86-64.zip -d /opt/grid/products/11.2.0/
    unzip p6880880_112000_Linux-x86-64.zip -d /opt/oracle/products/11.2.0/

## 修改属组和权限 ##

chown -R grid.oinstall /opt/grid/products/11.2.0/OPatch
    chown -R oracle.oinstall /opt/oracle/products/11.2.0/OPatch
    chmod -R 777 /opt/grid/products/11.2.0/OPatch
    chmod -R 777 /opt/oracle/products/11.2.0/OPatch

## 检查目录权限 ##

ls -ld /opt/oracle/products/11.2.0/OPatch
    ls -ld /opt/grid/products/11.2.0/OPatch

## 检查opatch 版本 ##

su - grid -c "opatch version"
    su - oracle -c "opatch version"

## 修改属组和权限 ##

unzip /tmp/psu/p31718723_112040_Linux-x86-64.zip -d /tmp/psu
    chown -R grid.oinstall /tmp/psu/31718723
    chmod -R 777 /tmp/psu/31718723

## 可选操作-检测补丁冲突 ##

opatch prereq CheckActiveFilesAndExecutables -phBaseDir /tmp/psu/31718723

## 可选操作-关库 ##

srvctl stop database -d orcl -o immediate
    srvctl status database -d orcl

## 关库后检测会有failed，可忽略 ##

opatch prereq CheckActiveFilesAndExecutables -phBaseDir /tmp/psu/31718723

## 自动打grid和oracle补丁 ##

su - grid
    su root

export PERL5LIB=/opt/grid/products/11.2.0/perl/lib
    opatch auto /tmp/psu/31718723

![在这里插入图片描述][watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]  
大概20分钟搞定！！！

## 检查补丁版本 ##

su - grid -c "opatch lspatches"
    su - oracle -c "opatch lspatches"

[watermark_type_ZHJvaWRzYW5zZmFsbGJhY2s_shadow_50_text_Q1NETiBA5Zad6YaJ6YWS55qE5bCP55m9_size_20_color_FFFFFF_t_70_g_se_x_16]: /images/20220828/20471346570d450bac637ccb27a70c5e.png