DBA in the Trenches

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 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]';