Showing posts with label ORACLE Applications. Show all posts
Showing posts with label ORACLE Applications. Show all posts

Wednesday, April 25, 2012

Database autoconfig in R12


R12 How to update the RDBMS ORACLE_HOME  file system with the AutoConfig files ??
On the Application Tier (as the APPLMGR user):
Source the environment file.
Create the appsutil.zip file by executing:

$ADPERLPRG $AD_TOP/bin/admkappsutil.pl
(On Windows: %ADPERLPRG% %AD_TOP%\bin\admkappsutil.pl)

This will create appsutil.zip under $INST_TOP/admin/out

On the Database Tier (as the ORACLE user):
copy or ftp the appsutil.zip file to the 
cd $ORACLE_HOME
unzip -o appsutil.zip

Restore or create xml file using adbldxml.pl 
cd $ORACLE_HOME
perl adbldxml.pl 
-- Supply appropriate values. 
Run AutoConfig by executing:

/appsutil/scripts//adautocfg.sh

If its RAC and Multinode MTs then autoconfig should be run n+(n-1) times for each tier
Like for a 2 node RAC and 3 node MT 
D1,D2,D1 and then M1,M2,M3,M2,M1