oracle 12102打psu

最新推荐文章于 2022-05-11 15:28:34 发布
最新推荐文章于 2022-05-11 15:28:34 发布
阅读量276 收藏 2
点赞数 3
分类专栏： oracle
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/q195136130/article/details/118164148
版权
这篇博客介绍了Oracle 12c PSU的更新过程，包括不再需要响应文件ocm.rsp，使用opatchauto进行自动化升级，并详细展示了升级命令和步骤。在升级过程中，提到了opatch的替换、权限更改以及pdb的处理。在应用补丁后，通过datapatch执行SQL补丁，并处理了遇到的问题，如pdb的错误状态。最后，查询了补丁的安装状态。
摘要由CSDN通过智能技术生成

12c的psu有些许变化，主要是opatch工具命令变化，和对pdb的相关处理

高版本的psu已经不需要生成响应文件（ocm.rsp）

替换opatch

mv /u01/app/12.0.0/grid/OPatch /u01/app/12.0.0/grid/OPatchbak

cp -r OPatch /u01/app/12.0.0/grid/OPatch

mv /u01/app/oracle/product/12.0.0/db_1/OPatch /u01/app/oracle/product/12.0.0/db_1/OPatchbak

cp -r OPatch /u01/app/oracle/product/12.0.0/db_1/OPatch

chown –R grid:oinstall /u01/app/12.0.0/grid/OPatch

chown –R oracle:oinstall /u01/app/oracle/product/12.0.0/db_1/OPatch

执行opatchauto

/u01/app/12.0.0/grid/OPatch/opatchauto apply /u01/soft/28349311

（我这里因为只有一个节点，所以使用-nonrolling直接升级，否则升级会被拒绝）

[root@ora12c1 soft]# /u01/app/12.0.0/grid/OPatch/opatchauto apply /u01/soft/28349311 -nonrolling

OPatchauto session is initiated at Wed Nov 14 12:47:09 2018

System initialization log file is /u01/app/12.0.0/grid/cfgtoollogs/opatchautodb/systemconfig2018-11-14_12-47-10PM.log.

Session log file is /u01/app/12.0.0/grid/cfgtoollogs/opatchauto/opatchauto2018-11-14_12-47-14PM.log

The id for this session is TS1Q

Executing OPatch prereq operations to verify patch applicability on home /u01/app/oracle/product/12.0.0/db_1

Executing OPatch prereq operations to verify patch applicability on home /u01/app/12.0.0/grid

Patch applicability verified successfully on home /u01/app/12.0.0/grid

Patch applicability verified successfully on home /u01/app/oracle/product/12.0.0/db_1

Verifying SQL patch applicability on home /u01/app/oracle/product/12.0.0/db_1

SQL patch applicability verified successfully on home /u01/app/oracle/product/12.0.0/db_1

Preparing to bring down database service on home /u01/app/oracle/product/12.0.0/db_1

Successfully prepared home /u01/app/oracle/product/12.0.0/db_1 to bring down database service

Bringing down database service on home /u01/app/oracle/product/12.0.0/db_1

Following database(s) and/or service(s) are stopped and will be restarted later during the session: orcl

Database service successfully brought down on home /u01/app/oracle/product/12.0.0/db_1

Bringing down CRS service on home /u01/app/12.0.0/grid

Prepatch operation log file location: /u01/app/12.0.0/grid/cfgtoollogs/crsconfig/crspatch_ora12c1_2018-11-14_12-51-03AM.log

CRS service brought down successfully on home /u01/app/12.0.0/grid

Performing prepatch operation on home /u01/app/oracle/product/12.0.0/db_1

Perpatch operation completed successfully on home /u01/app/oracle/product/12.0.0/db_1

Start applying binary patch on home /u01/app/oracle/product/12.0.0/db_1

Binary patch applied successfully on home /u01/app/oracle/product/12.0.0/db_1

Performing postpatch operation on home /u01/app/oracle/product/12.0.0/db_1

Postpatch operation completed successfully on home /u01/app/oracle/product/12.0.0/db_1

Start applying binary patch on home /u01/app/12.0.0/grid

Binary patch applied successfully on home /u01/app/12.0.0/grid

Starting CRS service on home /u01/app/12.0.0/grid

Postpatch operation log file location: /u01/app/12.0.0/grid/cfgtoollogs/crsconfig/crspatch_ora12c1_2018-11-14_01-12-53PM.log

CRS service started successfully on home /u01/app/12.0.0/grid

Starting database service on home /u01/app/oracle/product/12.0.0/db_1

Database service successfully started on home /u01/app/oracle/product/12.0.0/db_1

