I am attempting to export patch history information from my 11i 11.5.7, Solaris 2.9, rdbms 9.0.2 instance , Using the FNDLOAD utility. The command I am using does not appear to extract any data. Does anyone here use this utility for extracting patch history information for applying to their cloned instances? Would you care to share your command line, or any other ideas you may have?
The underlying issue is my cloned instance(s) do not depict the source instance's patch history. Therefore in order to apply patches(patches with pre-requisites) to my cloned instance(s) for eval, I would need to re-apply each patch ... to each instance!! That would take me right up to retirement!!
My command syntax is
FNDLOAD apps/apps 0 Y DOWNLOAD R11i/ad/11.5.0/patch/115/import/adphst.lct aphst.ldt PATCH_RUN P_LANG=US P_REC_ON_RELEASE=11.5.7 P_APPS_SYS_NAME=DEV P_APPL_TOP_NAME=appldev P_START_DATE=2000/01/01 23:06:24 P_END_DATE=2004/01/05 23:06:00
I am logging this error, But I have not been able to get find a fix for it.
=================STARTUP TIME= 01-JUL-03 15:35:50=================
UNEXPECTED fnd.src.util.aflog.aflogestr.cant_log_to_db: [blank]
ERROR *: Downloading PATCH_RUN to the data file aphst.ldt
the output file "aphst.ldt" ...
FNSDBSL098:applprod:/u02/app/applprod> strings aphst.ldt
LANGUAGE = "US"
LDRCONFIG = "adphst.lct 115.9"
# -- Begin Entity Definitions --
KEY START_DATE VARCHAR2(20)
KEY AT_NM VARCHAR2(50)
KEY AS_NM VARCHAR2(30)
BASE ACTION_TIERLIST_IN_DRIVER VARCHAR2(50)
BASE ACTION_LANG_CODE VARCHAR2(4)
BASE LOADER_DATA_FILE_ID REFERENCES FILE
# -- End Entity Definitions --