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 Linux Server release 5.7上安装完ORACLE 10g后,顺便将PSR(Patch Set Releasep6810189_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

clip_image001

问题分析:

出现这个问题是因为环境变量ORACLE_HOME(在.bash_profile配置文件里面设置)使用了相对路径缘故。如下所示:

clip_image002

将环境变量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.

相关文章
|
3月前
|
SQL Oracle 关系型数据库
Oracle 11g 打PSU补丁教程
Oracle 11g 打PSU补丁教程
113 2
|
3月前
|
Oracle 关系型数据库
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
Navicat 连接Oracle ORA-28547: connection to server failed, probable Oracle Net admin error
112 0
|
6月前
|
SQL Oracle Unix
Oracle sqlplus failed on AIX platform(/usr/lib/lib
Oracle sqlplus failed on AIX platform(/usr/lib/lib
35 1
|
6月前
|
存储 NoSQL 关系型数据库
实时计算 Flink版操作报错之抽取Oracle11g时,报错: "Retrieve schema history failed, the schema records for engine ... has been removed",怎么处理
在使用实时计算Flink版过程中,可能会遇到各种错误,了解这些错误的原因及解决方法对于高效排错至关重要。针对具体问题,查看Flink的日志是关键,它们通常会提供更详细的错误信息和堆栈跟踪,有助于定位问题。此外,Flink社区文档和官方论坛也是寻求帮助的好去处。以下是一些常见的操作报错及其可能的原因与解决策略。
|
6月前
|
Oracle 关系型数据库
oracle rac 手工安装补丁,不适用auto
oracle rac 手工安装补丁,不适用auto
74 3
|
SQL Oracle 关系型数据库
Oracle 19c 补丁升级引发的单表恢复失败谜案
问题表现 某客户在恢复 Oracle 数据库的单表时,提示类似下面的信息
133 0
|
SQL Oracle 关系型数据库
|
SQL Oracle 关系型数据库
Oracle Error code
Oracle Error code
144 0
|
Oracle 关系型数据库
Oracle数据泵导出导入报错stopped due to fatal error
Oracle数据泵导出导入报错stopped due to fatal error
753 0