设为首页 收藏本站
查看: 666|回复: 0

[经验分享] racle database 11.2.0.3.0 升级至 11.2.0.3.1

[复制链接]
累计签到:1 天
连续签到:1 天
发表于 2015-9-21 09:40:43 | 显示全部楼层 |阅读模式
下载PSU
p20299017_112030_Linux-x86-64(DATABASE PATCH SET UPDATE 11.2.0.3.14 (INCLUDES CPUAPR2015)).zip
及Opatch

p6880880_112000_Linux-x86-64(OPatch patch of version 11.2.0.3.10 for Oracle software releases 11..zip
下载地址 http://yunpan.cn/cHACmBerMb526 访问密码 56b2

使用最新的Opatch替换ORACLE_HOME下的Opatch
1
2
3
4
[oracle@localhost db_1]$ pwd
/u01/app/oracle/product/11.2.0.3/db_1
[oracle@localhost db_1]$ mv OPatch/ OPatch_bak
[oracle@localhost db_1]$ unzip /home/oracle/p6880880_112000_Linux-x86-64\(OPatch\ patch\ of\ version\ 11.2.0.3.10\ for\ Oracle\ software\ releases\ 11..zip




解压p20299017
1
2
3
[oracle@localhost ~]$ pwd
/home/oracle
[oracle@localhost ~]$ unzip p20299017_112030_Linux-x86-64\(DATABASE\ PATCH\ SET\ UPDATE\ 11.2.0.3.14\ \(INCLUDES\ CPUAPR2015\)\).zip




关闭数据库及监听
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
[oracle@localhost ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 18 14:14:28 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 18-SEP-2015 14:14:49

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.199.240)(PORT=1521)))
The command completed successfully



检查是否有与20299017有冲突的PSU

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
[oracle@localhost ~]$ cd 20299017/
[oracle@localhost 20299017]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation.  All rights reserved.

PREREQ session

Oracle Home       : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version    : 11.2.0.3.10
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_14-17-43PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.




应用补丁
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
[oracle@localhost 20299017]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version    : 11.2.0.3.10
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_14-20-29PM_1.log

Verifying environment and performing prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:


Following executables are active :
/u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1
UtilSession failed: Prerequisite check "CheckActiveFilesAndExecutables" failed.
Log file location: /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_14-20-29PM_1.log

OPatch failed with error code 73



错误显示libclntsh.so.11.1正在活动。
使用fuser检查哪个程序在使用
1
2
3
4
5
[oracle@localhost 20299017]$ fuser /u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1
/u01/app/oracle/product/11.2.0.3/db_1/lib/libclntsh.so.11.1:  5354m 58972m
[oracle@localhost 20299017]$ ps -ef | grep 5354
oracle    5354 58947  4 14:15 pts/2    00:00:26 /u01/app/oracle/product/11.2.0.3/db_1/jdk/bin/java -server -Xmx384M -XX:MaxPermSize=400M -XX:MinHeapFreeRatio=20 -XX:MaxHeapFreeRatio=40 -DORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1 -Doracle.home=/u01/app/oracle/product/11.2.0.3/db_1/oc4j -Doracle.oc4j.localhome=/u01/app/oracle/product/11.2.0.3/db_1/localhost_orcl/sysman -DEMSTATE=/u01/app/oracle/product/11.2.0.3/db_1/localhost_orcl -Doracle.j2ee.dont.use.memory.archive=true -Djava.protocol.handler.pkgs=HTTPClient -Doracle.security.jazn.config=/u01/app/oracle/product/11.2.0.3/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/jazn.xml -Djava.security.policy=/u01/app/oracle/product/11.2.0.3/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/java2.policy -Djavax.net.ssl.KeyStore=/u01/app/oracle/product/11.2.0.3/db_1/sysman/config/OCMTrustedCerts.txt-Djava.security.properties=/u01/app/oracle/product/11.2.0.3/db_1/oc4j/j2ee/home/config/jazn.security.props -DEMDROOT=/u01/app/oracle/product/11.2.0.3/db_1/localhost_orcl -Dsysman.md5password=true -Drepapi.oracle.home=/u01/app/oracle/product/11.2.0.3/db_1 -Ddisable.checkForUpdate=true -Doracle.sysman.ccr.ocmSDK.websvc.keystore=/u01/app/oracle/product/11.2.0.3/db_1/jlib/emocmclnt.ks -Dice.pilots.html4.ignoreNonGenericFonts=true -Djava.awt.headless=true -jar /u01/app/oracle/product/11.2.0.3/db_1/oc4j/j2ee/home/oc4j.jar -config /u01/app/oracle/product/11.2.0.3/db_1/oc4j/j2ee/OC4J_DBConsole_localhost_orcl/config/server.xml
oracle    6236  2877  0 14:25 pts/0    00:00:00 grep 5354



