oracle 12C 单机PSU补丁升级（五）

概述：从12.2.0.1开始PSU补丁的下载不再叫PSU了，而是都改为叫做update了。

按照补丁中的readme文件已经测试成功，但是忘了做记录了，这里只是将过程的脚本顺序贴出，基本跟11g PSU 补丁升级差不多

升级OPatch版本

关闭数据库以及监听程序

shutdown immediate

lsnrctl stop

应用补丁：

unzip p28163133_122010_<platform>.zip
cd 28163133
opatch apply

然后如果是标准的状态数据库的话：

sqlplus / as sysdba

startup

exit

lsnrct start

cd $ORACEL_HOME/OPatch

./datapatch -verbose

如果为多租户模式的数据库的话：

sqlplus / as sysdba

startup

alter pluggable database all open;

exit

lsnrct start

cd $ORACEL_HOME/OPatch

./datapatch -verbose

SQL> select action_time,action,namespace,version,comments from dba_registry_history;

ACTION_TIME ACTION NAMESPACE VERSION COMMENTS
------------------------------ ---------- --------------- ---------- --------------------------------------------------
BOOTSTRAP DATAPATCH 12.2.0.1 RDBMS_12.2.0.1.0DBJUL2018RU_LINUX.X64_180703

SQL> select patch_id,patch_uid,version,action,status,action_time,description from dba_registry_sqlpatch;

PATCH_ID PATCH_UID VERSION ACTION STATUS ACTION_TIME DESCRIPTION
---------- ---------- ---------- ---------- -------- ------------------------------ ------------------------------------------------------------
28163133 22313390 12.2.0.1 APPLY SUCCESS 15-SEP-18 09.32.03.617613 PM DATABASE JUL 2018 RELEASE UPDATE 12.2.0.1.180717

这样补丁就按照完成了；

oracle 12C 单机PSU补丁升级（五）

相关推荐