Oracle® Application Server 10g Upgrading from Release 1 (1.0.2.2.x) to 10g (9.0.4)
10g (9.0.4) Part No. B13674-02 |
|
![]() |
![]() |
This chapter contains step-by-step instructions for upgrading the mod_plsql configuration: Database Access Descriptors (DADs) and cache settings. It contains the following sections:
An upgrade item is an aspect of configuration that is acted upon during upgrade: a file, executable, or a setting that you must add, change, or delete/replace in the 10g (9.0.4) installation. mod_plsql
upgrade items are described in Table 6-1.
A command line script, (modPlsqlMigration.csh
on UNIX and modPlsqlMigration.cmd
on Windows) moves the definitions to the new format. The modPlqlMigration
script replaces the dadMigration
script and allows the migration of cache settings as well as the DADs. The scripts are located in the OracleAS middle-tier 10g (9.0.4) Oracle home, in the bin
directory.
The scripts operate on the <
source_MT_OH
>/Apache/modplsql/cfg/wdbsvr.app
and cache.cfg
source files. The scripts update the <
destination_MT_OH
>/Apache/modplsql/conf/dads.conf
and cache.conf
files. The command syntax for executing the script is:
<
migration script
> -em <
em home
> [-s <
source_MT_OH
>] [-t <
destination_MT_OH
>] [[-c [-dir <
cache directory
>]] | -d]
Table 6-2 describes the variables in the command.
Table 6-2 mod_plsql Upgrade Script Variables
Variable | Definition |
---|---|
< migration script >
|
The migration script being run (modPlsqlMigration.csh on UNIX and modPlsqlMigration.cmd on Windows).
|
-em < em home >
|
When migrating from a Oracle9iAS Release 1 (1.0.2.2.x) middle tier to an Oracle Application Server 10g (9.0.4) middle tier, the Oracle Enterprise Manager home should always be specified as theOracle Application Server 10g (9.0.4) middle tier Oracle home.
This option is necessary, because the scripts support upgrades to other versions as well. There is no default value for this option. |
-s < source_MT_OH >
|
The Oracle9iAS Release 1 (1.0.2.2.x) middle tier Oracle home that is the source of the migration. If not specified, then the current directory is used. |
-t < destination_MT_OH >
|
The Oracle Application Server 10g (9.0.4) middle tier Oracle home that is the target of the migration. If not specified, the value of the ORACLE_HOME environment variable is used. |
-c
|
Perform only a cache upgrade. Do not use this option at the same time as the -d option. By default, both upgrades (cache and DAD) are performed.
|
-dir < cache directory >
|
The value for the cache directory property. Do not use this option at the same time as the -d option. If no value is specified, the Apache/modplsql/cache directory in the destination OracleAS middle-tier 10g (9.0.4) Oracle home will be used.
|
-d
|
Perform only a DAD migration. Do not use this option at the same time as the -c option. By default, both upgrades (cache and DAD) are performed.
|
Examples:
On UNIX, the command below migrates DADs and cache settings using the current directory as the source Oracle9iAS Release 1 (1.0.2.2.x) middle tier Oracle home, the value of the ORACLE_HOME environment variable as the destination Oracle Application Server 10g (9.0.4) middle tier Oracle home, and the default cache directory:
$ORACLE_HOME/bin/modPlsqlMigration.csh -em $ORACLE_HOME
On Windows, the command below migrates only the DADs and specifies the source and destination Oracle homes. No defaults are used in this example:
%ORACLE_HOME%\bin\modPlsqlMigration.cmd -em c:\oracle\ora904mid -s c:\oracle\ora1022mid -t c:\oracle\ora904mid -d
On UNIX, the command below migrates only the cache settings. It specifies the current directory as the source Oracle9iAS Release 1 (1.0.2.2.x) middle tier Oracle home, the value of the ORACLE_HOME environment variable as the destination Oracle Application Server 10g (9.0.4) middle tier Oracle home, and the default cache directory:
$ORACLE_HOME/bin/modPlsqlMigration.csh -em /oracle/ora904mid -c
If necessary, you can upgrade the DAD and cache information from one computer to another, by following the steps below:
Create the following directory structure on the destination computer (for example, by copying files from your Oracle9iAS Release 1 install). The script looks for these files in the Oracle9iAS Release 1 Oracle home:
<
ORACLE_HOME
>/Apache/modplsql/cfg/wdbsvr.app
<
ORACLE_HOME
>/Apache/modplsql/cfg/cache.cfg
Execute the upgrade script, referencing this pseudo Oracle home using the -s
option to specify the directory, or by making the pseudo Oracle home the current directory.