Nodes “-1” are listed in ADOP_VALID_NODES table but not in FND_NODES table

发布时间:2017-2-22 21:22:36 编辑:www.fx114.net 分享查询网我要评论
本篇文章主要介绍了"Nodes “-1” are listed in ADOP_VALID_NODES table but not in FND_NODES table ",主要涉及到Nodes “-1” are listed in ADOP_VALID_NODES table but not in FND_NODES table 方面的内容,对于Nodes “-1” are listed in ADOP_VALID_NODES table but not in FND_NODES table 感兴趣的同学可以参考一下。

While trying to apply patches to upgrade to 12.2.4, adop failed due to the below errors.

Validating system setup...    [ERROR]     Failed to execute SQL statement : select AD_ZD_ADOP.GET_INVALID_NODES() from dual    [ERROR]     Error Message :     [ERROR]     Failed to execute SQL statement : select AD_ZD_ADOP.GET_INVALID_NODES() from dual    [ERROR]     Error Message :     [UNEXPECTED]Nodes "-1" are listed in ADOP_VALID_NODES table but not in FND_NODES table.    [UNEXPECTED]To correct this, run AutoConfig on nodes "-1"    [UNEXPECTED]Error while checking if this is a multi node instance

  

MOS had a direct hit on this (1988581.1):  “Nodes “-1″ are listed in ADOP_VALID_NODES table but not in FND_NODES table.”, but it didn’t fix the issue.  In fact in accordance with this note I was fine.

FIX:

$ sqlplus  [email protected] APPSSQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 22 10:32:04 2016Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected to:Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsConnected......End of Creating PL/SQL Package AD_ZD_SYS.Start of giving grants. This may take few minutes.PL/SQL procedure successfully completed.Start of PURGE DBA_RECYCLEBIN.PL/SQL procedure successfully completed.End of PURGE DBA_RECYCLEBIN.Commit complete.SQL> alter package apps.AD_ZD_ADOP compile body;Package body altered.

上一篇:CAS实现SSO单点登录原理
下一篇:附录E 安装Kafka

相关文章

相关评论