ORACLE查看补丁出现“OPatch failed with error code 1”
案例场景:
在Oracle Linux Server release 5.7上安装完ORACLE 10g后,顺便将PSR(Patch Set Release)p6810189_10204_Linux-x86-64.zip也安装了。结果在查看补丁时出现了下面情况
[oracle@DB-Server OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.4.2
Oracle Home Path specified is relative path.
OPatch cannot work with relative Oracle Home Paths, please specify the absolute path to Oracle Home.
OPatch failed with error code 1
问题分析:
出现这个问题是因为环境变量ORACLE_HOME(在.bash_profile配置文件里面设置)使用了相对路径缘故。如下所示:
将环境变量ORACLE_HOME改为ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1;export ORACLE_HOME后,使用source .bash_profile使之生效。问题即可解决。
[oracle@DB-Server OPatch]$ ./opatch lsinventory
Invoking OPatch 10.2.0.4.2
Oracle Interim Patch Installer version 10.2.0.4.2
Copyright (c) 2007, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
from : /etc/oraInst.loc
OPatch version : 10.2.0.4.2
OUI version : 10.2.0.4.0
OUI location : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2014-04-11_14-38-44PM.log
Lsinventory Output file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/lsinv/lsinventory2014-04-11_14-38-44PM.txt
--------------------------------------------------------------------------------
Installed Top-level Products (2):
Oracle Database 10g 10.2.0.1.0
Oracle Database 10g Release 2 Patch Set 3 10.2.0.4.0
There are 2 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
--------------------------------------------------------------------------------
OPatch succeeded.
潇湘隐者 网名潇湘隐者/潇湘剑客、英文名Kerry,兴趣广泛,广泛涉猎,个性随意,不善言辞。执意做一名会写代码的DBA,混迹于IT行业
相关文章
- ORA-27167: Attempt to determine if Oracle binary image is stored on remote server failed ORACLE 报错 故障修复 远程处理
- ORA-27369: job of type EXECUTABLE failed with exit code: string ORACLE 报错 故障修复 远程处理
- ORA-27601: Cell storage initialization failed, cell library error code [string] ORACLE 报错 故障修复 远程处理
- ORA-27609: Smart I/O failed due to a network error to the cell “string”. error code “string”, “string” ORACLE 报错 故障修复 远程处理
- ORA-00038: Cannot create session: server group belongs to another user ORACLE 报错 故障修复 远程处理
- ORA-03149: Invalid Oracle error code ORACLE 报错 故障修复 远程处理
- ORA-06780: TLI Driver: recv error code failed ORACLE 报错 故障修复 远程处理
- Oracle 视图 DBA_HIST_IC_DEVICE_STATS 官方解释,作用,如何使用详细说明
- acle索引使用指南Oracle索引:提升查询速度的实用技巧(oracle索引or)
- Oracle查询利器:为您优化查询体验!(oracle查询工具)
- Oracle数据库实战:精湛的技巧(oracle技巧)
- Oracle索引失效: 找到原因与解决方案(oracle索引失效)
- 探索Oracle数据库之旅:关键字分析(oracle的关键字)
- 了解Oracle数据库表名的最大长度限制(oracle表名最大长度)
- Oracle自动排序:智能化工具让记录无比有序(oracle自动排序)
- Exploring the Roots of Oracle: Understanding the Importance of the Root Node(oracle根节点)
- Oracle 中的 WITH 语句使用技巧(oracle with用法)
- Oracle汉字转换拼音实用技巧(oracle汉字拼音)
- 实时同步Oracle全库高效安全的解决之道(oracle全库实时同步)
- Oracle数据库中使用浮点数存储实现(oracle写浮点数)
- 优雅地使用Oracle写出语句(oracle写或者语句)
- 基于JSP快速查询Oracle数据库(jsp查询oracle)
- Oracle迎接新的一年(oracle 今年第一天)
- Oracle数据库中优化主键推荐策略(oracle主键推荐策略)
- 拆解Oracle数据库中的拉链表(oracle中的拉链表)
- code探索Oracle中的Unicode编码实现(oracle中的uni)
- ORACLE文档下载安全可靠的加密保护(ORACLE下载文档加密)