Friday, August 28, 2009

Recreate XML file in DB node

1. Bring Down Instance.

2. Startup Database Services.

3.On DB goto $ORACLE_HOME/appsutil/bin

and do:- perl adbldxml.pl tier=db appsuser= appspasswd=

4. Run AutoConfig to populate the context into the database

5. As needed, execute the following in SQL*Plus to determine if the context is populated in the
database:

select name, path, CTX_TYPE from FND_OAM_CONTEXT_FILES
where status != 'H'
and name not in ('METADATA', 'TEMPLATE')
and CTX_TYPE = 'D' ;

6. Startup Application Services .


and if you found that appsutil directry is not there in $ORACLE_HOME

then you need to add following steps to create that


Goto $AD_TOP/bin and run

perl admkappsutil.pl

it will create appsutil.zip in $APPL_TOP/admin/out

copy that to $ORACLE_HOME (DB Tier) and

unzip -o appsutil.zip

and then proceed from step 3