|
OCP课程40：管理Ⅰ之支持 课程目标： - 使用EM支持工作台
- 使用MOS
- 搜索MOS
- SR
- 管理补丁
1、使用支持工作台
使用EM支持工作台（Support Workbench），可以按照以下步骤调查、报告及解决一些问题： （1）在EM主页，查看关键错误告警详细信息。 （2）查看问题详细信息以及该问题涉及到的所有事件。 （3）可以额外运行健康检查并启用SQL Test Case Builder，收集与SQL问题相关的所有数据并打包。 （4）使用My Oracle Support创建一个服务请求（Service Request），可以记录下服务请求编号。 （5）启动Incident Packaging Service，打包该问题所有诊断数据，上传到Oracle Support，在上传之前还可以编辑数据，删除敏感信息。 （6）可以为支持工作台的服务请求维护一个活动日志，运行Oracle顾问修复SQL问题或者损坏的数据。 （7）将问题事件关闭。
2、在EM查看关键错误告警
可以使用EM或者adrci命令行工具查看关键错误告警问题。在EM主页的诊断概要区活动的意外事件链接或者告警区都可以看到关键告警事件。 先模拟ORA-1578错误。查看目前的表空间，数据文件及大小。 SQL> create tablespace tstest datafile '/home/oracle/tstest.dbf' size 10m; Tablespace created. SQL> select tablespace_name,file_name,file_id,bytes/1024/1024 mb from dba_data_files where tablespace_name='TSTEST'; TABLESPACE FILE_NAME FILE_ID MB ---------- -------------------------------------------------- ---------- ---------- TSTEST /home/oracle/tstest.dbf 9 10 在表空间testest创建表emptest。 SQL> create table emptest tablespace tstest as select * from hr.employees where rownum<10; Table created. 定位表对应的块。 SQL> select rowid,dbms_rowid.rowid_relative_fno(rowid) rel_fno,dbms_rowid.rowid_block_number(rowid) block 2 from emptest; ROWID REL_FNO BLOCK ------------------ ---------- ---------- AAAV1yAAJAAAACDAAA 9 131 AAAV1yAAJAAAACDAAB 9 131 AAAV1yAAJAAAACDAAC 9 131 AAAV1yAAJAAAACDAAD 9 131 AAAV1yAAJAAAACDAAE 9 131 AAAV1yAAJAAAACDAAF 9 131 AAAV1yAAJAAAACDAAG 9 131 AAAV1yAAJAAAACDAAH 9 131 AAAV1yAAJAAAACDAAI 9 131 9 rows selected. SQL> select segment_name,header_file,header_block,blocks from dba_segments 2 where segment_name='EMPTEST' and owner='SYS'; SEGMENT_NA HEADER_FILE HEADER_BLOCK BLOCKS ---------- ----------- ------------ ---------- EMPTEST 9 130 8 验证是否有坏块，目前没有。 [oracle@oracletest1 ~]$ dbv userid=sys/123456 file=/home/oracle/tstest.dbf DBVERIFY: Release 11.2.0.4.0 - Production on Thu Dec 31 11:30:07 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBVERIFY - Verification starting : FILE = /home/oracle/tstest.dbf DBVERIFY - Verification complete Total Pages Examined : 1280 Total Pages Processed (Data) : 1 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 129 Total Pages Processed (Seg) : 1 Total Pages Failing (Seg) : 0 Total Pages Empty : 1149 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Total Pages Encrypted : 0 Highest block SCN : 3491945 (0.3491945) 先进行数据库全备。 RMAN> backup database plus archivelog delete input; RMAN标记坏块。 RMAN> recover datafile 9 block 131 clear; Starting recover at 31-DEC-15 using channel ORA_DISK_1 Finished recover at 31-DEC-15 再次验证，发现坏块。 [oracle@oracletest1 ~]$ dbv userid=sys/123456 file=/home/oracle/tstest.dbf DBVERIFY: Release 11.2.0.4.0 - Production on Thu Dec 31 14:11:07 2015 Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved. DBVERIFY - Verification starting : FILE = /home/oracle/tstest.dbf Page 131 is marked corrupt Corrupt block relative dba: 0x02400083 (file 9, block 131) Bad header found during dbv: Data in bad block: type: 6 format: 2 rdba: 0xfc430083 last change scn: 0xc9a4.c0b884ea seq: 0x30 flg: 0xdf spare1: 0x0 spare2: 0x0 spare3: 0x0 consistency value in tail: 0x48670602 check value in block header: 0x930e computed block checksum: 0xe095 DBVERIFY - Verification complete Total Pages Examined : 1280 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 0 Total Pages Failing (Index): 0 Total Pages Processed (Other): 129 Total Pages Processed (Seg) : 1 Total Pages Failing (Seg) : 0 Total Pages Empty : 1149 Total Pages Marked Corrupt : 1 Total Pages Influx : 0 Total Pages Encrypted : 0 Highest block SCN : 3491945 (0.3491945) 查询报错。 SQL> select count(*) from emptest; select count(*) from emptest * ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 9, block # 131) ORA-01110: data file 9: '/home/oracle/tstest.dbf'
点击活动的意外事件链接进入支持工作台页面。
3、查看问题详情
点击问题ID查看问题详细信息。
4、查看事件详情：dump文件
查看事件对应的dump文件。
5、查看事件详情：检查器发现
在事件详情页面，点击检查器查找结果可以看到对应自动健康检查结果，可以选择启动恢复指导进行恢复。
6、创建服务请求SR
在将问题诊断信息打包和上传到Oracle Support之前，必须要先创建服务请求SR（service request）。创建服务请求需要通过“转到My Oracle Support”访问MOS，然后创建服务请求。再点击SR#旁边的“编辑”输入服务请求号码。
7、打包上传诊断数据到Oracle支持
支持工作台提供了2种方式创建和上传事件包：快速打包方法和高级打包方法。这里是快速打包方法示例。 快速打包方法不能增加、修改或者移动事件包文件或者增加其他诸如SQL测试集的诊断信息。
8、追踪服务请求并执行修复
在上传了诊断信息到Oracle Support之后，可以进行各种活动追踪服务请求并进行修复： 给问题增加bug number：
点击活动日志，查看对该问题处理的记录：
9、追踪服务请求并执行修复
在事件详情页面，可以运行Oracle顾问进行恢复。
10、关闭事件和问题
事件可以关闭，关闭的事件默认不会显示在问题详情页面。不管事件是否关闭，所有事件在30天后都会被删除。可以为某个事件禁用删除。
关闭事件如下：
11、事件打包配置
对打包进行配置。
12、ASM的EM支持工作台
使用ASM支持工作台监控ASM告警和事件。
13、Oracle Support
Oracle Support Service提供7X24小时服务。 通过以下方式获取支持： - MOS
- 电话
- Oracle Derict Connect（ODC）远程诊断工具
购买了Oracle软件后，会提供一个Customer Support Identifier（CSI）number，使用CSI可以访问MOS上面的可用补丁，问题解决信息，获取SR等。
14、MOS
补丁程序向导在11.2.0.2版本已经废弃了。
15、使用MOS
16、研究问题
17、记录服务请求
在MOS上面找不到文件的解决办法的话就创建一个SR。
18、管理补丁
根据不同的需求，打不同的补丁。补丁包括： 临时补丁（一次性补丁）：用于解决特殊的问题，没有经过完整回归测试，使用opatch安装。 CPU补丁（Critical Patch Update）：关键补丁更新，修复安全和关键问题，累积更新，每季度发布，经过完整回归测试，可以使用opatch lsinventory查看。 Oracle数据库的Patch（补丁）类型 ：
One-off patches （一次性补丁） 安全
通常针对特定的版本数据库或运行平台，此类补丁通常较小，使用的最为频繁，只需要用Opatch工具apply即可，不需要升级/修正数据字典
如在数据库使用过程中出现某些异常后（如较常见的ORA-00600、ORA-07445错误等）可以通过一次性补丁来搞定
Critical Patch Update CPU
一般来说CPU包含了Oracle产品安全漏洞的修复补丁集(set of security bug fix)，通常一年发布四期
该类patch的安装和安装one-off patch一样，同样使用opatch apply命令来完成
安装完成后应针对既有的数据库(已经创建在使用的数据库)，应在数据库级别运行数据字典升级脚本
Patch Set Release PSR 升级影响CBO sql语句受影响
PSR就是大家常见的大补丁合集，通常1GB左右，oracle版本号的第四位即为PSR号,也就是说oracle版本号的第四位会被修改
每一个PSR是都整合了之前的一些bug，并且经过了严格的测试，通常更新PSR风险相对较小
如10.2，10.2.0.1.0是基础发行版，至今已有五个PSR发布，最新10.2的PSR为10.2.0.5.0
Patch Set Update PSU 安全
PSU就是在每个PSR发布之间的补丁，由于新旧PSR之间周期较长，而数据库在运行期间难以保证不会出现新的bug，因此有了PSU
PSU是对于PSR的一个重要补充，每个PSU修改5位版本号的第5位 如10.2版本为10.2.0.4.2
PSU与CPU一样，定期发布，计划一年发布四次，发布日期与CPU发布日期相同
由于PSU包括同期发布的CPU，只要安装PSU即可
PSU同样使用Opatch工具安装/删除，命令仍是apply和rollback
注意PSU之间可能有依赖关系
不同patch所需执行的脚步都有可能不同，请务必参照每个patch包中readme文件并以readme文件中的步骤为准！ [oracle@oracletest1 ~]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/ [oracle@oracletest1 OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_16-48-48PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-31_16-48-48PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 products installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
19、应用补丁
补丁发布是经过完全测试的，不包括新的功能。补丁发布的应用只会影响到数据库中的软件，不升级或更改数据库。安装前要阅读README文档。
20、使用补丁顾问
补丁程序向导在11.2.0.2版本已经废弃了。
21、使用补丁向导
补丁程序向导在11.2.0.2版本已经废弃了。
22、应用补丁
补丁程序向导在11.2.0.2版本已经废弃了。
23、分阶段打补丁
补丁程序向导在11.2.0.2版本已经废弃了。
24、联机补丁：概览
使用联机补丁可以在运行的实例上面安装，启用和禁用补丁。可以不要关闭实例。使用opatch命令。
25、安装联机补丁
应用联机补丁不需要关闭实例，使用opatch在线安装和卸载，检测补丁之间的冲突。 使用以下命令查看该补丁是否是联机补丁： opatch query -is_online_patch or
opatch query -all [oracle@oracletest1 OPatch]$ pwd /u01/app/oracle/product/11.2.0/dbhome_1/OPatch [oracle@oracletest1 OPatch]$ ./opatch query -is_online_patch 19121551/18031668/ Oracle Interim Patch Installer version 11.2.0.3.4 Copyright (c) 2012, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.4 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_19-10-45PM_1.log -------------------------------------------------------------------------------- Patch is an online patch: false OPatch succeeded. 安装。 [oracle@oracletest1 OPatch]$ ./opatch apply /home/oracle/19121551/ Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_21-57-25PM_1.log Verifying environment and performing prerequisite checks... OPatch continues with these patches: 17478514 18031668 18522509 19121551 Do you want to proceed? [y|n] y User Responded with: Y All checks passed. Provide your email address to be informed of security issues, install and initiate Oracle Configuration Manager. Easier for you if you use your My Oracle Support Email address/User Name. Visit http://www.oracle.com/support/policies.html for details. Email address/User Name: You have not provided an email address for notification of security issues. Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Backing up files... Applying sub-patch '17478514' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.sdo, 11.2.0.4.0... Patching component oracle.sysman.agent, 10.2.0.4.5... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.sdo.locator, 11.2.0.4.0... Patching component oracle.nlsrtl.rsf, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Verifying the update... Applying sub-patch '18031668' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.ldap.rsf, 11.2.0.4.0... Patching component oracle.rdbms.crs, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.ldap.rsf.ic, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Verifying the update... Applying sub-patch '18522509' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Verifying the update... Applying sub-patch '19121551' to OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.ordim.client, 11.2.0.4.0... Patching component oracle.ordim.jai, 11.2.0.4.0... Verifying the update... OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' Composite patch 19121551 successfully applied. OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_21-57-25PM_1.log OPatch completed with warnings. 查看。 [oracle@oracletest1 OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_22-05-25PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-31_22-05-25PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 product(s) installed in this Oracle Home. Interim patches (1) : Patch 19121551 : applied on Thu Dec 31 22:01:04 CST 2015 Unique Patch ID: 17949166 Patch description: "Database Patch Set Update : 11.2.0.4.4 (19121551)" Created on 6 Oct 2014, 10:07:57 hrs PST8PDT Sub-patch 18522509; "Database Patch Set Update : 11.2.0.4.3 (18522509)" Sub-patch 18031668; "Database Patch Set Update : 11.2.0.4.2 (18031668)" Sub-patch 17478514; "Database Patch Set Update : 11.2.0.4.1 (17478514)" Bugs fixed: 17288409, 17205719, 17811429, 17754782, 17726838, 13364795, 17311728 17284817, 17441661, 13645875, 18199537, 16992075, 16542886, 17446237 14565184, 17071721, 17610798, 17375354, 17449815, 17397545, 19463897 18230522, 17235750, 16360112, 13866822, 17982555, 17478514, 12905058 14338435, 13944971, 16929165, 12747740, 17546973, 14054676, 17088068 18264060, 17343514, 17016369, 17042658, 14602788, 14657740, 17332800 19211724, 13951456, 16315398, 17186905, 18744139, 16850630, 17437634 19049453, 18673304, 17883081, 18641419, 17296856, 18262334, 17006183 18277454, 17232014, 16855292, 10136473, 17705023, 17865671, 18554871 19121551, 17588480, 17551709, 17344412, 17842825, 18681862, 17390160 13955826, 13609098, 18139690, 17501491, 17239687, 17752121, 17299889 17602269, 18673325, 17313525, 17242746, 19544839, 17600719, 18191164 17571306, 19466309, 17951233, 18094246, 17165204, 17011832, 17040527 16785708, 16180763, 17477958, 17174582, 17465741, 18522509, 17323222 19463893, 16875449, 16524926, 17237521, 17596908, 17811438, 17811447 18031668, 16912439, 16494615, 18061914, 17545847, 17082359, 19554106 17614134, 17341326, 17891946, 19458377, 17716305, 17752995, 16392068 19271443, 17767676, 17614227, 17040764, 17381384, 18973907, 18673342 14084247, 17389192, 17006570, 17612828, 17721717, 13853126, 18203837 17390431, 17570240, 14245531, 16043574, 16863422, 19727057, 17468141 17786518, 17037130, 17267114, 18203838, 16198143, 16956380, 17478145 14829250, 17394950, 17027426, 16268425, 18247991, 19584068, 14458214 18436307, 17265217, 13498382, 16692232, 17786278, 17227277, 16042673 16314254, 17443671, 16228604, 16837842, 17393683, 17787259, 18009564 15861775, 16399083, 18018515, 16472716, 17050888, 14010183, 17325413 16613964, 17080436, 17036973, 17761775, 16721594, 18280813, 15979965 18203835, 17297939, 16731148, 17811456, 14133975, 17385178, 17586955 16450169, 17655634, 9756271, 17892268, 17648596, 16220077, 16069901 11733603, 16285691, 17587063, 18180390, 17393915, 18096714, 17238511 17824637, 14285317, 19289642, 14764829, 18328509, 17622427, 16943711 17346671, 18996843, 14852021, 17783588, 16618694, 17672719, 17546761 -------------------------------------------------------------------------------- OPatch succeeded. 卸载。 [oracle@oracletest1 OPatch]$ ./opatch rollback -id 19121551 Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/19121551_Dec_31_2015_22_10_42/rollback2015-12-31_22-10-42PM_1.log Patches will be rolled back in the following order: 19121551 18522509 18031668 17478514 The following patch(es) will be rolled back: 19121551 18522509 18031668 17478514 Sub-patches of a composite series are being rolled back. The system will be returned to a state where all subpatches are rolled back. The following bug fixes will be removed: 16042673,14245531,12747740,18264060,19211724,19121551,19727057,17449815,19544839,18673304,19554106,18436307,17982555,17586955,18673342,14657740,18009564,17232014,9756271,19271443,17842825,13955826,17237521,17042658,17040527,18262334,17951233,17267114,17390160,18641419,16494615,18191164,17570240,17787259,17299889,17036973,14764829,17891946,19463893,17587063,19289642,19463897,14084247,18230522,17343514,17824637,18973907,18280813,18328509,17242746,17705023,18673325,16198143,19584068,17006183,11733603,16524926,14285317,18199537,19466309,19458377,14829250,17037130,16692232,17596908,17174582,17648596,17011832,13645875,18096714,17752995,13951456,17655634,16992075,17786518,17393915,13498382,13609098,15861775,16360112,17571306,17477958,16392068,17006570,14458214,14602788,17397545,16268425,17165204,14565184,17883081,18522509,18018515,17672719,16315398,13853126,18554871,17767676,17588480,16542886,17227277,16855292,14054676,17786278,17311728,18247991,18277454,15979965,18681862,18996843,17754782,17892268,17614134,16314254,17478145,18061914,19049453,17238511,17600719,17381384,18744139,17297939,17783588,17716305,16180763,17545847,18203838,17393683,16863422,17389192,17394950,16731148,17761775,10136473,17726838,17186905,17441661,17325413,18203835,13364795,17050888,16472716,17622427,17546761,17468141,17040764,14010183,16837842,16228604,17205719,17284817,17346671,18180390,17235750,14133975,17721717,17082359,17602269,17071721,16613964,16929165,16043574,17080436,17265217,17865671,14852021,16399083,16943711,17375354,17546973,16785708,16956380,18094246,17614227,18031668,17313525,16912439,17385178,16618694,16220077,17016369,18203837,17027426,17341326,18139690,17437634,16875449,17465741,17752121,17344412,17296856,17390431,14338435,17323222,16850630,17551709,13944971,17811447,13866822,17811429,16069901,16721594,17443671,17478514,17612828,17610798,17239687,17501491,17446237,16450169,17811438,17288409,17811456,12905058,17088068,16285691,17332800 Please shutdown Oracle instances running out of this ORACLE_HOME on the local system. (Oracle Home = '/u01/app/oracle/product/11.2.0/dbhome_1') Is the local system ready for patching? [y|n] y User Responded with: Y Rolling back patch 19121551... RollbackSession rolling back interim patch '19121551' from OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.sysman.console.db, 11.2.0.4.0... Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/DBMsg.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/db/rsc/inst/DBMsgID.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/DBObjectSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/baseline/BaselineSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainRulesSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ChainStepsSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ClassSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/Job.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/JobSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ProgramSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/ScheduleSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/WindowGroupSQLGenerator.class" Updating jar file "/u01/app/oracle/product/11.2.0/dbhome_1/sysman/jlib/emDB.jar" with "/u01/app/oracle/product/11.2.0/dbhome_1/.patch_storage/19121551_Oct_6_2014_10_07_57/files//sysman/jlib/emDB.jar/oracle/sysman/emo/adm/instance/scheduler/WindowSQLGenerator.class" Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.ordim.client, 11.2.0.4.0... Patching component oracle.ordim.jai, 11.2.0.4.0... RollbackSession removing interim patch '19121551' from inventory Rolling back patch 18522509... RollbackSession rolling back interim patch '18522509' from OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.rdbms, 11.2.0.4.0... Deleting "kzradmape.o" from archive "/u01/app/oracle/product/11.2.0/dbhome_1/lib/libserver11.a" Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... RollbackSession removing interim patch '18522509' from inventory Rolling back patch 18031668... RollbackSession rolling back interim patch '18031668' from OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.ldap.rsf, 11.2.0.4.0... Patching component oracle.rdbms.crs, 11.2.0.4.0... Patching component oracle.precomp.common, 11.2.0.4.0... Patching component oracle.ldap.rsf.ic, 11.2.0.4.0... Patching component oracle.rdbms.deconfig, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... RollbackSession removing interim patch '18031668' from inventory Rolling back patch 17478514... RollbackSession rolling back interim patch '17478514' from OH '/u01/app/oracle/product/11.2.0/dbhome_1' Patching component oracle.rdbms, 11.2.0.4.0... Patching component oracle.rdbms.rsf, 11.2.0.4.0... Patching component oracle.sdo, 11.2.0.4.0... Patching component oracle.sysman.agent, 10.2.0.4.5... Patching component oracle.xdk, 11.2.0.4.0... Patching component oracle.rdbms.dbscripts, 11.2.0.4.0... Patching component oracle.sdo.locator, 11.2.0.4.0... Patching component oracle.nlsrtl.rsf, 11.2.0.4.0... Patching component oracle.xdk.rsf, 11.2.0.4.0... Patching component oracle.rdbms.rman, 11.2.0.4.0... RollbackSession removing interim patch '17478514' from inventory OPatch found the word "warning" in the stderr of the make command. Please look at this stderr. You can re-run this make command. Stderr output: ins_emagent.mk:113: warning: overriding commands for target `nmosudo' ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo' /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo' OPatch Session completed with warnings. Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/19121551_Dec_31_2015_22_10_42/rollback2015-12-31_22-10-42PM_1.log OPatch completed with warnings. 查看。 [oracle@oracletest1 OPatch]$ ./opatch lsinventory Oracle Interim Patch Installer version 11.2.0.3.6 Copyright (c) 2013, Oracle Corporation. All rights reserved. Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1 Central Inventory : /u01/app/oraInventory from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc OPatch version : 11.2.0.3.6 OUI version : 11.2.0.4.0 Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2015-12-31_22-13-48PM_1.log Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-12-31_22-13-48PM.txt -------------------------------------------------------------------------------- Installed Top-level Products (1): Oracle Database 11g 11.2.0.4.0 There are 1 product(s) installed in this Oracle Home. There are no Interim patches installed in this Oracle Home. -------------------------------------------------------------------------------- OPatch succeeded.
26、联机补丁好处
联机补丁的好处： - 不中断业务
- 快速安装和卸载
- 使用opatch检测冲突
- 永久有效
27、传统补丁与联机补丁
28、联机补丁注意点
29、联机补丁注意点
不是所有的bug都可以使用联机补丁进行修复。 在不能关机的时候使用联机补丁。 如果可以关机，则应该安装传统补丁，安装前需要卸载联机补丁。
30、相关习题： （1）View the Exhibit to examine the details for an incident.
Which statement is true regarding the status of the incident?
A. The DBA is working on the incident and prefers that the incident be kept in the ADR
B. The incident is now in the Done state and the ADR can select the incident to be purged
C. The incident has been newly created and is in the process of collecting diagnostic information
D. The data collection for the incident is complete and the incident can be packaged and sent to Oracle Support
答案：D （2）Which statements are true regarding the creation of an incident package file by using the EM Workbench Support? (Choose all that apply.)
A. You can add SQL test cases to the incident package.
B. You can add or remove the trace files to the package.
C. You cannot create an incremental incident package when the physical files are purged from the ADR.
D. You can create the incremental incident package ZIP file for new or modified diagnostic information for the incident package already created. 答案：ABD
| 
|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛
( 渝ICP备12004239号-4 )
发表于 2016-2-24 09:15:57
QQ好友和群
QQ空间
腾讯微博
腾讯朋友
收藏
支持
反对