R12.2 Apps DBA. Powered by Blogger.

While cleaning FND_NODES on R12.2

No comments :
faced issue while running
adop phase=fs_clone
It failed at txkValidation script . In the logs it was showing
ERROR:
Nodes with context files in the FND_OAM_CONTEXT_FILES table on both run and patch file systems: NONE
Nodes without context files in the FND_OAM_CONTEXT_FILES table on either/or run and patch file systems: oraprod1
I queried FND_OAM_CONTEXT_FILES and it showed entries for
Database Contextfile , FS1 Context file bit not for FS2.
SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;
to cleanup the non-existent nodes and run autoconfig. But Autoconfig will update the entries of the context file from where it is ran. In R12.2 there is dual file system so we never ran autoconfig on FS2 filesystem so there was no entry.
Solution:
If the patch file system data (managed servers or context file) is missing from the database then run the following after sourcing the run file system environment.
This command is executed on the RUN file system to upload the PATCH context file:
$ADJVAPRG oracle.apps.ad.autoconfig.oam.CtxSynchronizer action=upload contextfile=<full path to patch context file> logfile=/tmp/patch.log
If the run file system data is missing from the database simply source the run file system environment and run autoconfig and entries will be populated.
After this I can see entries of FS2 filesystem in FND_OAM_CONTEXT_FILES.
Then ran adop phase=fs_clone and it ran successfully.

No comments :

Post a Comment

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