Sphincter said what?
I was doing some core ETCC database patching against a 12.2 DEV instance today. I was hoping to get to AD/TXK Delta 7 and see how that worked. But after a big opatch session, when I restarted services, adop phase=prepare threw this error:
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.
The Fix
On the database tier, go to $ORACLE_HOME/appsutil/admin and re-run adgrants, then recompile the package:
sqlplus / as sysdba
@adgrants apps
alter package apps.AD_ZD_ADOP compile body;
After this, adop phase=prepare ran happily enough, and included an explicit autoconfig. I can’t promise this will work for you, but since the error message is rather vague and unhelpful I thought I’d post this.