Oracle   Home  

   Home  >  Oracle Applications 11i/ R12  >  Oracle Application 11i DBA  >  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

More information about this subject ( Migrating to AutoConfig on the Database Tier ) you can get from  www.in-oracle.com