Errors on ADOP at APPLY phase
Error:
1) All workers are failed with the Java error..
2) Invalid objects count is increased to 56k.
Troubleshooting:
1) Cleared the invalid objects by using utlrp.sql
2) Run the auto config on DB node
3) Start the patching activity again.
In step (3) while running auto config in database node exists with the below error.
ORA-01400: cannot insert NULL into ("APPLSYS"."FND_NODES"."NODE_NAME")
Adop error message:
ERRORMSG: Cannot identify any valid application tier nodes in ADOP_VALID_NODES table. Ensure AutoConfig has been run on all nodes.
To resolve this error need to follow the below steps:
Step 1:
drop synonym apps.fnd_nodes;
create synonym apps.fnd_nodes for applsys.fnd_nodes;
drop synonym apps.fnd_oam_context_files;
create synonym apps.fnd_oam_context_files for applsys.fnd_oam_context_files;
Step 2:
Change the worker status to restart using adcrtl utility.
Step 3:
Run auto config again in database node. (Auto config completed without any errors)
Step 4:
Restart the patching activity.
adop phase=apply apply_mode=downtime patches=24690690 abandon=no restart=yes workers=16
No comments:
Post a Comment