解决：[INS-20802] Oracle Net Configuration Assistant failed

最新推荐文章于 2021-12-24 11:27:04 发布

转载最新推荐文章于 2021-12-24 11:27:04 发布 · 304 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/alsw/p/3511899.html

文章标签：

#数据库

本文提供了解决在Linux环境下安装Oracle11G时遇到的[INS-20802]OracleNetConfigurationAssistantfailed错误的方法，并指导如何正确下载、上传和应用补丁p8670579_112010_LINUX，确保数据库安装顺利进行。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

在linux 中安装Oracle 11G 的时候出现

[INS-20802] Oracle Net Configuration Assistant failed

是oracle数据库的鼓掌，需要下载补丁p8670579_112010_LINUX

解决办法：

1. Oracle帐号操作，上传补丁到/u01下，解压。（在oracle用户可能没权限转移，用root转移）

[oracle@dbserver u01]$ cd 8670579/

[oracle@dbserver 8670579]$ ls
etc files README.txt
2. 打补丁要注意下，选择Optch目录一般在ORACLE_HOME 目录下(下面再次切换oracle用户，免得提示不行)

[oracle@dbserver 8670579]$ $ORACLE_HOME/OPatch/opatch apply -invPtrLoc $ORACLE_HOME/oraInst.loc
Invoking OPatch 11.1.0.6.6

Oracle Interim Patch Installer version 11.1.0.6.6
Copyright (c) 2009, Oracle Corporation. All rights reserved.

Oracle Home       : /u01/app/oracle/product/11.2.0/db_1
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/product/11.2.0/db_1/oraInst.loc
OPatch version    : 11.1.0.6.6
OUI version       : 11.2.0.1.0
OUI location      : /u01/app/oracle/product/11.2.0/db_1/oui
Log file location : /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch2012-08-02_21-22-59PM.log

Patch history file: /u01/app/oracle/product/11.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt

--------------------------------------------------------------------------------
The patch has more than one Archive Action but there is no Make Action.
--------------------------------------------------------------------------------
ApplySession applying interim patch '8670579' to OH '/u01/app/oracle/product/11.2.0/db_1'
Interim patch 8670579 is a superset of the patch(es) [ 8670579 ] in OH /u01/app/oracle/product/11.2.0/db_1
OPatch will rollback the subset patches and apply the given patch.

Running prerequisite checks...
Prerequisite check "CheckActiveFilesAndExecutables" failed.
The details are:

Following executables are active :
/u01/app/oracle/product/11.2.0/db_1/lib/libnnz11.so
ApplySession failed during prerequisite checks: Prerequisite check "CheckActiveFilesAndExecutables" failed.
System intact, OPatch will not attempt to restore the system
--------------------------------------------------------------------------------
The following warnings have occurred during OPatch execution:
1) OUI-67078:Interim patch 8670579 is a superset of the patch(es) [ 8670579 ] in OH /u01/app/oracle/product/11.2.0/db_1
--------------------------------------------------------------------------------

OPatch failed with error code 74