Monday, October 14, 2019

Nodes x are listed in the ADOP_VALID_NODES table but not in the FND_NODES table

When running adop phase=prepare, this error is shown:
[UNEXPECTED]Nodes “xxxxxx” are listed in the ADOP_VALID_NODES table but not in the FND_NODES table.

This is how to fix it:

  1. Logon to sqlplus as applsys: sqlplus applsys
  2. On sqlplus:
    1. truncate table fnd_oam_context_files;
    2. truncate table fnd_nodes;
    3. truncate table adop_valid_nodes;
  3. Run autoConfig on the DB tier
  4. Run autoconfig on the run file system
  5. Logon to sqlplus as system: alter trigger ebs_logon disable;
  6. Run Autoconfig on the patch file system
  7. Logon to sqlplus as system: alter trigger ebs_logon disable;


No comments: