备案控制台
探索云世界
开发者社区 数据库 文章 正文

单机 Oracle 11g(11.2.0.4)手动打补丁PSU(11.2.0.4.8)

2017-11-12 1640
版权
版权声明：
本文内容由阿里云实名注册用户自发贡献，版权归原作者所有，阿里云开发者社区不拥有其著作权，亦不承担相应法律责任。具体规则请查看《 阿里云开发者社区用户服务协议》和 《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容，填写 侵权投诉表单进行举报，一经查实，本社区将立刻删除涉嫌侵权内容。
简介：

环境说明：
database : 11.2.0.4 x64
os: centos6.7 x64

准备内容:
OPatch : p6880880_112000_Linux-x86-64.zip
DB PSU : p21352635_112040_Linux-x86-64.zip


信息检查，查看环境是否符合打该 patch ， optch版本安装环境详细请看 mos 与 readme 。

-- 查看组件信息
set linesize 500 pagesize 600
col COMP_NAME for a30
select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;


COMP_ID COMP_NAME VERSION STATUS
------------------------------ ------------------------------ ------------------------------ -------
OWB OWB 11.2.0.1.0 VALID
APEX Oracle Application Express 3.2.1.00.10 VALID
EM Oracle Enterprise Manager 11.2.0.4.0 VALID
AMD OLAP Catalog 11.2.0.4.0 VALID
SDO Spatial 11.2.0.4.0 VALID
ORDIM Oracle Multimedia 11.2.0.4.0 VALID
XDB Oracle XML Database 11.2.0.4.0 VALID
CONTEXT Oracle Text 11.2.0.4.0 VALID
EXF Oracle Expression Filter 11.2.0.4.0 VALID
RUL Oracle Rules Manager 11.2.0.4.0 VALID
OWM Oracle Workspace Manager 11.2.0.4.0 VALID
CATALOG Oracle Database Catalog Views 11.2.0.4.0 VALID
CATPROC Oracle Database Packages and T 11.2.0.4.0 VALID
ypes
JAVAVM JServer JAVA Virtual Machine 11.2.0.4.0 VALID
XML Oracle XDK 11.2.0.4.0 VALID
CATJAVA Oracle Database Java Packages 11.2.0.4.0 VALID
APS OLAP Analytic Workspace 11.2.0.4.0 VALID
XOQ Oracle OLAP API 11.2.0.4.0 VALID

18 rows selected.

--查看补丁情况

set linesize 500 pagesize 600
col ACTION_TIME for a30
col COMMENTS for a30
select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;

ACTION_TIME ACTION VERSION COMMENTS
------------------------------ ------------------------------ -------------------- ------------------------------
16-FEB-15 05.46.48.580786 AM VIEW INVALIDATE view invalidation
16-FEB-15 05.47.05.038595 AM UPGRADE 11.2.0.4.0 Upgraded from 11.2.0.1.0
16-FEB-15 05.47.54.530480 AM APPLY 11.2.0.4 Patchset 11.2.0.2.0

--查看无效对象
select count(*) from dba_objects where status<>'VALID';
COUNT(*)
----------
0

操作流程：


1.更新OPatch版本，需要更新到11.2.0.3.11，OPatch直接压缩替换就可以了。

(1) 上传p6880880_112000_Linux-x86-64.zip到/home/oracle/opatch目录下, /home/oracle/opatch给777权限。
[oracle@11g ~]$ mkdir opatch
[oracle@11g ~]$ cd opatch/
[oracle@11g opatch]$ pwd
/home/oracle/opatch
[oracle@11g opatch]$ ll
total 122644
-rw-r--r--. 1 oracle oinstall 72935280 Feb 16 12:42 p21352635_112040_Linux-x86-64.zip
-rw-r--r--. 1 oracle oinstall 52648436 Feb 16 12:41 p6880880_112000_Linux-x86-64.zip

(2) root用户下将原OPatch目录改名。

[oracle@11g ~]$ mv $ORACLE_HOME/OPatch $ORACLE_HOME/OPatch.old.opatch

2. oracle目录OPatch替换

[oracle@11g opatch]$ pwd
/home/oracle/opatch
[oracle@11g opatch]$ unzip p21352635_112040_Linux-x86-64.zip
[oracle@11g opatch]$ unzip p6880880_112000_Linux-x86-64.zip
[root@11g database]# cd /home/oracle/opatch/
[root@11g opatch]# mv OPatch /home/oracle/app/oracle/product/11.2.0.4/dbhome_1


--oracle用户查看 opatch 工具是否替换正确

