In Oracle : Migrating to AutoConfig on the Database Tier

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

Oracle Applications EBS

Oracle Apps 11i DBA (I) Oracle Apps 11i DBA (II) Oracle Apps 11i DBA (III) Oracle Apps 11i Sys Admin UPGRADE 11i Apps to R12 Oracle Apps R12 DBA

The last articles in the site (HOT)

The most visited articles in the site

In-Oracle.com  -> Oracle Applications (apps)  -> 11i

-> Migrating to AutoConfig on the Database Tier

 

 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. 

 

 

In-Oracle.com  -> Oracle Applications (apps)  -> 11i 

-> Migrating to AutoConfig on the Database Tier

Oracle Applications EBS 11i, R12      Oracle Database      Data Warehouse & BI      Oracle Middleware      PL/SQL      Linux ...

 

     Copyright (c) 2011-2015  www.in-oracle.com  |  Disclaimer: The views expressed on this web site are my own and do not reflect the views of Oracle Corporation. You may use the information from this site only at your risk.