Monday, February 6, 2012

Migrate Custom Top file system from 11i to R12 after upgrade

Hi All


Here the way to migrate Custom Top file system from 11i to R12 after the upgrade.


1.  Copy the files from 11i to R12
  a. cp -r  <11i APPL_TOP>/xxcust  <R12 APPL_TOP>
  b. cd <R12 APPL_TOP>/cust
  c. mv 11.5.0 12.0.0
  d. If there are forms in your custom top, go to <R12 APPL_TOP>/cust/12.0.0/forms/US
      Remove all fmx files and recompile all fmb again.
      frmcmp_batch module=<path to the fmb file> userid=apps/<apps pwd> output_file=<path to the fmx file> compile_all=special batch=yes
      Check the compilation logs for errors.


2. Add the Custom Top to $CONTEXT_FILE
  a. vi $CONTEXT_FILE
  b. Look for AU_TOP and go to the end of list for all TOP's
  c. Add your Custom top to the list as in example:
<XXCUST_TOP oa_var="s_xxcusttop" oa_type="PROD_TOP" oa_enabled="FALSE"><APPL_TOP full path>/xxcust/12.0.0</XXCUST_TOP>


3. Update FORMS_PATH in $CONTEXT_FILE
  a. vi $CONTEXT_FILE
  b. Look for <FORMS_PATH oa_var
  c. Add $AU_TOP/forms/US in the end of string ($AU_TOP - full path)


4. Run Autoconfig in Application Tier
  $INST_TOP/admin/scripts/adautocfg.sh


5. Re-login to Linux Server as applmgr user
6. Start Application Instance using  adstrtal.sh


Good Luck ...

3 comments:

  1. Good one. Just add the step to modify "$ORA_CONFIG_HOME/10.1.2/forms/server/default.env " and add custom in that as well.

    ReplyDelete
  2. Hi Rahul. no need to modify the default.env file. it will be updated atomatically after autoconfig :-)

    ReplyDelete
  3. Very helpful.. Thank you.

    ReplyDelete