应该是dbconsole还没有关闭
1
2
3
4
5
6
7
8
9
10
11
12
13
[oracle@localhost 20299017]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://localhost:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0.3/db_1/localhost_orcl/sysman/log
[oracle@localhost 20299017]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://localhost:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
...  Stopped.



再次应用patch

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
[oracle@localhost 20299017]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version    : 11.2.0.3.10
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_14-28-40PM_1.log

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310  16056266  16619892  16902043  17540582  18031683  18522512  19121548  19769496  20299017  

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.3/db_1')


Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files...
Applying sub-patch '13343438' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '13696216' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

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

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '13923374' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.network.listener, 11.2.0.3.0...

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

Verifying the update...
Applying sub-patch '14275605' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.client, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '14727310' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

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

Patching component oracle.sysman.oms.core, 10.2.0.4.4...

Verifying the update...
Applying sub-patch '16056266' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.network.cman, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.network.listener, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.deconfig, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16619892' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.marvel, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sysman.agent, 10.2.0.4.3...

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

Patching component oracle.sysman.repository.core, 10.2.0.4.4...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '16902043' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.idm.oid, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.ldap.rsf, 11.2.0.3.0...

Patching component oracle.ldap.rsf.ic, 11.2.0.3.0...

Patching component oracle.owb.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

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

Verifying the update...
Applying sub-patch '17540582' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.sdo, 11.2.0.3.0...

Patching component oracle.ldap.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.ordim.client, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.sdo.locator, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.ordim.jai, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '18031683' to OH '/u01/app/oracle/product/11.2.0.3/db_1'
ApplySession: Optional component(s) [ oracle.precomp.lang, 11.2.0.3.0 ]  not present in the Oracle Home or a higher version is found.

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.ldap.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '18522512' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.network.rsf, 11.2.0.3.0...

Patching component oracle.precomp.common, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '19121548' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

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

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.rman, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.ordim.client, 11.2.0.3.0...

Patching component oracle.ordim.jai, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '19769496' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.sysman.agent, 10.2.0.4.3...

Patching component oracle.ovm, 11.2.0.3.0...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.rdbms.util, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.0...

Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.oraolap, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Verifying the update...
Applying sub-patch '20299017' to OH '/u01/app/oracle/product/11.2.0.3/db_1'

Patching component oracle.xdk.parser.java, 11.2.0.3.0...

Patching component oracle.sysman.agent, 10.2.0.4.3...

Patching component oracle.xdk.rsf, 11.2.0.3.0...

Patching component oracle.rdbms.rsf, 11.2.0.3.0...

Patching component oracle.xdk, 11.2.0.3.0...

Patching component oracle.rdbms, 11.2.0.3.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_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/ins_precomp.mk:19: warning: overriding commands for target `pcscfg.cfg'
/u01/app/oracle/product/11.2.0.3/db_1/precomp/lib/env_precomp.mk:2160: warning: ignoring old commands for target `pcscfg.cfg'



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.3/db_1/sysman/lib/ins_emagent.mk:113: warning: overriding commands for target `nmosudo'
/u01/app/oracle/product/11.2.0.3/db_1/sysman/lib/ins_emagent.mk:52: warning: ignoring old commands for target `nmosudo'


Composite patch 20299017 successfully applied.
OPatch Session completed with warnings.
Log file location: /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_14-28-40PM_1.log

OPatch completed with warnings.



启动数据库

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
[oracle@localhost 20299017]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 18 14:48:30 2015

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup
ORACLE instance started.

