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

时间:2023-12-21 09:31:32

在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
              : 
/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 "CheckActiveFilesAndutables" 
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 "CheckActiveFilesAndutables" 
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

成功安装 ,然后重试