[oracle@11g dbhome_1]$ /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch version
OPatch Version: 11.2.0.3.10
OPatch succeeded.

3. 测试兼容性, 如果之前没有打过,这步也可以忽略。

[oracle@11g opatch]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/opatch/21352635 -oh $ORACLE_HOME 
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.

PREREQ session
Oracle Home : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2015-02-16_13-09-28PM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.

4. 为数据库做冷备份

RMAN>run {
shutdown immediate;
startup mount;
allocate channel c1 type disk;
allocate channel c2 type disk;
backup full tag='db_full_bak' database format '/home/oracle/rmanbak/full_cold_%d_%s.bak';
alter database open;
}


使用root用户备份oracle_home （将#ORACLE_HOME上级目录整个备份）
tar -zcvpf db_20170319.tar.gz dbhome_1/

5. 关闭数据库实例及相关进程 (静态监听、动态监听、EOM、相关服务)
--停止数据库外部进程
[root@11g ~]#ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9 
SQL> shutdown immediate;
[oracle@11g rmanbak]$ cat /home/oracle/app/oracle/product/11.2.0/dbhome_1/network/admin/listener.ora
[oracle@11g rmanbak]$ lsnrctl stop
[oracle@11g rmanbak]$ lsnrctl status
[oracle@11g rmanbak]$ ps -ef |grep ora_|grep -v grep
[oracle@11g rmanbak]$ netstat -an |grep 1521
[oracle@11g rmanbak]$ netstat -an |grep 1158

6.oracle database 打补丁

[oracle@11g dbhome_1]$ $ORACLE_HOME/OPatch/opatch napply -oh $ORACLE_HOME -local /ho
ome/oracle/opatch/21352635
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2015-02-16_13-29-43PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches: 17478514 18031668 18522509 19121551 19769489 20299013 20760982 21352635 
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 = '/home/oracle/app/oracle/product/11.2.0.4/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 '/home/oracle/app/oracle/product/11.2.0.4/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 '/home/oracle/app/oracle/product/11.2.0.4/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 '/home/oracle/app/oracle/product/11.2.0.4/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 '/home/oracle/app/oracle/product/11.2.0.4/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...
Applying sub-patch '19769489' to OH '/home/oracle/app/oracle/product/11.2.0.4/dbhome_1'
ApplySession: Optional component(s) [ oracle.sysman.agent, 11.2.0.4.0 ] not present in the Oracle Home or a higher version is found.

Patching component oracle.precomp.common, 11.2.0.4.0...
Patching component oracle.ovm, 11.2.0.4.0...
Patching component oracle.xdk, 11.2.0.4.0...
Patching component oracle.rdbms.util, 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.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.oraolap, 11.2.0.4.0...
Patching component oracle.rdbms.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...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Verifying the update...
Applying sub-patch '20299013' to OH '/home/oracle/app/oracle/product/11.2.0.4/dbhome_1'
Patching component oracle.rdbms.dv, 11.2.0.4.0...
Patching component oracle.rdbms.oci, 11.2.0.4.0...
Patching component oracle.precomp.common, 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.sysman.common, 10.2.0.4.5...
Patching component oracle.rdbms, 11.2.0.4.0...
Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...
Patching component oracle.xdk.parser.java, 11.2.0.4.0...
Patching component oracle.sysman.console.db, 11.2.0.4.0...
Patching component oracle.xdk.rsf, 11.2.0.4.0...
Patching component oracle.rdbms.rsf, 11.2.0.4.0...
Patching component oracle.sysman.common.core, 10.2.0.4.5...
Patching component oracle.rdbms.rman, 11.2.0.4.0...
Patching component oracle.rdbms.deconfig, 11.2.0.4.0...

Verifying the update...
Applying sub-patch '20760982' to OH '/home/oracle/app/oracle/product/11.2.0.4/dbhome_1'

Patching component oracle.sysman.console.db, 11.2.0.4.0...

Patching component oracle.rdbms, 11.2.0.4.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.4.0...

Verifying the update...
Applying sub-patch '21352635' to OH '/home/oracle/app/oracle/product/11.2.0.4/dbhome_1'

