Skip Headers

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
  Go To Documentation Library
Home
Go To Table Of Contents
Contents
Go To Index
Index

Previous Next  

6 Upgrading mod_plsql

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:

6.1 mod_plsql Upgrade Items

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.

Table 6-1 mod_plsql Upgrade Items

Upgrade Item Location in Release 1 (1.0.2.2.x) Oracle home Location in 10g (9.0.4) Oracle home Notes
wdbsvr.app Apache/modplsql/cfg/

cache.cfg Apache/modplsql/cfg/

dads.conf
Apache/modplsql/conf/

6.2 mod_plsql Upgrade Tasks

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

6.2.1 Upgrading from One Computer to Another

If necessary, you can upgrade the DAD and cache information from one computer to another, by following the steps below:

  1. 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

  2. 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.