- 最后登录
- 2015-5-24
- 在线时间
- 74 小时
- 威望
- 54
- 金钱
- 466
- 注册时间
- 2012-2-23
- 阅读权限
- 50
- 帖子
- 73
- 精华
- 0
- 积分
- 54
- UID
- 256
|
1#
发表于 2012-5-12 11:40:09
|
查看: 4245 |
回复: 1
我先装了10.2.0.1的数据库,然后升级到10.2.0.5,现在数据库一切正常后,为数据库打上Patch 13343471报错。
COMP_ID COMP_NAME VERSION STATUS
--------------- ------------------------------ --------------- -----------
EM Oracle Enterprise Manager 10.2.0.5.0 VALID
SDO Spatial 10.2.0.5.0 VALID
ORDIM Oracle interMedia 10.2.0.5.0 VALID
AMD OLAP Catalog 10.2.0.5.0 VALID
XDB Oracle XML Database 10.2.0.5.0 VALID
CONTEXT Oracle Text 10.2.0.5.0 VALID
EXF Oracle Expression Filter 10.2.0.5.0 VALID
RUL Oracle Rule Manager 10.2.0.5.0 VALID
OWM Oracle Workspace Manager 10.2.0.5.0 VALID
ODM Oracle Data Mining 10.2.0.5.0 VALID
CATALOG Oracle Database Catalog Views 10.2.0.5.0 VALID
COMP_ID COMP_NAME VERSION STATUS
--------------- ------------------------------ --------------- -----------
CATPROC Oracle Database Packages and T 10.2.0.5.0 VALID
ypes
JAVAVM JServer JAVA Virtual Machine 10.2.0.5.0 VALID
XML Oracle XDK 10.2.0.5.0 VALID
CATJAVA Oracle Database Java Packages 10.2.0.5.0 VALID
APS OLAP Analytic Workspace 10.2.0.5.0 VALID
XOQ Oracle OLAP API 10.2.0.5.0 VALID
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - Prod
PL/SQL Release 10.2.0.5.0 - Production
CORE 10.2.0.5.0 Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
检查通过
[oracle@dba 13343471]$ opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir ../13343471
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/oracle/product/10.2.0
Central Inventory : /u01/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /u01/oracle/product/10.2.0/oui
Log file location : /u01/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-05-12_11-35-56AM.log
Patch history file: /u01/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
但是一打补丁就报错,什么情况?
[oracle@dba 13343471]$ opatch apply
Invoking OPatch 10.2.0.5.1
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation. All rights reserved.
Oracle Home : /u01/oracle/product/10.2.0
Central Inventory : /u01/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.5.1
OUI version : 10.2.0.5.0
OUI location : /u01/oracle/product/10.2.0/oui
Log file location : /u01/oracle/product/10.2.0/cfgtoollogs/opatch/opatch2012-05-12_11-36-25AM.log
Patch history file: /u01/oracle/product/10.2.0/cfgtoollogs/opatch/opatch_history.txt
ApplySession applying interim patch '13343471' to OH '/u01/oracle/product/10.2.0'
Running prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:
Following executables are active :
/u01/oracle/product/10.2.0/bin/oracle
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system
OPatch failed with error code 74
我升级到10.2.0.5是直接覆盖到$ORACLE_HOME的。 |
|