oracle 打补丁

最新推荐文章于 2024-06-26 14:26:14 发布

羽之大公公

最新推荐文章于 2024-06-26 14:26:14 发布

阅读量710

点赞数

分类专栏： oracle

原文链接：https://www.jb51.net/article/168203.htm

版权

oracle 专栏收录该内容

55 篇文章 0 订阅

订阅专栏

所需补丁及高版本opatch

image上传后将p6880880_112000_Linux-x86-64.zip解压覆盖$ORACLE_HOME/OPatch目录即可

[oracle@localhost OPatch]$ ./opatch version

OPatch Version: 11.2.0.3.16

OPatch succeeded.

检查环境是否需要打补丁，opatch版本安装环境可以看mos和readme 查看组件信息

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

查看补丁情况

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

查看无效对象

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

COUNT(*)

----------

0

测试兼容性，如果之前没打过，这步可以忽略

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

Oracle Interim Patch Installer version 11.2.0.3.16

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`

停库

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

Database closed.

Database dismounted.

ORACLE instance shut down.

13:11:28 SYS@std>

停止监听

[oracle@localhost OPatch]$ lsnrctl stop

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

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

The command completed successfully

[oracle@localhost OPatch]$

查看是否停干净

[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]$

正式打补丁

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

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.