oracle 打补丁

1

2

3

4

[oracle@localhost OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.16

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

12:40:47 SYS@std> set linesize 500 pagesize 600

12:40:49 SYS@std> col COMP_NAME for a30

12:41:06 SYS@std> select COMP_ID,COMP_NAME,VERSION,STATUS from DBA_REGISTRY;

COMP_ID      COMP_NAME      VERSION      STATUS

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

OWB       OWB       11.2.0.4.0      VALID

APEX       Oracle Application Express  3.2.1.00.12     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.

Elapsed: 00:00:00.04

1

2

3

4

5

6

7

8

9

10

12:41:11 SYS@std> col ACTION_TIME for a30

12:46:03 SYS@std> col COMMENTS for a30

12:46:07 SYS@std> select ACTION_TIME, ACTION,version, COMMENTS from sys.DBA_REGISTRY_HISTORY;

ACTION_TIME     ACTION       VERSION      COMMENTS

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

24-AUG-13 12.03.45.119862 PM APPLY       11.2.0.4      Patchset 11.2.0.2.0

22-MAR-19 12.02.16.970055 PM APPLY       11.2.0.4      Patchset 11.2.0.2.0

Elapsed: 00:00:00.01

1

2

3

4

5

12:46:11 SYS@std> select count(*) from dba_objects where status<>'VALID';

 COUNT(*)

----------

   0

1

2

3

4

5

6

7

8

9

10

11

12

13

[oracle@localhost OPatch]$ ./opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /home/oracle/28689165/ -oh $ORACLE_HOME 

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2019, Oracle Corporation. All rights reserved.

PREREQ session

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.16

OUI version  : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-22_13-02-45PM_1.log

Invoking prereq "checkconflictagainstohwithdetail"

Prereq "checkConflictAgainstOHWithDetail" passed.

OPatch succeeded.

1

ps -ef|grep -v grep |grep LOCAL=NO|awk '{print $2}'|xargs kill -9

1

2

3

4

5

13:11:12 SYS@std> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

13:11:28 SYS@std>

1

2

3

4

5

6

[oracle@localhost OPatch]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.4.0 - Production on 22-MAR-2019 13:12:51

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

Connecting to (ADDRESS=(PROTOCOL=tcp)(HOST=)(PORT=1521))

The command completed successfully

[oracle@localhost OPatch]$

1

2

3

4

[oracle@localhost OPatch]$ ps -ef |grep ora_|grep -v grep

[oracle@localhost OPatch]$ netstat -an |grep 1158

[oracle@localhost OPatch]$ netstat -an|grep 1521

[oracle@localhost OPatch]$

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

[oracle@localhost OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2019, 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.16

OUI version  : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-44-35AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_08-44-35AM.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.4.0

There are 1 products installed in this Oracle Home.

There are no Interim patches installed in this Oracle Home.

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

OPatch succeeded.

[oracle@localhost OPatch]$

./opatch napply -oh $ORACLE_HOME -local /home/oracle/28689165

many more lines compressed..

+ make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfhc.so _LIBNAME=libnmcfhc _LIBDIR=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_LIBNAME_LIBS=$(libnmcfhcLIBS)' '_LIBNAME_EXTRALIBS=$(libnmcfhcEXTRALIBS)'

+ PATH=/bin:/usr/bin:/usr/ccs/bin

+ export PATH

+ lib=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so

+ makefile=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk

+ so_ext=so

+ target=new_ld_shlib

+ var=

++ basename /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so .so

+ libname=libnmcfsga

++ dirname /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so

+ dir=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib

+ '[' var = new_ld_shlib ']'

+ '[' -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.a ']'

+ dir2=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/

+ '[' '' '!=' '' ']'

+ make -f /u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ins_emagent.mk new_ld_shlib _FULL_LIBNAME=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/libnmcfsga.so _LIBNAME=libnmcfsga _LIBDIR=/u01/app/oracle/product/11.2.0/dbhome_1/sysman/lib/ '_LIBNAME_LIBS=$(libnmcfsgaLIBS)' '_LIBNAME_EXTRALIBS=$(libnmcfsgaEXTRALIBS)'

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

/bin/ld: warning: -z lazyload ignored.

/bin/ld: warning: -z nolazyload ignored.

Composite patch 28204707 successfully applied.

Patch 28440700 successfully applied.

OPatch Session completed with warnings.

Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_08-50-02AM_1.log

OPatch completed with warnings.

[oracle@localhost OPatch]$ ./opatch lsinventory

Oracle Interim Patch Installer version 11.2.0.3.16

Copyright (c) 2019, 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.16

OUI version  : 11.2.0.4.0

Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2019-03-25_09-02-42AM_1.log

Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2019-03-25_09-02-42AM.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.4.0

There are 1 products installed in this Oracle Home.

Interim patches (2) :

Patch 28440700  : applied on Mon Mar 25 08:54:00 CST 2019

Unique Patch ID: 22461927

Patch description: "OJVM PATCH SET UPDATE 11.2.0.4.181016"

 Created on 15 Oct 2018, 08:12:17 hrs PST8PDT

 Bugs fixed:

  18933818, 19176885, 17201047, 25649873, 25067795, 28502128, 27952577

  14774730, 27461842, 19153980, 21911849, 23727132, 18166577, 27000663

  24448240, 17056813, 21811517, 19909862, 25494379, 22675136, 24534298

  19895326, 22253904, 17804361, 19231857, 27642235, 26023002, 17528315

  19058059, 19554117, 19007266, 17285560, 22670385, 18458318, 19187988

  23265914, 19699946, 19006757, 19374518, 19223010, 25076732, 22118835

  26637592, 19852360, 20408829, 21047766, 21566944

Patch 28204707  : applied on Mon Mar 25 08:53:49 CST 2019

Unique Patch ID: 22491169

Patch description: "Database Patch Set Update : 11.2.0.4.181016 (28204707)"

 Created on 19 Sep 2018, 03:24:06 hrs PST8PDT

Sub-patch 27734982; "Database Patch Set Update : 11.2.0.4.180717 (27734982)"

Sub-patch 27338049; "Database Patch Set Update : 11.2.0.4.180417 (27338049)"

Sub-patch 26925576; "Database Patch Set Update : 11.2.0.4.180116 (26925576)"

Sub-patch 26392168; "Database Patch Set Update : 11.2.0.4.171017 (26392168)"

Sub-patch 26609445; "Database Patch Set Update : 11.2.0.4.170814 (26609445)"

Sub-patch 25869727; "Database Patch Set Update : 11.2.0.4.170718 (25869727)"

Sub-patch 24732075; "Database Patch Set Update : 11.2.0.4.170418 (24732075)"

Sub-patch 24006111; "Database Patch Set Update : 11.2.0.4.161018 (24006111)"

Sub-patch 23054359; "Database Patch Set Update : 11.2.0.4.160719 (23054359)"

Sub-patch 22502456; "Database Patch Set Update : 11.2.0.4.160419 (22502456)"

Sub-patch 21948347; "Database Patch Set Update : 11.2.0.4.160119 (21948347)"

Sub-patch 21352635; "Database Patch Set Update : 11.2.0.4.8 (21352635)"

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:

  21174504, 17184721, 21538558, 16091637, 18092127, 17381384, 15979965

  20671094, 16731148, 16314254, 13837378, 18441944, 17291347, 17835048

  28254374, 21656630, 21842740, 13558557, 17008068, 17201159, 25427662

  17853498, 20717359, 17246576, 18356166, 18681862, 18440047, 20569094

  20031873, 16875449, 20387265, 19788842, 17296856, 21330264, 14010183

  17648596, 17551063, 17025461, 24719736, 21063322, 17267114, 22507210

  17912217, 17889583, 18202441, 17040764, 17478145, 16524926, 25655390

  19358317, 22730454, 22148226, 18747196, 26544823, 18641419, 17036973

  18948177, 17811789, 16542886, 14285317, 18009564, 17359610, 16618694

  8322815, 16832076, 18247991, 16692232, 22507234, 17570240, 13871092

  24624166, 26631046, 19429927, 24348685, 17848897, 17441661, 14034426

  17465741, 20273319, 19207156, 16596890, 17437634, 21343897, 20506706

  21453153, 18339044, 17951233, 22321741, 21795111, 18430495, 21787056

  22380919, 19692824, 19469538, 20506715, 17811429, 19721304, 17903598

  18230522, 19554106, 19458377, 21281607, 17612828, 6599380, 22092979

  17040527, 22321756, 17811438, 18641461, 18682983, 25635149, 14657740

  13364795, 21387964, 19490948, 17346671, 17588480, 22351572, 18235390

  26474853, 18849970, 17889549, 19309466, 16472716, 25775213, 20596234

  18331850, 18641451, 17019356, 17344412, 19461270, 21179898, 17546761

  24842886, 17231779, 14521849, 18203835, 18203838, 18964939, 18203837

  17313525, 22195457, 18139690, 16837842, 22296366, 14106803, 17842825

  21352646, 22657942, 22594718, 16360112, 20657441, 22195441, 17389192

  26198926, 14565184, 17019345, 17205719, 18740837, 18440095, 14764829

  22195448, 14354737, 17019086, 13944971, 16571443, 21868720, 17186905

  17080436, 18673342, 22905130, 17027426, 27374796, 19972569, 19972568

  20144308, 19972566, 17282229, 19972564, 16870214, 16410570, 21629064

  19615136, 26039623, 21354456, 17390431, 18762750, 23007241, 16613964

  17957017, 18098207, 17484762, 18471685, 19730508, 21538485, 18264060

  17323222, 17754782, 17600719, 18317531, 17852463, 17596908, 18166013

  17655634, 16228604, 27053456, 20074391, 24790914, 19972570, 20856766

  19891090, 18090142, 18996843, 19854503, 16042673, 22901797, 17835627

  20334344, 17393683, 20861693, 18000422, 17551709, 26575788, 23315889

  20506699, 19006849, 18277454, 18456514, 19174430, 17258090, 17174582

  25654936, 17242746, 16399083, 17824637, 21132297, 22465352, 17762296

  22168163, 18604692, 17397545, 16450169, 12364061, 20067212, 18856999

  19211724, 19463893, 19463897, 21343775, 17853456, 18673304, 20004021

  26030218, 21668627, 16194160, 17477958, 23140259, 16538760, 12982566

  24570598, 20828947, 18259031, 20296213, 18293054, 17610798, 19699191

  23065323, 17311728, 18135678, 18774543, 23294548, 16785708, 10136473

  24560906, 22551446, 19777862, 17786518, 25879984, 18315328, 18334586

  12747740, 18096714, 19032867, 21641760, 17390160, 18899974, 17232014

  16354467, 26245237, 26679352, 20598042, 17484731, 18673325, 16422541

  18155762, 14015842, 19827973, 22683225, 17726838, 18554871, 23177648

  18051556, 20803583, 21972320, 15990359, 17922254, 18282562, 16855292

  16668584, 21343838, 20299015, 17446237, 18093615, 18043064, 23713236

  17694209, 17288409, 18308268, 20475845, 17274537, 13955826, 16934803

  17634921, 17501491, 16315398, 22683212, 23725036, 17006183, 13829543

  18191164, 17655240, 22809871, 26746894, 18384391, 19393542, 21538567

  16198143, 21847223, 25823754, 17892268, 20142975, 19584068, 17165204

  25165496, 18604493, 21756699, 18508861, 16901385, 18554763, 21532755

  18189036, 17443671, 17385178, 14829250, 17936109, 20925795, 20509482

  17478514, 27441326, 16850630, 13951456, 16595641, 14054676, 15861775

  21142837, 16912439, 17299889, 17297939, 23003979, 18619917, 16833527

  17798953, 17816865, 25914276, 18607546, 17571306, 21286665, 17341326

  26910644, 17851160, 20558005, 17586955, 19049453, 21051840, 17587063

  16956380, 18328509, 25423453, 14133975, 19718981, 18061914, 17518652

  18522509, 21051833, 20294666, 18765602, 20860659, 18272672, 20324049

  18199537, 17332800, 13609098, 22502493, 18384537, 14338435, 17945983

  16392068, 21067387, 17752995, 21051862, 16863422, 17237521, 25505382

  18244962, 19544839, 24433711, 24717859, 17156148, 18973907, 23026585

  17877323, 17449815, 18180390, 17088068, 17037130, 20004087, 21422580

  19466309, 11733603, 25505371, 18610915, 21051858, 18084625, 26243698

  18674024, 21051852, 18091059, 25369547, 16306373, 18306996, 17787259

  18193833, 19915271, 20513399, 20631274, 25879656, 16344544, 14692762

  18614015, 17346091, 18228645, 17721717, 13960236, 18685892, 18436307

  21756677, 19888853, 11883252, 17891943, 19475971, 22353199, 16384983

  19121551, 25634317, 27825893, 12816846, 17982555, 17761775, 22243719

  17265217, 25505394, 17071721, 16721594, 18262334, 21756661, 17891946

  15913355, 17672719, 17602269, 25555252, 17239687, 17042658, 17238511

  17811456, 17284817, 17752121, 20879889, 21380789, 17394950, 17011832

  16579084, 22195465, 14602788, 18325460, 24476265, 26569225, 24476274

  12611721, 18674465, 16903536, 17006570, 19689979, 16043574, 18783224

  24662775, 16494615, 21526048, 17392698, 19197175, 16069901, 17811447

  27870645, 17308789, 22195477, 24835538, 17865671, 17343514, 19013183

  17325413, 18316692, 16180763, 17348614, 14368995, 21983325, 17393915

  16285691, 19211433, 20331945, 17883081, 17705023, 24316947, 17614227

  19578350, 22195485, 24975421, 14084247, 26078387, 23115139, 13645875

  16777840, 19727057, 14852021, 18744139, 18674047, 17716305, 19285025

  18482502, 17622427, 19289642, 27534509, 22195492, 25947799, 14458214

  20869721, 21172913, 17767676, 18723434, 25505407, 17786278, 19258504

  17082983, 21351877, 17365043, 13498382, 18331812, 16065166, 25489607

  16685417, 18031668, 22893153, 17551674, 16943711, 19272701, 21517440

  25897615, 17649265, 13866822, 18094246, 24528741, 17783588, 14245531

  17082359, 18280813, 20448824, 23330119, 16268425, 19487147, 25600421

  18018515, 17302277, 17215560, 24411921, 19271443, 14176370, 25764020

  17016369, 20777150, 23330124, 16756406, 20441797, 19769489, 28100487

  17545847, 25093656, 18260550, 13853126, 17551699, 17227277, 23536835

  25957038, 24652769, 20725343, 19207117, 9756271, 18868646, 17614134

  26667023, 17546973, 18704244, 19680952, 26667015, 17050888, 18828868

  18273830, 17360606, 16992075, 24563422, 17375354, 12905058, 18362222

  21429602, 28364007, 26667032, 27086138, 17571039, 17468141, 18436647

  17570606, 17235750, 21168487, 17279227, 16220077, 16929165

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

OPatch succeeded.

1

2

3

4

5

6

7

8

9

10

11

12

13

14

[oracle@localhost 28689165]$ cd $ORACLE_HOME/rdbms/admin

[oracle@localhost admin]$ sql

SQL*Plus: Release 11.2.0.4.0 Production on Mon Mar 25 11:10:53 2019

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

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

11:10:53 SYS@std> @catbundle.sql psu apply

PL/SQL procedure successfully completed.

Elapsed: 00:00:00.00

Function created.

Elapsed: 00:00:00.14

Function created.

many more lines compressed