I need to understand the proper method of customizing $ORACLE_HOME/appsutil/template files used by a
APPS 12.2.5 AD/TXK10
DB 12.1.0.2.0 April 2018 PSU
We recently upgraded our AD/TXK from delta 7 to delta 10. Now I cannot run adcfgclone dbtier without erroring out due to control file parameter locations that differ from where the control file reside on the filesystem.
I recall that in AD/TXK7, in order for cloning to work properly, I had to hard-code my control file paths into an instantiation file $ORACLE_HOME/appsutil/template/afinit_db121.ora. It was a band-aid approach but it solved the problem. The change I made was to "un-variableize" the statement below, because otherwise adcfgclone would set the control_files parameter to invalid locations and the adcfgclone process bombed.