Oracle9i Application Server Using the PL/SQL Gateway
Release 1 (v1.0.2.2)

Part Number A90099-01

Contents

Index

Go to previous page Go to next page

5
Installing the PL/SQL Gateway

5.1 System Requirements

The following are the recommended and minimum requirements for installing and running the PL/SQL Gateway:

Operating Systems

Oracle Database

Web Listener

Web Browsers

5.2 Before you begin

Before you install the PL/SQL Gateway using the Oracle9i Application Server v1.0 Oracle Universal Installer, satisfy the following requirements:

5.3 Installation

To begin the Oracle Universal Installer, execute the runInstaller application located on your product CD or stage area. Follow the installation instructions, including choosing a directory where you want to install Oracle9i Application Server v1.0.2. This install directory is referred to as <ORACLE_HOME>.

5.4 Installing Required Packages

After installation, manually install additional required packages using the owaload.sql script.

  1. Navigate to the directory where the owaload.sql file is located. This directory is <ORACLE_HOME>/APACHE/modpsql/owa.

  2. Using SQL*Plus, log into the Oracle database as the SYS user.

  3. At a SQL prompt, run the following command:

    @owaload.sql log_file  
    

Table 5-1 Installing Required Packages Parameters
Elements  Description 

owaload.sql  

Installs the PL/SQL Web Toolkit packages into the SYS schema. It also creates public synonyms and makes the packages public so that all users in the database have access to them. Therefore, only one installation per database is needed. 

log_file 

The installation log file.  

5.4.1 Upgrading from Oracle9i Application Server or WebDB Listener


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

All Rights Reserved.

Contents

Index