执行前检查(两边都检查)
[grid@rac1 ~]$ crsctl query crs softwareversion
Oracle Clusterware version on node [rac1] is [19.0.0.0.0]
[grid@rac1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@rac1 ~]$ crsctl query crs releaseversion
Oracle High Availability Services release version on the local node is [19.0.0.0.0]
[grid@rac1 OPatch]$ ./opatch lspatches
29585399;OCW RELEASE UPDATE 19.3.0.0.0 (29585399)
29517247;ACFS RELEASE UPDATE 19.3.0.0.0 (29517247)
29517242;Database Release Update : 19.3.0.0.190416 (29517242)
29401763;TOMCAT RELEASE UPDATE 19.0.0.0.0 (29401763)
OPatch succeeded.
[grid@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.17
更新OPatch版本
[root@rac1 software]# chown grid:oinstall p6880880_210000_Linux-x86-64.zip
[grid@rac1 software]$ unzip p6880880_210000_Linux-x86-64.zip
[grid@rac1 grid]$ echo $ORACLE_HOME
/u01/app/19.3.0/grid
[root@rac1 grid]# mv OPatch OPatch.bak
[root@rac1 software]# cp -rp OPatch /u01/app/19.3.0/grid/
[grid@rac1 OPatch]$ ./opatch version
OPatch Version: 12.2.0.1.25
OPatch succeeded.
验证oracle inventory有效性
[grid@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
[oracle@rac1 ~]$ $ORACLE_HOME/OPatch/opatch lsinventory -detail -oh $ORACLE_HOME
检查patch是否存在冲突
[grid@rac1 software]$ ll
total 2789536
drwxr-x--- 15 oracle oinstall 4096 Apr 20 02:45 OPatch
-rw-r--r-- 1 root root 2734496202 Aug 2 23:20 p32895426_190000_Linux-x86-64.zip
-rwxrwxrwx 1 oracle oinstall 121981878 Aug 3 00:19 p6880880_210000_Linux-x86-64.zip
[grid@rac1 software]$ unzip p32895426_190000_Linux-x86-64.zip
chown grid:oinstall /u01/software/32895426 -R
chmod 777 /u01/software/32895426 -R
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32904851
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32916816
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32915586
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32918050
chown oracle:oinstall /u01/software/32895426 -R
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32904851
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /u01/software/32895426/32916816
系统空间检查
实际opatch前的opatch分析
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/software/32895426 -analyze
/u01/app/19.3.0/grid/OPatch/opatchauto apply /u01/software/32895426 –analyze
打gi补丁
chmod 777 /u01/app/oraInventory/ContentsXML/oui-patch.xml
chmod 777 /u01/app/19.3.0/grid/crs/install/cmdllroot.sh
chmod 777 /etc/oracleafd.conf
chown grid:oinstall /etc/oracleafd.conf
chown grid:oinstall /u01/app/19.3.0/grid/crs/install/cmdllroot.sh
[root@rac1 ~]# export PATH=$PATH:/u01/app/19.3.0/grid/OPatch
[root@rac1 ~]# chown grid:oinstall /u01/software/32895426 -R
[root@rac1 ~]# chmod 777 /u01/software/32895426 -R
[root@rac1 ~]# opatchauto apply /u01/software/32895426 -oh /u01/app/19.3.0/grid
打db补丁
chown oracle:oinstall /u01/software/32895426 -R
chmod 777 /u01/software/32895426 -R
[root@rac1 ~]# export PATH=$PATH:/u01/app/oracle/product/19.3.0/db_1 [root@rac1 ~]#
/u01/app/oracle/product/19.3.0/db_1/OPatch/opatchauto apply /u01/software/32895426 -oh
/u01/app/oracle/product/19.3.0/db_1
升级数据字典,编译无效对象
sqlplus /nolog
SQL> Connect / as sysdba
SQL> startup
SQL> alter pluggable database all open;
SQL> quit
cd $ORACLE_HOME/OPatch
./datapatch -verbose
分享
收藏
点赞
在看
文章版权归作者所有,未经允许请勿转载,若此文章存在违规行为,您可以联系管理员删除。
转载请注明本文地址:https://www.ucloud.cn/yun/129669.html
摘要:漏洞报告最近收到安全部门的安全扫描报告。远程攻击者可利用该漏洞获取敏感信息或造成拒绝服务。厂商补丁目前厂商已发布升级补丁以修复漏洞,补丁获取链接一个高危漏洞,赶紧网上查询下资料这准备修复。 漏洞报告 最近收到安全部门的安全扫描报告。内容如下: nginx 安全漏洞(CVE-2018-16845) 中危 nginx类 nginx是由俄罗斯的程序设计师Igor Sysoe...
阅读 1235·2023-01-11 13:20
阅读 1543·2023-01-11 13:20
阅读 996·2023-01-11 13:20
阅读 1651·2023-01-11 13:20
阅读 3958·2023-01-11 13:20
阅读 2456·2023-01-11 13:20
阅读 1290·2023-01-11 13:20
阅读 3452·2023-01-11 13:20