Total System Global Area  835104768 bytes
Fixed Size         2232960 bytes
Variable Size        536874368 bytes
Database Buffers     293601280 bytes
Redo Buffers           2396160 bytes
Database mounted.
Database opened.
SQL> col comments for a30
SQL> col action_time for a30
SQL> set line 200
SQL> select substr(action_time,1,30) action_time,   
    substr(id,1,8) id,   
    substr(action,1,10) action,   
    substr(version,1,8) version,   
    substr(comments,1,20) comments   
    from registry$history;
ACTION_TIME            ID            ACTION                 VERSION           COMMENTS
------------------------------ ------------------------ ------------------------------ ------------------------ ------------------------------
17-SEP-15 11.43.36.642363 PM   8289601         VIEW INVAL                     view invalidation
17-SEP-15 11.43.37.601933 PM              UPGRADE               11.2.0.3         Upgraded from 11.2.0
17-SEP-15 11.44.42.370738 PM   0           APPLY                  11.2.0.3         Patchset 11.2.0.2.0



运行catbundle.sql
1
SQL> @?/rdbms/admin/catbundle.sql psu apply



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
SQL> col comments for a30
SQL> col action_time for a30
SQL> set line 200
SQL> select substr(action_time,1,30) action_time,   
    substr(id,1,8) id,   
    substr(action,1,10) action,   
    substr(version,1,8) version,   
    substr(comments,1,20) comments   
    from registry$history;

ACTION_TIME                    ID                       ACTION                         VERSION                  COMMENTS
------------------------------ ------------------------ ------------------------------ ------------------------ ------------------------------
17-SEP-15 11.43.36.642363 PM   8289601                  VIEW INVAL                                              view invalidation
17-SEP-15 11.43.37.601933 PM                            UPGRADE                        11.2.0.3                 Upgraded from 11.2.0
17-SEP-15 11.44.42.370738 PM   0                        APPLY                          11.2.0.3                 Patchset 11.2.0.2.0
18-SEP-15 02.55.34.904221 PM   14                       APPLY                          11.2.0.3                 PSU 11.2.0.3.14




验证
1
2
3
4
[oracle@localhost OPatch]$ ./opatch lspatches
20299017;Database Patch Set Update : 11.2.0.3.14 (20299017)

OPatch succeeded.



1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
[oracle@localhost OPatch]$ ./opatch lsinventory  
Oracle Interim Patch Installer version 11.2.0.3.10
Copyright (c) 2015, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/product/11.2.0.3/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0.3/db_1/oraInst.loc
OPatch version    : 11.2.0.3.10
OUI version       : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/opatch2015-09-18_15-02-09PM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0.3/db_1/cfgtoollogs/opatch/lsinv/lsinventory2015-09-18_15-02-09PM.txt

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

Installed Top-level Products (1):

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


Interim patches (1) :

Patch  20299017     : applied on Fri Sep 18 14:34:36 CST 2015
Unique Patch ID:  18588265
Patch description:  "Database Patch Set Update : 11.2.0.3.14 (20299017)"
   Created on 2 Mar 2015, 21:45:38 hrs PST8PDT
