Monday, December 04, 2006

Messed up with AutoConfig !!!

Autoconfig messed up what to do?

after you changed your current xml file (context file) of courser without taking backup and then after you had run adautocfg.sh you find out that you messed every thing up, and you need to go back to the previous status but you don’t have backup of your xml file so what can you do?.

-Fist of all before editing the xml file always take backup.
-If you want to do changes on your xml file try to do it using OAM (Oracle applications manger) Site Map->System Configuration ->Autoconfig. OAM backup your xml by default. And it also allows you to see the history of your xml files and what compare between current xml and the one in history.
-Incase you don’t have backup and you messed every thing up you can do the following.

When you run adautocfg.sh it takes backup under the following directory
-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/out/MMDDhhmm for the database tire.
-$APPL_TOP/admin/$CONTEXT_NAME/out/MMDDhhmm for the applications tire.
* Where MM is the month, DD is the day, hh is the hour, and mm is the minute when adconfig.sh was executed.

All what you have to do is to go to this directories and run a script called restore.sh

Nice thing you can do before you run adautocfg.sh is to run adchkcfg.sh script. This script
generates an HTML file named cfgcheck.html that displays the differences
in the configurations. The file will be located under
-$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/out/MMDDhhmm on the database tire.
-$APPL_TOP/admin/$CONTEXT_NAME/out/MMDDhhmm on the application tire.

Please leave a comment if this post was helpful or not and thank you for taking time to read my posts

And always keep in mind
Oracle is not Magic, it just takes years of experience ;-)

8 comments:

Anonymous said...

>Nice thing you can do before you run adautocfg.sh is to run adchkcfg.sh

I quite agree with this ;)

Sam
http://www.appsdbablog.com

fhasweh said...

i think all the apps dba's should agree with that my friend.
;-)

fadi

Anonymous said...

Luckily i did not have to run restore.sh ever but for my own understanding, does the restore.sh restores the previous value of the profile options too? I hope it does.

fhasweh said...

sorry Arun,
but no it dosenot it just restor the old templet files befoer the last run of autoconfig.

hope you will never need it ;-)

fadi

KrishnaKari said...

Hi Fadi,
Nice to know this information about restore.sh script. Its quite common that after running autoconfig we lose the customization configurations and the system starts behaving erratically. Instead of taking time to debug the information we can run restore.sh script to getback to the previous state in few mins.
This feature will be quite useful and helpful.

Regards,
Kari

http://oracleapplicationsdba.blogspot.com/

OraDetector said...

by the way the script
its under $AD_TOP/bin

Regards,

fhasweh said...

thanks samer
fadi

Anonymous said...

Might be a bit late to add comments but something to keep in mind. If you haven't set your templates properly, certain values e.g. icx session timeout will be set to their default value. Running restore.sh will not set this back to its previous value.