solaris X86-64下一个ORACLE战斗11.2.0.3.8补丁:
正确的步骤:
1.BUG6880880 。OPATCH补丁
2.BUG16902043。11.2.0.3.8补丁
情感是练啊观看easy一波三折的事情--图像OPATCH的版本号问题在安装11.2.0.3.8补丁前有提示的。要细心唉。
MOS还是非常好用的哈哈。
安装过程:
1.环境检查
-bash-3.2$ ls
16902043 alert_byssolaris.log
Desktop p16902043_112030_Solaris86-64.zip
Documents u01
-bash-3.2$ cd 16902043/
-bash-3.2$ ls
13343438 13923374 14727310 16619892 README.html patchmd.xml
13696216 14275605 16056266 16902043 README.txt
-bash-3.2$ ./opatch lsinventory Cdetail
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
Central Inventory : /export/home/oracle/u01/app/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-18-52PM.log
Lsinventory Output file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-05-13_16-18-52PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
-bash-3.2$ ls
16902043 alert_byssolaris.log
Desktop p16902043_112030_Solaris86-64.zip
Documents u01
###########
-bash-3.2$ cd 16902043/
-bash-3.2$ pwd
/export/home/oracle/16902043/16902043
-bash-3.2$ opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
Central Inventory : /export/home/oracle/u01/app/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-21-21PM.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
#####################################################
2.開始安装
-bash-3.2$ cd ..
-bash-3.2$ pwd
/export/home/oracle/16902043
-bash-3.2$ ls
13343438 13923374 14727310 16619892 README.html patchmd.xml
13696216 14275605 16056266 16902043 README.txt
-bash-3.2$ opatch apply
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1
Central Inventory : /export/home/oracle/u01/app/oraInventory
from : /var/opt/oracle/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-27-02PM.log
Verifying environment and performing prerequisite checks...
UtilSession failed:
Patch 13696216 requires OPatch version 11.2.0.3.0.
Patch 13923374 requires OPatch version 11.2.0.3.0.
Patch 14275605 requires OPatch version 11.2.0.3.0.
Patch 14727310 requires OPatch version 11.2.0.3.0.
Patch 16056266 requires OPatch version 11.2.0.3.0.
Patch 16619892 requires OPatch version 11.2.0.3.0.
Patch 16902043 requires OPatch version 11.2.0.3.0.
The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es). Please download latest OPatch from My Oracle Support.
Log file location: /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_16-27-02PM.log
OPatch failed with error code 73
从提示中能够看到:The OPatch version being used (11.2.0.1.7) doesn't meet the minimum version required by the patch(es)
是OPATCH版本号低。
OPatch - Where Can I Find the Latest Version of OPatch?
[Video] (文档 ID 224346.1)
文档最后找到:
For Oracle11g Release 2 (11.2.0.x),
select release "11.2.0.0.0" (description "OPatch 11.2") and download
p6880880_112000_platform.zip
As of December 2013 the OPatch release is 11.2.0.3.6
####下载补丁p6880880_112000_platform.zip -----事实上这个在PSU的README的最開始就有:
2.1 OPatch Utility
You must use the OPatch utility version 11.2.0.3.0 or later to apply this patch. Oracle recommends that you use the latest released OPatch version for 11.2, which is available for download from My Oracle Support patch
6880880 by selecting the 11.2.0.0.0 release.
For information about OPatch documentation, including any known issues, see My Oracle Support Document cmd=show&type=NOT&id=293369.1">
293369.1
3.安装OPATCH
在ORACLE_HOME下备份OPATCH文件夹:
-bash-3.2$ tar -cvf opatch.tar OPatch/
解压p6880880_112000_platform.zip,将ORACLE_HOME下备份OPATCH文件夹文件删除,再移动解压文件夹。
-bash-3.2$ mv OPatch/ /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/
-bash-3.2$ opatch -help
查看是否可用。
###############################
4.再次打补丁(数据库关闭、监听关闭、DBCONSOLE关闭) :
-bash-3.2$ opatch apply
日志中有warnings:
-bash-3.2$ tail /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_18-29-20PM_1.log
[May 13, 2014 6:52:15 PM] 1) OUI-67215:
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:
ld: warning: option -YP appears more than once, first setting taken
ld: warning: option -Q appears more than once, first setting taken
[May 13, 2014 6:52:15 PM] --------------------------------------------------------------------------------
[May 13, 2014 6:52:15 PM] OUI-67008:OPatch Session completed with warnings.
[May 13, 2014 6:52:15 PM] Finishing UtilSession at Tue May 13 18:52:15 CST 2014
[May 13, 2014 6:52:15 PM] Log file location: /export/home/oracle/u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2014-05-13_18-29-20PM_1.log
从MOS上查询此报错:
Opatch Warning During Patch Apply : "ld: warning: option -YP appears more than once, first setting taken" (文档 ID 1571550.1)
能够忽略:
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.3 to 11.2.0.4 [Release 11.2]
Oracle Solaris on SPARC (64-bit)
Oracle Solaris on x86-64 (64-bit)
Cause
Make warnings caused due to Options for ld command appears more than once.
Solution
These warnings are safely ignorable.
----到目前为止安装。
版权声明:本文博客原创文章,博客,未经同意,不得转载。
solaris X86-64下一个ORACLE战斗11.2.0.3.8在一波折叠补丁的更多相关文章
-
oracle 11.2.0.4单实例文件系统安装与补丁
[TOC] 一,预安装处理 1.版本准备 操作系统:RHEL 6.5 数据库版本:Oracle 11.2.0.4 相关包:p13390677_112040_Linux-x86-64_1of7.zip ...
-
ORACLE RAC 11.2.0.4 CentOS release 6.9 静默安装1.0版本
RAC11.2.0.4静默安装 1.0版本,20180613 #本文档IP地址使用X隐藏,个人可按照自己的当前环境IP进行适当修改 1. 清除原环境中的单实例软件 #清除原环境: 删除/etc/ora ...
-
Ubuntu14.04搭建Oracle instantClient 11.2.0.4并配置cx_Oracle5.1.2
一.配置Oracle instantClient 11.2.0.4 1.下载Oracle客户端: 打开http://www.oracle.com/technetwork/topics/linuxx86 ...
-
csharp: ODP.NET,System.Data.OracleClient(.net 4.0) and System.Data.OleDb读取Oracle g 11.2.0的区别
ODP.NET: 引用: using Oracle.DataAccess; //Oracle g 11.2.0 using Oracle.DataAccess.Client; using Oracle ...
-
Oracle安装11.2.0.4.180116补丁及如何检查数据库安装补丁
最近做了一个安装11.2.0.4.180116补丁的实验,突然想起之前和同事讨论的一个问题:如何检查数据库安装补丁的版本,之前搜到的是去查dba_registry_history,有的说在操作系统中执 ...
-
oracle之 11.2.0.4 bbed安装
一. bbed安装: 1.ORACLE 11G下安装BBED,需要从ORACLE 10G中复制三个包 sbbdpt.o .ssbbded.o 并将两个文件移到$ORACLE_HOME/rdbms/li ...
-
单机 Oracle 11g(11.2.0.4)手动打补丁PSU(11.2.0.4.8)
环境说明:database : 11.2.0.4 x64os: centos6.7 x64 准备内容:OPatch : p6880880_112000_Linux-x86-64.zipDB PSU : ...
-
【ERROR】while loading shared libraries: /u01/app/oracle/product/11.2.0/lib/libclntsh.so.11.1: cannot
问题: [oracle@mydb]$ lsnrctl status lsnrctl: error while loading shared libraries: /u01/app/oracle/pro ...
-
当有多于64合乎逻辑的cpu时刻,Windows 下一个Oracle db 实例启动(startup)什么时候会hang(待定)
Bug 9772171 - Database startup hangs on Windows when machine has more than 64 cores [ID 9772171.8] 该 ...
随机推荐
-
Linux查看物理CPU个数、核数、逻辑CPU个数
# 总核数 = 物理CPU个数 X 每颗物理CPU的核数 # 总逻辑CPU数 = 物理CPU个数 X 每颗物理CPU的核数 X 超线程数 # 查看物理CPU个数 cat /proc/cpuinfo| ...
-
C# Winform中无焦点状态下获取键盘输入或者USB扫描枪数据
类文件: C#类文件 using System; using System.Collections.Generic; using System.Text; using System.Runtime.I ...
-
SQL Saturday活动再起
SQL Saturday活动再起 时间:2015年05月09日(星期六) 地点:上海徐汇区港汇2座10楼(10.073) 我们相约港汇2座10楼(10.073),SQL PASS上海分会的SQLSat ...
-
使用springMVC实现文件上传和下载之文件下载
接上一篇,文件下载需要获取下载文件的存储路径,这里只是手动填入,如果是在具体项目中,可以把文件名和上传后的存储路径保存在数据库中.然后增加一个文件列表的页面展示文件名和文件路径,然后点击下载的时候把相 ...
-
Android开发问题笔记
1.Toolbar问题:最低版本15,必须使用support,才能使用Toolbar,Toobar是5.0引入的 2.BottomTab:这个用TabLayout解决了 3.后端API最好采用一个成熟 ...
-
input placeholder文字垂直居中(Mobile &; PC)
Html5输入框支持placeholder,但是在定义文本框中定义placeholder存在兼容问题 <input type="text" placeholder=" ...
-
关于MultipleActiveResultSets属性导致的There is already an open DataReader associated with this Command which must be closed first的解决方法
执行SqlDataReader.Read之后,如果还想用另一个SqlCommand执行Insert或者Update操作的话,会得到一个错误提示:There is already an open Dat ...
-
简单认识python(一)
最近本宝宝被一部小说迷的神魂颠倒的,在网络上四处找免费的小说资源,一直哭唧唧的等待着每天更新的一章.实在是太可怜了,本宝宝决定自己学python,自己抓包小说. 既然知道目的地了,那就和本宝宝一起打怪 ...
-
51NOD-1486 大大走格子
有一个h行w列的棋盘,里面有一些格子是不能走的,现在要求从左上角走到右下角的方案数. Input 单组测试数据. 第一行有三个整数h, w, n(1 ≤ h, w ≤ 10^5, 1 ≤ n ≤ 20 ...
-
codeforces547a
http://codeforces.com/contest/547/problem/A 题意:确定是否在某一时刻高度都同时为a1和a2. step1:找到青蛙首次到a1的时间pri1以及重复到a1的周 ...