R12.2 Apps DBA. Powered by Blogger.

R12.2 Duplicate entries exists in FND_OAM_CONTEXT_FILES Tables in Apps Database.

No comments :
The error message from the discovery process shows this is the cause of the issue as we can see in the message extracted from the log file:
Caused by: oracle.apps.fnd.oam.em.sdk.targetData.discovery.AppsDiscoveryException: Duplicate entries exists in FND_OAM_CONTEXT_FILES Tables in Apps Database.
Please clean the table before running Discovery again.
Solution
1. Backup the fnd_oam_context_files table :
sqlplus applsys/pwd
create table fnd_oam_context_files_bkp as select * from fnd_oam_context_files;
2. truncate table fnd_oam_context_files;
3. Run autoconfig in the DB tiers to populate fnd_oam_context_files table with the database information;
4. Run autoconfig in each Apps tier to populate fnd_oam_context_files with the application tier information;
5. From the EBS agent home, run:
./emctl upload
This will upload the information from the EBS system to Grid Control
6. Re-run the Discovery process.

No comments :

Post a Comment

Note: only a member of this blog may post a comment.