adop phase=prepare error
[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
(1988581.1): “Nodes “-1″ are listed in ADOP_VALID_NODES table but not in FND_NODES table.”,
but it didn’t fix the issue.
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 worked and included an explicit autoconfig.
Subscribe to:
Post Comments
(
Atom
)
No comments :
Post a Comment
Note: only a member of this blog may post a comment.