Preparing home /u01/app/oracle/product/12.0.0/db_1 after database service restarted

No step execution required.........

Trying to apply SQL patch on home /u01/app/oracle/product/12.0.0/db_1

"/bin/sh -c 'cd /u01/app/oracle/product/12.0.0/db_1;ORACLE_HOME=/u01/app/oracle/product/12.0.0/db_1 ORACLE_SID=orcl_1 /u01/app/oracle/product/12.0.0/db_1/OPatch/datapatch -verbose'" command failed with errors. Please refer to logs for more details. SQL changes, if any, can be applied by manually retrying the same command.

SQL patch applied successfully on home /u01/app/oracle/product/12.0.0/db_1

OPatchAuto successful.

--------------------------------Summary--------------------------------

Patching is completed successfully. Please find the summary as follows:

Host:ora12c1

RAC Home:/u01/app/oracle/product/12.0.0/db_1

Version:12.1.0.2.0

Summary:

==Following patches were SKIPPED:

Patch: /u01/soft/28349311/26983807

Reason: This patch is not applicable to this specified target type - "rac_database"

Patch: /u01/soft/28349311/28259950

Reason: This patch is not applicable to this specified target type - "rac_database"

==Following patches were SUCCESSFULLY applied:

Patch: /u01/soft/28349311/28259833

Log: /u01/app/oracle/product/12.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-53-31PM_1.log

Patch: /u01/soft/28349311/28259914

Log: /u01/app/oracle/product/12.0.0/db_1/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-53-31PM_1.log

Host:ora12c1

CRS Home:/u01/app/12.0.0/grid

Version:12.1.0.2.0

Summary:

==Following patches were SUCCESSFULLY applied:

Patch: /u01/soft/28349311/26983807

Log: /u01/app/12.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-59-54PM_1.log

Patch: /u01/soft/28349311/28259833

Log: /u01/app/12.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-59-54PM_1.log

Patch: /u01/soft/28349311/28259914

Log: /u01/app/12.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-59-54PM_1.log

Patch: /u01/soft/28349311/28259950

Log: /u01/app/12.0.0/grid/cfgtoollogs/opatchauto/core/opatch/opatch2018-11-14_12-59-54PM_1.log

OPatchauto session completed at Wed Nov 14 13:24:48 2018

Time taken to complete the session 37 minutes, 39 seconds

注册补丁

以前使用catbundle.sql，现在需要使用datapatch,位置在opatch文件夹里，运行datapatch前需要启动所有pdb

cdb、pdb未设置时，pdb不会自动启动

alter pluggable database all open;

alter pluggable database all save state;

运行datapatch

[oracle@ora12c1 OPatch]$ ./datapatch -verbose

SQL Patching tool version 12.1.0.2.0 Production on Fri Nov 16 07:01:12 2018

Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Log file for this invocation: /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_64616_2018_11_16_07_01_12/sqlpatch_invocation.log

Connecting to database...OK

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

Determining current state...done

Current state of SQL patches:

Bundle series PSU:

  ID 181016 in the binary registry and ID 181016 in PDB CDB$ROOT, ID 181016 in PDB PDB$SEED

Adding patches to installation queue and performing prereq checks...

Installation queue:

  For the following PDBs: CDB$ROOT PDB$SEED

    Nothing to roll back

    Nothing to apply

  For the following PDBs: WZY1 WZY2

    Nothing to roll back

    The following patches will be applied:

      28259833 (DATABASE PATCH SET UPDATE 12.1.0.2.181016)

Installing patches...

Patch installation complete.  Total patches installed: 2

Validating logfiles...

Patch 28259833 apply (pdb WZY1): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_ORCL_WZY1_2018Nov16_07_01_26.log (no errors)

Patch 28259833 apply (pdb WZY2): SUCCESS

  logfile: /u01/app/oracle/cfgtoollogs/sqlpatch/28259833/22488632/28259833_apply_ORCL_WZY2_2018Nov16_07_01_26.log (no errors)

SQL Patching tool complete on Fri Nov 16 07:02:10 2018

若遇到以下告警

SQL Patching tool version 12.1.0.2.0 Production on Fri Nov 16 06:55:13 2018

Copyright (c) 2012, 2016, Oracle.  All rights reserved.

Connecting to database...OK

Note:  Datapatch will only apply or rollback SQL fixes for PDBs

       that are in an open state, no patches will be applied to closed PDBs.

       Please refer to Note: Datapatch: Database 12c Post Patch SQL Automation

       (Doc ID 1585822.1)

Bootstrapping registry and package to current versions...done

  Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_61762_2018_11_16_06_55_13/bootstrap1_ORCL_WZY1.log:

    Error at line 95: Warning: Package Body created with compilation errors.

    Error at line 101: 6/17     PL/SQL: Item ignored

    Error at line 102: 6/17     PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 103: 109/5    PL/SQL: SQL Statement ignored

    Error at line 104: 118/39   PL/SQL: ORA-00904: "CURRENT_PATCH"."BUNDLE_ID": invalid

    Error at line 107: 118/39   PLS-00320: the declaration of the type of this expression is

    Error at line 113: 154/5    PL/SQL: SQL Statement ignored

    Error at line 114: 157/7    PLS-00320: the declaration of the type of this expression is

    Error at line 117: 187/5    PL/SQL: ORA-00904: : invalid identifier

    Error at line 121: 264/21   PL/SQL: Item ignored

    Error at line 122: 264/21   PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 123: 265/21   PL/SQL: Item ignored

    Error at line 124: 265/21   PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 125: 274/5    PL/SQL: SQL Statement ignored

    Error at line 126: 274/17   PL/SQL: ORA-04063: view "SYS.DBA_REGISTRY_SQLPATCH" has errors

    Error at line 127: 311/9    PL/SQL: SQL Statement ignored

    Error at line 131: 316/24   PL/SQL: ORA-04063: view "SYS.DBA_REGISTRY_SQLPATCH" has errors

    Error at line 132: 349/5    PL/SQL: Statement ignored

    Error at line 133: 349/5    PLS-00320: the declaration of the type of this expression is

    Error at line 136: 350/5    PL/SQL: Statement ignored

    Error at line 137: 350/5    PLS-00320: the declaration of the type of this expression is

  Error in bootstrap log /u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_61762_2018_11_16_06_55_13/bootstrap1_ORCL_WZY2.log:

    Error at line 95: Warning: Package Body created with compilation errors.

    Error at line 101: 6/17     PL/SQL: Item ignored

    Error at line 102: 6/17     PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 103: 109/5    PL/SQL: SQL Statement ignored

    Error at line 104: 118/39   PL/SQL: ORA-00904: "CURRENT_PATCH"."BUNDLE_ID": invalid

    Error at line 107: 118/39   PLS-00320: the declaration of the type of this expression is

    Error at line 113: 154/5    PL/SQL: SQL Statement ignored

    Error at line 114: 157/7    PLS-00320: the declaration of the type of this expression is

    Error at line 117: 187/5    PL/SQL: ORA-00904: : invalid identifier

    Error at line 121: 264/21   PL/SQL: Item ignored

    Error at line 122: 264/21   PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 123: 265/21   PL/SQL: Item ignored

    Error at line 124: 265/21   PLS-00905: object SYS.DBA_REGISTRY_SQLPATCH is invalid

    Error at line 125: 274/5    PL/SQL: SQL Statement ignored

    Error at line 126: 274/17   PL/SQL: ORA-04063: view "SYS.DBA_REGISTRY_SQLPATCH" has errors

    Error at line 127: 311/9    PL/SQL: SQL Statement ignored

    Error at line 131: 316/24   PL/SQL: ORA-04063: view "SYS.DBA_REGISTRY_SQLPATCH" has errors

    Error at line 132: 349/5    PL/SQL: Statement ignored

    Error at line 133: 349/5    PLS-00320: the declaration of the type of this expression is

    Error at line 136: 350/5    PL/SQL: Statement ignored

    Error at line 137: 350/5    PLS-00320: the declaration of the type of this expression is

Prereq check failed, exiting without installing any patches.

Please refer to MOS Note 1609718.1 and/or the invocation log

/u01/app/oracle/cfgtoollogs/sqlpatch/sqlpatch_61762_2018_11_16_06_55_13/sqlpatch_invocation.log

for information on how to resolve the above errors.

SQL Patching tool complete on Fri Nov 16 06:55:17 2018

该告警是pdb虽然open但是有问题。将pdb起到upgrade，重新datapatch，成功。

alter pluggable database all close;

alter pluggable database all open upgrade;

./datapatch –verbose

升级后还是upgrade排他状态，pdb需要重新启动

alter pluggable database all close;

alter pluggable database all open;

查询补丁

切换pdb，查询

Alter session set container=wzy1;

select patch_id,action,status from dba_registry_sqlpatch;

