这些命令一般适用于新环境上安装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




