暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle补丁的简化命令步骤

原创 lvzhengwei 2021-10-24
1094

    这些命令一般适用于新环境上安装oracle的补丁(PSU),对于复杂的生产环境还是需要根据不同的情况做不同的调整:


补丁冲突检测:
su - grid
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/28163133 //根据补丁的本地路径换
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/28163190
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/28163235
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/26839277
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/27144050

su - oracle
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/28163133
$ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /oracle/software/ru/28183653/28163190


空间检测:
su - grid
vi /tmp/patch_list_gihome.txt

/oracle/software/ru/28183653/28163133
/oracle/software/ru/28183653/28163190
/oracle/software/ru/28183653/28163235
/oracle/software/ru/28183653/26839277
/oracle/software/ru/28183653/27144050

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt


su - oracle
vi /tmp/patch_list_dbhome.txt

/oracle/software/ru/28183653/28163133
/oracle/software/ru/28183653/28163190

$ORACLE_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt



补丁分析能否打上:
su - root
/oracle/app/12.2.0/grid/OPatch/opatchauto apply /oracle/software/ru/28183653 -analyze
/oracle/app/12.2.0/grid/OPatch/opatchauto rollback /oracle/software/ru/28183653 -analyze


打补丁:
su - root
/oracle/app/12.2.0/grid/OPatch/opatchauto apply /oracle/software/ru/28183653 -oh /oracle/app/12.2.0/grid
/oracle/app/oracle/product/12.2.0/dbhome_1/OPatch/opatchauto apply /oracle/software/ru/28183653 -oh /oracle/app/oracle/product/12.2.0/dbhome_1



打补丁后的处理:就在一个节点上执行
su - oracle
srvctl start database -d cdb
sqlplus / as sysdba
alter pluggable database all open;
cd $ORACLE_HOME/OPatch
./datapatch -verbose

select * from dba_registry_sqlpatch;
@?/rdbms/admin/utlrp.sql

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论