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

2016-12-22 10:50 abce 阅读(674) 评论(0) 编辑收藏举报

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  apps/****@adgrants.sql APPS
 
SQL*Plus: Release 11.2.0.3.0 Production on Thu Dec 22 10:32:04 2016
 
Copyright (c) 1982, 2011, Oracle.  All rights reserved.
 
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
 
Connected.
..
.
..
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.