3
PL/SQL Gateway Migration

This chapter explains the process of migrating from PL/SQL Gateway version 2.6 (formerly mod_plsql) to 3.0 in Oracle9i Application Server.

Contents

• Pre-migration

• Environment

• Configuration

• Application Logic

• Tools

Pre-migration

The following sections explain pre-migration steps. These instructions must be followed before beginning any migration work. Users must perform the Oracle HTTP Server migration tasks before starting to migrate PL/SQL Gateway.

Backing Up Configuration Files

Make copies of the following files before performing any migration tasks:

<OLD_HOME>/Apache/modplsql/cfg/wdbsvr.app

Installing the new PL/SQL Web Toolkit packages

Install the latest PL/SQL Web Toolkit packages being shipped with Oracle9i Application Server, Release 1.0.2. These are available in NEW_HOME/Apache/modplsql/owa. For installation information, refer to Chapter 2 of Using the PL/SQL Gateway in the Oracle9i Application Server Documentation Library.

Environment

No environment migration tasks are necessary.

Configuration

The following sections explain changes you must make to your configuration files for the PL/SQL Gateway to continue to work as it did with Oracle Internet Application Server, Release 1.0.0.

You will need to make changes to the configuration files in Table 3-1.

Table 3-1 Configuration Files Used by PL/SQL Gateway

Configuration File	Description
NEW_HOME/Apache/modplsql/cfg/wdbsvr.app	Configuration information for the PL/SQL Gateway.

app.cfg

You can safely replace the application configuration file in NEW_HOME with your old application configuration file. Execute the following command to replace the file:

prompt> cp  OLD_HOME/Apache/modplsql/cfg/wdbsvr.app  NEW_HOME/Apache/modplsql/cfg/wdbsvr.app

Configuration Page

The PL/SQL Gateway configuration page has been simplified in this release. PL/SQL Gateway provides a Web page for configuring Database Access Descriptors (DADs). A DAD is a set of values that specify how the PL/SQL Gateway connects to a database server to fulfill an HTTP Server.

Please refer to "Chapter 3: Configuring the PL/SQL Gateway"of Using the PL/SQL Gateway in your Oracle9i Application Server documentation library.

Application Logic

Installation of the new PL/SQL Web Toolkit packages invalidates all PL/SQL applications which are dependent on it. It is recommended that you recompile all the invalidated packages. If you choose not to recompile, then the invalid packages will automatically get recompiled when they are accessed for the first time.

The new PL/SQL Gateway makes available the following new features to all PL/SQL applications:

• Integration with Oracle's Single Sign-On solution.

• New "owa_cache" package can be used to cache PL/SQL results or documents in the middle-tier. Users can set the caching mechanism to either "Expires model" or "Validation model."

• Path aliasing.

For more details on these features, refer to Using the PL/SQL Gateway in the Oracle9i Application Server Documentation Library.

Tools

No tools migration tasks are necessary.