oracle 查找 psu,Oracle如何检查当前数据库CPU和PSU补丁信息
weixin_28295799的博客
04-04 979
正常情况下有两种方法：一种是登录数据库检查DBA_REGISTRY_HIST视图：1.MODDB2:[/home/oracle]$sqlplus / as sysdba2.SQL*Plus: Release 10.2.0.4.0 - Production on Thu Aug 18 13:04:43 20113.Copyright (c) 1982, 2007, Oracle. All Right...
查询oracle psu,Oracle如何检查当前数据库CPU和PSU补丁
weixin_39764494的博客
04-03 400
正常情况下有两种方法：一、登录数据库检查DBA_REGISTRY_HIST视图sqlplus '/as sysdba'set linesize 200set pagesize 999col action_time format a30col action format a20col id format a10col version format a10col comments format a20...
Oracle Database 12c (winx64_12102_database.part2.rar)
10-16
Oracle Database 12c 适用于Windows 64位系统， winx64_12102_database文件分割成 三个 压缩包，必须集齐 三个 文件后才能一起解压一起使用： Oracle Database 12c (winx64_12102_database.part3.rar) https://download.csdn.net/download/weixin_43800734/33194402 Oracle Database 12c (winx64_12102_database.part2.rar) https://download.csdn.net/download/weixin_43800734/33194442 Oracle Database 12c (winx64_12102_database.part1.rar) https://download.csdn.net/download/weixin_43800734/33194437
oracle12102升级12201
q195136130的专栏
06-23 349
升级准备 1、当前GI 12102需要打补丁，要求为21255373，建议为最新的PSU 2、升级GI 12201需要打补丁，需要修复Bug 27769638，见27769638.8，我这里下载的为p27769638_12201180116OCWJan2018RU_Linux-x86-64 但是在升级中还是遇到了CLSRSC-400，见另外处理的文档参考 3、软件安装空间需要20G左右（redhat7.5） 4、OCR磁盘组需要50G空间（当mgmt在OCR中时） 升级流程 12201的软
Oracle 12C PSU
GreyHat OMDBA
11-24 2022
PSU, SPU(CPU), Bundle Patches   12.1.0.2  Description  PSU    GI PSU  Bundle Patch (Windows 32bit & 64bit)  OCT2015  21359755 (12.1.0.2.5)  21523234 (1
Oracle Database 12c (winx64_12102_database.part1.rar)
10-16
Oracle Database 12c 适用于Windows 64位系统， winx64_12102_database文件分割成 三个 压缩包，必须集齐 三个 文件后才能一起解压一起使用： Oracle Database 12c (winx64_12102_database.part3.rar) https://download.csdn.net/download/weixin_43800734/33194402 Oracle Database 12c (winx64_12102_database.part2.rar) https://download.csdn.net/download/weixin_43800734/33194442 Oracle Database 12c (winx64_12102_database.part1.rar) https://download.csdn.net/download/weixin_43800734/33194437
Oracle Database 12c (winx64_12102_database.part3.rar)
10-16
Oracle Database 12c 适用于Windows 64位系统， winx64_12102_database文件分割成 三个 压缩包，必须集齐 三个 文件后才能一起解压一起使用： Oracle Database 12c (winx64_12102_database.part3.rar) https://download.csdn.net/download/weixin_43800734/33194402 Oracle Database 12c (winx64_12102_database.part2.rar) https://download.csdn.net/download/weixin_43800734/33194442 Oracle Database 12c (winx64_12102_database.part1.rar) https://download.csdn.net/download/weixin_43800734/33194437
[Oracle] CPU/PSU补丁安装详细教程
12-16
Oracle的CPU（Critical Patch Update）和PSU（Patch Set Update）是两个重要的更新机制，用于维护Oracle数据库的安全性和稳定性。CPU是Oracle每季度发布的一次性安全补丁集合，主要目的是修复产品中的安全漏洞，确保...
oracle 12.2 最新psu
06-15
Oracle 12.2 最新PSU（Patch Set Update）是Oracle数据库的重要更新，它针对Oracle Database 12c Release 2（12.2版本）提供了最新的安全修复、性能优化和功能增强。PSU是Oracle公司定期发布的一种维护更新，旨在...
oracle12.2 psu,Oracle 12.2 家族的补丁 RU 和 RUR 说明
weixin_35970228的博客
04-09 876
在Oracle 11g之前Oracle 的补丁体系采用的是PSR、PSU 和 BP的概念，相关说明可以参考之前的博客：从Oracle 12.2 开始，补丁体系发生了明显的变化。 这个在之前的18c 升级博客中也进行了描述：Oracle 18c 单实例 RU 从18.3.1 升级到18.4.0 操作手册https://www.cndba.cn/dave/article/3143从2017年7月开始，...
ORACLE 11.2.0.4.200114 PSU LINUX
05-13
p30501155_112040_Linux-x86-64.zip.txt p30501155_112040_Linux-x86-64.zip.txt p30501155_112040_Linux-x86-64.zip.txt p30501155_112040_Linux-x86-64.zip.txt p30501155_112040_Linux-x86-64.zip.txt p30501155_112040_Linux-x86-64.zip.txt
ansible-oracle-psu:将PSU修补程序应用于RAC和单实例Oracle DB服务器
05-22
申请 将Oracle季度修补程序（PSU）应用于单个实例（SI）和RAC实例的角色。 角色变量 vars / main.yml psu：具有12.1.0.2和11.2.0.4的最新PSU信息的字典变量 opatch：具有适用于12.1.0.2和11.2.0.4的最新opatch版本的字典变量 默认值/ main.yml patch_name: JUL2019 ＃应该匹配在vars / main.yml中定义的Quarterly_Patches字典变量 必需的库存变量 oracle_install_type ：有效值为si ， rac或si_asm 。 用于确定主机是单实例数据库安装，RAC集群还是单实例Oracle Restart。 oracle_stage_install：包含所有oracle安装文件的目录 oracle_stage：目录，用于存储在剧本执行期间使用的日志和脚本。
ORACLE PSU(Patch SetT Update)
Rivarola的专栏
11-13 1051
ORACLE PSU是Patch SetT Update的缩写。ORACLE提供了PSU升级的工具OPatch。PSU对OPatch Utility的版本有要求，必须满足PSU要求的版本才能使用OPatch Utility完成升级操作。本次升级的数据库版本10.2.0.5，使用的PSU是16619894 - 10.2.0.5.12。该PSU要求使用OPatch 10.2版本10.2.0.5.0或者
oracle psu 安装
11-13 331
截图如下（截图只为了格式不变），需要留言发源码 如果觉得对您有帮助的话，请小编喝杯咖啡吧~~~             
oracle psu记录
xionglang7的专栏
07-22 1717
oracle patch号和psu号都比较难找，今天遇到有人总结了，特此记录一下，方便以后查阅！ Oracle 10.2.0.4：  DB Patch Set Update    Unix      Comments                 Includes Cpu  10.2.0.4.1             8576156   Bash 10.2.0.4.0        
oracle 12c安装psu,Oracle 12c 单机安装PSU(12.1.0.2.161018)
weixin_39531378的博客
04-03 316
一、准备工作1，数据库环境操作系统版本 : Redhat 7.1 x64数据库版本 : Oracle 12.1.0.2 x64Oracle database: 12.1.0.22，准备内容OPatch : p6880880_122010_Linux-x86-64.zipDB PSU : p24006101_121020_Linux-x86-64.zip 仅oracle12c单机使用。二...
12cR2下安装PSU - 单实例
文档搬运工
05-12 582
12c开始，安装补丁和11gr2有些不一样。11gR2中安装PSU补丁程序后，需要运行SQL。而12c开始，使用OPatch目录下的datapatch脚本来自动应用补丁。整个补丁安装过程如下：[oracle@orcl12c psu]$ cd 27674384/ [oracle@orcl12c 27674384]$ /u01/app/oracle/product/12.2.0.1/db_1/OPat...
12c单实例数据库打最新12.1.0.2.5 PSU补丁记录
elvis的Oracle Lab
10-30 2093
[root@oel11 ~]# su - oracle [oracle@oel11 ~]$ env|grep ORA ORA_NLS10=/s01/oracle12c/app/oracle/product/12.1.0.2/dbhome_1/nls/data ORACLE_SID=PROD12 ORACLE_BASE=/s01/oracle12c/app/oracle ORACLE_HO
ORACLE 11G R2 PSU 补丁升级过程（SinoDB）
Sinoregal的博客
05-11 1558
1.psu 概述 Oracle PSU的全名是Patch Set Update，是Oracle对于发行的官方补丁包，包含了bug的修复。Oracle选取被用户下载数量多，且被验证过具有较低风险的补丁放入到每个季度的PSU中。在每个PSU中不但包含Bug的修复而且还包含了最新的CPU。PSU通常随CPU一起发布。 在新部署环境建议打上最新的补丁包 2.升级环境描述 本次升级基本环境如下： 数据库版本 系统版本 升级psu版本 ..
Oracle CPU/PSU补丁安装全面指南
Oracle CPU和PSU是Oracle针对其产品的关键安全更新工具，它们分别扮演着不同角色。CPU，即Critical Patch Update，是Oracle每季度发布的重要安全补丁，旨在修复产品中的安全漏洞，确保系统的安全性。这些补丁是累积...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值
>