In this document, instructions for deploying the Hotel Reservation System PSP Application in an Oracle Database are provided.

Required Software
-------------------
1.   Oracle Database Server Version 8.1.6 or higher
2.   Oracle Internet Application Server(iAS) Version 1.0 or higher
3.   Oracle 8i Travel Schema downloadable from OTN Site http://technet.oracle.com/.
4.   Oracle PL/SQL Web Toolkit Packages :
               The Schema in which the PSPs are to be loaded should have access to the
               Web Toolkit packages supplied by Oracle. For instructions on installing
               these packages and giving access, refer to the Chapter 'Installing mod_PLSQL'
               - Section 'Installing required packages' in document "Using mod_plsql" on the
               Documentation Library CD-ROM of iAS software.

Preliminary Installation Steps for installing PSPs in Oracle Database
---------------------------------------------------------------------
    Step 1. Install Oracle iAS and setup the http server using the instructions in the manual supplied with the software

    Step 2. Update your SYSTEM path to include the $IAS_HOME/bin directory

    Step 3. Extracting and Loading Hotel Reservation System PSP Application.

            a) Create a new directory <pspSamples> to hold the Sample .psp files

            b) Extract the Hrs.zip file provided in this directory

            c) After extracting the .zip file, it creates 'Hrs' directory which contains all the source files
                of the application and .gif logo file.

           d) Copy the Hrs_Logo.gif file in the 'Hrs' directory to the directory specified for the Alias
               /images/ in the file "plsql.conf" under directory $IAS_HOME/Apache/modplsql/cfg/.
               If the Alias definition does not exist, then add the following line to the file:

                       Alias /images/   "<full path>"

               where, <full path> is the complete path of a directory on the server machine.
               Example:
                               Alias /images/   "/home1/iashome/Apache/modplsql/images/"

               After creating the Alias, copy the file 'Hrs_Logo.gif' to the directory specified above.

            e) Load each of the .psp files in the 'Hrs' directory using the 'loadpsp' utility supplied with
                iAS software. This can be found under the directory $IAS_HOME/bin. Add this directory
                to the system path. Then, from the 'Hrs' directory, run the following to load the pages:-

               loadpsp -replace -user <uname>/<passwd>@<dbalias> Hrs_Error_Page.psp *.psp

               where,
                      <uname>/<passwd> - is the username/password of schema where the psp has to be loaded
                                                        (here this would be the Travel schema - travel/travel).
                      <dbalias>                 - is the sql*net tns names alias to connect to the desired database
                                                        (here the database is the same as the one in which Travel Schma is installed)