Sub-patch  19769496; "Database Patch Set Update : 11.2.0.3.13 (19769496)"
Sub-patch  19121548; "Database Patch Set Update : 11.2.0.3.12 (19121548)"
Sub-patch  18522512; "Database Patch Set Update : 11.2.0.3.11 (18522512)"
Sub-patch  18031683; "Database Patch Set Update : 11.2.0.3.10 (18031683)"
Sub-patch  17540582; "Database Patch Set Update : 11.2.0.3.9 (17540582)"
Sub-patch  16902043; "Database Patch Set Update : 11.2.0.3.8 (16902043)"
Sub-patch  16619892; "Database Patch Set Update : 11.2.0.3.7 (16619892)"
Sub-patch  16056266; "Database Patch Set Update : 11.2.0.3.6 (16056266)"
Sub-patch  14727310; "Database Patch Set Update : 11.2.0.3.5 (14727310)"
Sub-patch  14275605; "Database Patch Set Update : 11.2.0.3.4 (14275605)"
Sub-patch  13923374; "Database Patch Set Update : 11.2.0.3.3 (13923374)"
Sub-patch  13696216; "Database Patch Set Update : 11.2.0.3.2 (13696216)"
Sub-patch  13343438; "Database Patch Set Update : 11.2.0.3.1 (13343438)"
   Bugs fixed:
     13593999, 10350832, 19433746, 14138130, 12919564, 14198511, 13561951
     13588248, 13080778, 20134036, 13804294, 16710324, 18031683, 12873183
     16992075, 14193240, 14472647, 12880299, 13369579, 14799269, 13840704
     14409183, 13492735, 14263036, 12857027, 13496884, 14263073, 16038929
     13834436, 13015379, 17748833, 13732226, 16563678, 13866822, 20134034
     13742434, 13944971, 12950644, 17748831, 12899768, 16929165, 16272008
     13063120, 14613900, 13958038, 13503204, 13972394, 11877623, 17088068
     13072654, 12395918, 16710753, 13429702, 13814739, 17343514, 13649031
     13981051, 10256843, 15981698, 13901201, 12797765, 17333200, 19211724
     12923168, 16761566, 13384182, 16279401, 13466801, 15996344, 14207163
     13596581, 18673304, 13724193, 11063191, 13642044, 12940637, 19915271
     12595606, 18641419, 14052871, 9163477, 15931756, 18262334, 13945708
     12797420, 14123213, 13041324, 12865902, 15869211, 14003090, 16314468
     16019955, 11708510, 17865671, 13026410, 14637368, 13737746, 13742438
     15841373, 16347904, 16088176, 15910002, 19517437, 19827973, 16362358
     16505333, 14398795, 14182835, 13579992, 11883252, 16344871, 10182005
     10400244, 13742436, 14275605, 19197175, 9858539, 20477071, 14841812
     16338983, 9703627, 13483354, 14393728, 14207317, 17165204, 20477069
     12764337, 16902043, 14459552, 14191508, 14588746, 12964067, 19358317
     20477440, 12780983, 12583611, 14383007, 14546575, 13476583, 15862016
     13489024, 12985237, 17748830, 19554106, 14088346, 13448206, 19458377
     16314466, 13419660, 18139695, 12591399, 14110275, 13430938, 13467683
     17767676, 14548763, 19638161, 13424216, 12834027, 13632809, 13853126
     13377816, 13036331, 14727310, 9812682, 12320556, 16747736, 13584130
     16175381, 17468141, 12829021, 14138823, 15862019, 12794305, 14546673
     12791981, 13503598, 13787482, 10133521, 12744759, 13399435, 18641461
     19433747, 14023636, 13553883, 14762511, 9095696, 14343501, 12977562
     13860201, 13257247, 14176879, 13783957, 16014985, 14480675, 12312133
     13559697, 13146182, 16306019, 12974860, 9706792, 12940620, 13098318
     13773133, 15883525, 16794244, 13340388, 13528551, 13366202, 12894807
     13259364, 12747437, 13454210, 12748240, 13385346, 15987992, 13923995
     16101465, 14571027, 13582702, 12784406, 13907462, 19769496, 13493847
     13035804, 13857111, 13544396, 16710363, 10110625, 20134033, 14128555
     12813641, 8547978, 14226599, 17478415, 17050888, 16923127, 17333197
     9397635, 14007968, 13912931, 12693626, 12925089, 14189694, 17761775
     12815057, 16721594, 13332439, 20477068, 19972198, 14038787, 11071989
     14207902, 12596444, 14062796, 12913474, 20299010, 14390252, 13840711
     13370330, 16314470, 14062794, 13358781, 12960925, 17333202, 9659614
     13699124, 14546638, 13936424, 9797851, 19433745, 16794240, 14301592
     13338048, 12938841, 12620823, 12656535, 12678920, 13719292, 14488943
     14062792, 16850197, 14791477, 13807411, 16794238, 13250244, 12594032
     15862022, 14098509, 15826962, 12612118, 9761357, 18096714, 19854461
     14053457, 18436647, 13918644, 13527323, 10625145, 18173595, 12797620
     19289642, 15862020, 13910420, 12780098, 13696216, 14774091, 14841558
     10263668, 13849733, 16794242, 16944698, 15862023, 16056266, 13834065
     20134035, 13853654, 14351566, 13723052, 18173593, 14063280, 13011409
     13566938, 13737888, 13624984, 16024441, 17333199, 13914613, 17540582
     14258925, 14222403, 14755945, 13645875, 12571991, 13839641, 14664355
     12998795, 14469008, 13719081, 13361350, 14188650, 17019974, 13742433
     14508968, 16314469, 16368108, 12905058, 6690853, 13647945, 16212405
     12849688, 18641451, 13742435, 13464002, 18681866, 12879027, 13534412
     18522512, 12585543, 12747740, 12535346, 13878246, 13790109, 16382448
     12588744, 13916549, 13786142, 12847466, 13855490, 13551402, 12582664
     19972199, 13871316, 14262913, 14657740, 17332800, 14558880, 14695377
     13612575, 12912137, 13484963, 12387467, 14163397, 17437634, 13772618
     19006849, 16694777, 13070939, 15994107, 14369664, 12391034, 13605839
     12588237, 16279211, 16314467, 12945879, 15901852, 17762296, 14692762
     12976376, 7276499, 12755231, 13680405, 13742437, 14589750, 14318397
     11868640, 14644185, 13326736, 19309466, 13596521, 13001379, 12898558
     13099577, 17752121, 13911711, 9873405, 18673325, 16372203, 16344758
     11715084, 9547706, 16231699, 14040433, 12662040, 12617123, 14406648
     17748832, 16530565, 12845115, 16844086, 13354082, 17748834, 13794550
     13397104, 19537916, 13913630, 16524926, 16462834, 12983611, 13550185
     13810393, 14121009, 13065099, 11840910, 13903046, 15862017, 13572659
     16294378, 13718279, 13657605, 17716305, 14480676, 13632717, 14668670
     14063281, 14158012, 13736413, 13420224, 13812031, 12646784, 16299830
     18440047, 14512189, 10359307, 12755116, 14035825, 17230530, 13616375
     13366199, 13427062, 18673342, 12861463, 15862021, 13092220, 17721717
     13043012, 16619892, 13685544, 18325460, 13499128, 15862018, 19727057
     13839336, 13866372, 13561750, 12718090, 13848402, 13725395, 12401111
     5144934, 12796518, 13362079, 12917230, 12614359, 13042639, 14408859
     13923374, 11732473, 14220725, 12621588, 13524899, 14480674, 14751895
     13916709, 14781609, 14076523, 15905421, 12731940, 13343438, 14205448
     17748835, 15853081, 17082364, 14127231, 14273397, 16844448, 14467061
     12971775, 16864562, 20074391, 14489591, 14497307, 13872868, 12748538
     10242202, 14230270, 13931044, 13686047, 16382353, 14095982, 17333203
     19121548, 13591624, 14523004, 13440516, 16794241, 13499412, 13035360
     14062795, 12411746, 13040943, 12905053, 13843646, 20296213, 18173592
     16794243, 13477790, 14841409, 14609690, 14062797, 13059165, 12959852
     12345082, 16703112, 13890080, 17333198, 16048375, 16450169, 12658411
     13780035, 14062793, 19271438, 19259446, 13038684, 18740215, 16742095
     13742464, 14052474, 13066936, 13060271, 13911821, 13457582, 7509451
     19710542, 13791364, 12821418, 13502183, 13705338, 15856660, 14237793
     16794239, 13554409, 15862024, 13103913, 13645917, 12772404



--------------------------------------------------------------------------------

OPatch succeeded.



运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表,该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有,请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意,请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息,一经发现立即删除。若您因此触犯法律,一切后果自负,我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责,亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏,不得用于商业或者其他用途,否则,一切后果均由您自己承担,我们对此不承担任何法律责任
7、如涉及侵犯版权等问题,请您及时通知我们,我们将立即采取措施予以解决
8、联系人Email:admin@iyunv.com 网址:www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址:https://www.yunweiku.com/thread-116583-1-1.html 上篇帖子: centos oracle 11g 自启动 服务 下篇帖子: Oracle with as (hint inline materialize) database
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群,最新一手资源尽在官方微信交流群!快快加入我们吧...

扫描微信二维码查看详情

客服E-mail:kefu@iyunv.com 客服QQ:1061981298


QQ群⑦:运维网交流群⑦ QQ群⑧:运维网交流群⑧ k8s群:运维网kubernetes交流群


提醒:禁止发布任何违反国家法律、法规的言论与图片等内容;本站内容均来自个人观点与网络等信息,非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来,其版权均归原作者及其网站所有,我们尊重他人的合法权益,如有内容侵犯您的合法权益,请及时与我们联系进行核实删除!



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表