Patching component oracle.sysman.agent, 10.2.0.4.5...
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...

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.
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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_emagent.mk' has modification time 1.7e+07 s in the future
make[1]: Warning: File `/home/oracle/app/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk' has modification time 1.7e+07 s in the future
make[1]: warning: Clock skew detected. Your build may be incomplete.
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_emagent.mk' has modification time 1.7e+07 s in the future
make[1]: Warning: File `/home/oracle/app/oracle/product/11.2.0.4/dbhome_1/sysman/lib/ins_emagent.mk' has modification time 1.7e+07 s in the future
make[1]: warning: Clock skew detected. Your build may be incomplete.
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.
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:
make: Warning: File `ins_rdbms.mk' has modification time 1.7e+07 s in the future
make: warning: Clock skew detected. Your build may be incomplete.

Composite patch 21352635 successfully applied.
OPatch Session completed with warnings.
Log file location: /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2015-02-16_13-29-43PM_1.log
OPatch completed with warnings.
[oracle@11g dbhome_1]$

7. 查看打补丁情况：

[oracle@11g dbhome_1]$ /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/OPatch/opatch lsinv
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation. All rights reserved.
Oracle Home : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1
Central Inventory : /home/oracle/oraInventory
from : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.10
OUI version : 11.2.0.4.0
Log file location : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/opatch2015-02-16_13-39-51PM_1.log

Lsinventory Output file location : /home/oracle/app/oracle/product/11.2.0.4/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2015-02-16_13-39-51PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: 11g
ARU platform id: 226
ARU platform description:: Linux x86-64

Installed Top-level Products (1):

Oracle Database 11g 11.2.0.4.0
There are 1 products installed in this Oracle Home.

Interim patches (1) :

Patch 21352635 : applied on Mon Feb 16 13:34:31 EST 2015
Unique Patch ID: 19227862
Patch description: "Database Patch Set Update : 11.2.0.4.8 (21352635)"
Created on 1 Sep 2015, 07:49:44 hrs 
Sub-patch 20760982; "Database Patch Set Update : 11.2.0.4.7 (20760982)"
Sub-patch 20299013; "Database Patch Set Update : 11.2.0.4.6 (20299013)"
Sub-patch 19769489; "Database Patch Set Update : 11.2.0.4.5 (19769489)"
Sub-patch 19121551; "Database Patch Set Update : 11.2.0.4.4 (19121551)"
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, 21051852, 18607546, 17205719, 17811429, 17816865, 20506699
17922254, 17754782, 16934803, 13364795, 17311728, 17441661, 17284817
16992075, 17446237, 14015842, 19972569, 21538558, 20925795, 17449815
17375354, 19463897, 17982555, 17235750, 13866822, 18317531, 17478514
18235390, 14338435, 20803583, 13944971, 20142975, 17811789, 16929165
18704244, 20506706, 17546973, 20334344, 14054676, 17088068, 18264060
17346091, 17343514, 21538567, 19680952, 18471685, 19211724, 13951456
16315398, 18744139, 16850630, 19049453, 18673304, 17883081, 19915271
18641419, 18262334, 17006183, 16065166, 18277454, 16833527, 10136473
18051556, 17865671, 17852463, 18554871, 17853498, 18334586, 17588480
17551709, 19827973, 17842825, 17344412, 18828868, 17025461, 11883252
13609098, 17239687, 17602269, 19197175, 18316692, 17313525, 12611721
19544839, 18964939, 17600719, 18191164, 19393542, 17571306, 18482502
20777150, 19466309, 17040527, 17165204, 18098207, 16785708, 17174582
16180763, 17465741, 16777840, 12982566, 19463893, 12816846, 16875449
17237521, 19358317, 17811438, 17811447, 17945983, 18762750, 17184721
16912439, 18061914, 17282229, 18331850, 18202441, 17082359, 18723434
19554106, 14034426, 18339044, 19458377, 17752995, 20448824, 17891943
17258090, 17767676, 16668584, 18384391, 17040764, 17381384, 15913355
18356166, 14084247, 20506715, 13853126, 18203837, 14245531, 16043574
17848897, 17877323, 17468141, 17786518, 17912217, 17037130, 18155762
16956380, 17478145, 17394950, 18189036, 18641461, 18619917, 17027426
21352646, 16268425, 19584068, 18436307, 17265217, 17634921, 13498382
20004087, 17443671, 18000422, 20004021, 17571039, 21067387, 16344544
18009564, 14354737, 18135678, 18614015, 20441797, 18362222, 17835048
16472716, 17936109, 17050888, 17325413, 14010183, 18747196, 17761775
16721594, 17082983, 20067212, 21179898, 17302277, 18084625, 15990359
18203835, 17297939, 17811456, 16731148, 17215560, 13829543, 14133975
17694209, 18091059, 17385178, 8322815, 17586955, 17201159, 17655634
18331812, 19730508, 18868646, 17648596, 16220077, 16069901, 17348614
17393915, 17274537, 17957017, 18096714, 17308789, 18436647, 14285317
19289642, 14764829, 18328509, 17622427, 16943711, 14368995, 17346671
18996843, 17783588, 16618694, 17672719, 18856999, 18783224, 17851160
17546761, 17798953, 18273830, 19972566, 16384983, 17726838, 17360606
13645875, 18199537, 16542886, 17889549, 14565184, 17071721, 20299015
17610798, 20657441, 17397545, 18230522, 16360112, 19769489, 12905058
18641451, 12747740, 18430495, 17042658, 17016369, 14602788, 19972568
18508861, 19788842, 14657740, 17332800, 13837378, 19972564, 17186905
18315328, 19699191, 17437634, 19006849, 19013183, 17296856, 18674024
17232014, 16855292, 21051840, 14692762, 17762296, 17705023, 19121551
19854503, 19309466, 18681862, 18554763, 20558005, 17390160, 18456514
16306373, 13955826, 18139690, 17501491, 17299889, 17752121, 17889583
18673325, 18293054, 17242746, 17951233, 17649265, 18094246, 19615136
17011832, 16870214, 17477958, 18522509, 20631274, 16091637, 17323222
16595641, 16524926, 18228645, 18282562, 17596908, 17156148, 18031668
16494615, 17545847, 17614134, 13558557, 17341326, 17891946, 17716305
16392068, 19271443, 18092127, 18440047, 17614227, 14106803, 16903536
18973907, 18673342, 17389192, 16194160, 17006570, 17612828, 17721717
17570240, 17390431, 16863422, 18325460, 19727057, 16422541, 19972570
17267114, 18244962, 21538485, 18765602, 18203838, 16198143, 17246576
14829250, 17835627, 18247991, 14458214, 21051862, 16692232, 17786278
17227277, 16042673, 16314254, 16228604, 16837842, 17393683, 17787259
20331945, 20074391, 15861775, 16399083, 18018515, 18260550, 21051858
17036973, 16613964, 17080436, 16579084, 18384537, 18280813, 20296213
16901385, 15979965, 18441944, 16450169, 9756271, 17892268, 11733603
16285691, 17587063, 16538760, 18180390, 18193833, 21051833, 17238511
17824637, 16571443, 18306996, 14852021, 18674047, 17853456, 12364061

--------------------------------------------------------------------------------
OPatch succeeded.

8. 升级数据库数据字典、编译无效对象 。 
数据库启动，并加载修改SQL Files到数据库

[oracle@11g opatch]$ sqlplus / as sysdba
SQL> startup;
-- 升级数据库数据字典
SQL> @?/rdbms/admin/catbundle.sql psu apply
省略大量输出
。。。。。。
SQL> SET echo off ## 输出末尾内容
Check the following log file for errors:
/home/oracle/app/cfgtoollogs/catbundle/catbundle_PSU_ORCL_APPLY_2015Feb16_13_42_57.log

--编译无效对象的脚本
SQL>@?/rdbms/admin/utlrp.sql

9. 查看 PSU 更新信息

执行完后我们可以查到PSU更新信息：
set line 150
col ACTION_TIME for a30
col ACTION for a8
col NAMESPACE for a8
col VERSION for a10
col BUNDLE_SERIES for a5
col COMMENTS for a20
select * from dba_registry_history;

ACTION_TIME ACTION NAMESPAC VERSION ID BUNDL COMMENTS
------------------------------ -------- -------- ---------- ---------- ----- --------------------
16-FEB-15 05.46.48.580786 AM VIEW INV 8289601 view invalidation
ALIDATE

16-FEB-15 05.47.05.038595 AM UPGRADE SERVER 11.2.0.4.0 Upgraded from 11.2.0.1.0 
16-FEB-15 05.47.54.530480 AM APPLY SERVER 11.2.0.4 0 PSU Patchset 11.2.0.2.0
16-FEB-15 01.43.52.624550 PM APPLY SERVER 11.2.0.4 8 PSU PSU 11.2.0.4.8

--查看无效对象
select count(*) from dba_objects where status<>'VALID';
COUNT(*)
----------
0

--- 查看监听是否正常
[oracle@11g opatch]$ lsnrctl status

 

本文转自 张冲andy 博客园博客，原文链接：  http://www.cnblogs.com/andy6/p/6582026.html ，如需转载请自行联系原作者


文章标签：
关系型数据库
Oracle
数据库
OLAP
安全
关键词：
Oracle数据库一键上云11g
Oracle数据库一键上云单机
Oracle数据库一键上云PSU
Oracle数据库一键上云补丁psu
技术小美
目录
相关文章
坚持学习永不言弃
|
4月前
|
Oracle 关系型数据库 数据库
使用docker安装配置oracle 11g
使用docker安装配置oracle 11g
坚持学习永不言弃
151 0
非著名运维
|
6月前
|
Oracle 关系型数据库 数据库
Oracle 11G常见性能诊断报告(AWR/ADDM/ASH)收集
Oracle 11G常见性能诊断报告(AWR/ADDM/ASH)收集
非著名运维
92 0
机器学习Zero
|
1月前
|
存储 Oracle 关系型数据库
手把手教你安装Oracle——以oracle 11g为例
手把手教你安装Oracle——以oracle 11g为例
机器学习Zero
35 0
手把手教你安装Oracle——以oracle 11g为例
snowofsummer
|
2月前
|
Oracle 关系型数据库
oracle rac 手工安装补丁，不适用auto
oracle rac 手工安装补丁，不适用auto
snowofsummer
25 3
yuanfan_2012
|
3月前
|
Oracle 关系型数据库 Linux
RHEL7.9系统下一键脚本安装Oracle 11gR2单机版本
RHEL7.9系统下一键脚本安装Oracle 11gR2单机版本
yuanfan_2012
58 1
ap1253j8y
|
4月前
|
SQL Oracle 关系型数据库
docker 方式安装ORACLE 11g
docker 方式安装ORACLE 11g
ap1253j8y
198 4
vohelon
|
5月前
|
Oracle 关系型数据库 数据库
在Flink CDC中，使用Oracle 11g数据库的NUMBER类型作为主键
在Flink CDC中，使用Oracle 11g数据库的NUMBER类型作为主键
vohelon
48 1
讓丄帝愛伱
|
5月前
|
SQL Oracle 安全
window下Oracle 11G安装文档
window下Oracle 11G安装文档
讓丄帝愛伱
37 0
小小鱼儿小小林
|
7月前
|
Oracle 关系型数据库
Oracle 11g和12c的主要区别
Oracle 11g和12c的主要区别
小小鱼儿小小林
53 0
小山猪
|
9月前
|
Oracle 关系型数据库 数据库连接
Oracle 11g安装配置完美教程 - Windows（下）
Oracle 11g安装配置完美教程 - Windows（下）
小山猪
154 0

热门文章

最新文章

  • 1
    Seata常见问题之oracle 数据库 报 just support mysql如何解决
  • 2
    【Oracle】玩转Oracle数据库（一）：装上去，飞起来！
  • 3
    【Oracle】玩转Oracle数据库（七）：RMAN恢复管理器
  • 4
    【Oracle】玩转Oracle数据库（二）：体系结构、存储结构与各类参数
  • 5
    Oracle的PL/SQL游标属性：数据的“导航仪”与“仪表盘”
  • 6
    Oracle数据库基本概念理解（3）
  • 7
    oracle基本笔记整理及案例分析1
  • 8
    oracle 访问控制
  • 9
    Oracle数据区：数据王国的黄金地段
  • 10
    Oracle数据库基本概念理解（1）
  • 1
    Oracle数据守卫（DG）：数据的“守护者”与“时光机”
    9
  • 2
    Oracle 12c的内存列存储：数据的“闪电侠”
    13
  • 3
    Oracle 12c的多重索引：数据的“多维导航仪”
    8
  • 4
    Oracle 12c的自动数据优化（ADO）与热图：数据管理的“瘦身”与“透视”艺术
    13
  • 5
    Oracle 12c多租户架构：数据管理的“摩天大楼”
    12
  • 6
    Oracle数据泵：数据迁移的魔法棒
    5
  • 7
    Oracle中的触发器与序列：自增列的魔法组合
    10
  • 8
    Oracle的PL/SQL游标属性：数据的“导航仪”与“仪表盘”
    27
  • 9
    Oracle的PL/SQL循环语句：数据的“旋转木马”与“无限之旅”
    10
  • 10
    Oracle的PL/SQL条件控制：数据的“红绿灯”与“分岔路”
    12

    • 相关电子书

    更多
  • PostgresChina2018_樊文凯_ORACLE数据库和应用异构迁移最佳实践
  • PostgresChina2018_王帅_从Oracle到PostgreSQL的数据迁移
  • Oracle云上最佳实践

    • 推荐镜像

    更多
  • oracle
  • mysql
  • arch4edu
    • 下一篇
    部署LAMP环境（Alibaba Cloud Linux 3）