Enable AutoConfig on DB node post out of place DB upgrade


When we upgrade database and it has to be an out of place upgrade, then the existing autoconfig setup becomes void (as it uses old o$ORACLE_HOME). In this case we need to enable autoconfig on new DB OH

As applmgr (application owner)
Source RUN FS

perl $AD_TOP/bin/admkappsutil.pl

This will create appsutil.zip in $APPL_TOP\admin\out
copy the appsutil.zip to $ORACLE_HOME

As oracle (database owner)

cd $ORACLE_HOME
unzip appsutil.zip
cd appsutil/bin

Below command will create the context file.

perl adbldxml.pl appsuser=apps appspasswd=apps jtop=/u01/app/oracle/VIS/fs1/EBSapps/comn/util/jdk64

Run adconfig to create scripts/<context_name> folder and others.

cd $ORACLE_HOME/appsutil/bin
sh adconfig.sh contextfile=/u01/db/oracle/VIS/ora11204/appsutil/VIS_ebs122.xml appspass=apps

Verify the AutoConfig log file

Now if you check in $ORACLE_HOME/appsutil/bin, you will see that it has now created more folders that it was present before.

Before

After

 

Finally, you can now run autoconfig

 

Leave a comment

Your email address will not be published. Required fields are marked *