Oracle9i Application Server Migrating from Oracle Internet Application Server 1.0.1
Release 1.0.2 for Windows NT

Part Number A87391-01

Library

Contents

Index

Go to previous page Go to next page

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.

The migration topics for this component are:

Premigration

The following sections explain premigration 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 file before performing any migration tasks:

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.

See Also:

Chapter 2 of Using the PL/SQL Gateway in the Oracle9i Application Server Documentation Library for installation information. 

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

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.

wdbsvr.app

You can safely replace the application configuration file in NEW_HOME with your old application configuration file.

Configuration Page

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. The PL/SQL Gateway configuration page has been simplified in this release.

See Also:

Chapter 3, "Configuring the PL/SQL Gateway" of Using the PL/SQL Gateway in the 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:

Tools

No tools migration tasks are necessary.


Go to previous page Go to next page
Oracle
Copyright © 2000 Oracle Corporation.

All Rights Reserved.

Library

Contents

Index