Friday, November 13, 2009

Steps to recovery or recreate applications context file if it is corrupted or deleted accidentally

Here are the options to recover or recreate applications (db) contextfile

1. download from database
The contextfiles are saved into a database table: FND_OAM_CONTEXT_FILES. In case the contextfile in the file system is corrupted or lost, login to OAM->Site Map->Administration->System Configuration->AutoConfig->View. Will prompt to open or save it.

For EBS Rel 12, you can user adclonectx.pl retrieve to download the contextfile from database. See Appendix 3.

2. use adbldxml.pl to rebuild contextfile see appendix 1.

3. copy a contextfile from other instance and run adclonectx.pl to create a new contextfile. See appendix 2.

APPENDIX
A1. cd $AD_TOP/bin, then perl adbldxml.pl -help

A2. cd $COMMON_TOP/clone/bin; then perl adclonectx.pl help

A3. Using AutoConfig to Manage System Configurations in Oracle E-Business Suite Release 12 [ID 387859.1]

4) How do I recover the Applications context file if it is lost or deleted accidentally?
Answer:The Applications context file can be retrieved by running the adclonectx.pl script.
To retrieve the applications tier context file,
Execute the following command on the applications tier.
perl /clone/bin/adclonectx.pl retrieve
On being prompted for the context file to be retrieved, select the option of retrieving the applications tier context file that has been lost and retrieve it to the default location specified by the script.
The above command can be used only when the is still intact. In case the has also been lost accidentally, the applications tier context file may be retrieved as follows:
Execute the following command on the database tier:
perl /appsutil/clone/bin/adclonectx.pl retrieve
On being prompted for the context file to be retrieved, select the option of retrieving the applications tier context file that has been lost.
While confirming the location for the context file, set it to any existing directory with write permission.
Once the context file has been generated in the specified location, move it to the location specified for the context file in the context variable 's_contextfile'.
To retrieve the database tier context file,
Execute the following command on the database tier:
perl /appsutil/clone/bin/adclonectx.pl retrieve
On being prompted for the context file to be retrieved, select the database tier context file and retrieve it to the default location specified by the script.

No comments:

Post a Comment