Mount old file system in new server so that you can copy the files over. Replace $[OLD_APPLCSF] ,$[NEW_APPLCSF] and [PROD] with your local settings
Need to update the concurrent request table that stores the log file and out file locations
For Bi Publisher there is also the additional file that is created and this needs to be updated in FND_CONC_REQ_OUTPUTS. Sneaky one that I later found.
rsync -a $[OLD_APPLCSF]/log/ $[NEW_APPLCSF]/log/
rsync -a $[OLD_APPLCSF]/out/ $[NEW_APPLCSF]/out/
Need to update the concurrent request table that stores the log file and out file locations
update APPLSYS.FND_CONCURRENT_REQUESTS fcr
set fcr.LOGFILE_NAME = replace (FILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]')
,fcr.LOGFILE_NODE_NAME= '[PROD]'
,fcr.OUTFILE_NAME = replace (OUTFILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]')
,fcr.outFILE_NODE_NAME= '[PROD]';
For Bi Publisher there is also the additional file that is created and this needs to be updated in FND_CONC_REQ_OUTPUTS. Sneaky one that I later found.
update APPLSYS.FND_CONC_REQ_OUTPUTS
set FILE_NAME = replace (FILE_NAME,'$[OLD_APPLCSF]','$[NEW_APPLCSF]')
,FILE_NODE_NAME = '[PROD]';
Comments
Post a Comment