Migrating to AutoConfig on the Database Tier

1. Copy AutoConfig to the RDBMS ORACLE_HOME
as the APPLMGR user:
- source the environment file:
. /APPS_MI/visappl/APPSORA.env
- Create appsutil.zip file
perl $AD_TOP/bin/admkappsutil.pl

[applmgr@apps ~]$ perl $AD_TOP/bin/admkappsutil.pl
Starting the generation of appsutil.zip
Log file located at /APPS_MI/visappl/admin/log/MakeAppsUtil_05072343.log
output located at /APPS_MI/visappl/admin/out/appsutil.zip
MakeAppsUtil completed successfully.

- Copy the appsutil.zip to the <RDBMS ORACLE_HOME>
- On the Database Tier (as the ORACLE user):
cd <RDBMS ORACLE_HOME>
unzip -o appsutil.zip
For a database upgrade:
cd /APPS_DB_R12/db/tech_st/10.2.0
unzip -o appsutil.zip

2. Generate your Database Context File
cd <RDBMS ORACLE_HOME>
. <CONTEXT_NAME>.env
cd <RDBMS ORACLE_HOME>/appsutil/bin
perl adbldxml.pl tier=db appsuser=<APPSuser>

For a database upgrade:
cd /APPS_DB_R12/db/tech_st/10.2.0
. VIS_db.env (this file is the one from 9i OHome modified with the new 10g OHome)
cd $ORACLE_HOME/appsutil/bin
perl adbldxml.pl tier=db appsuser=APPS

If the listener.ora is not created in /APPS_DB_R12/db/tech_st/10.2.0/network/admin/VIS_db this will generates an error which can be ignored.
The following context file will be generated:
/APPS_DB_R12/db/tech_st/10.2.0/appsutil/VIS_db.xml

3. Review and Resolve Manual Configuration Changes
cd <RDBMS ORACLE_HOME>/appsutil/bin
adchkcfg.sh contextfile=<CONTEXT>
cd $ORACLE_HOME/appsutil/bin
./adchkcfg.sh contextfile=/APPS_DB_R12/db/tech_st/10.2.0/appsutil/VIS_db.xml
The following report will be generated: /APPS_DB_R12/db/tech_st/10.2.0/appsutil/out/VIS_db/05072108/cfgcheck.html

This report provide information about all file changes, profile option changes and other important database updates that will be done during the next normal execution of AutoConfig

4. Generate and Apply AutoConfig Configuration files

cd <RDBMS ORACLE_HOME>/appsutil/bin
adconfig.sh contextfile=<CONTEXT>

cd $ORACLE_HOME/appsutil/bin

./adconfig.sh contextfile=/APPS_DB_R12/db/tech_st/10.2.0/appsutil/VIS_db.xml

This command creates /APPS_DB_R12/db/tech_st/10.2.0/appsutil/scripts/VIS_db/adautocfg.sh and run it.

/APPS_DB_R12/db/tech_st/10.2.0/network/admin/VIS_db/listener.ora will be created as well.