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 

No comments: