Patches

README for 3835952
Patch Details: Access key=P 
-----------------------------------------
MODPLSQL VERSION 3.0.9.8.5d ONE-OFF PATCH
-----------------------------------------
Date: August 18, 2004

o What is in this patch?
------------------------
-> This patch contains the following fix for Oracle Database

BUG#3559310 : 2004-S128E
BUG#3835940 : BACKPORT OF BUG 3559310 ON TOP OF VERSION 8.1.7

o What version can I apply this patch on?
-----------------------------------------
-> Oracle Database 8.1.7.x

o How to apply this patch?
-----------------------------------
1. Unzip the patch into a temporary directory. This directory will be referred 
   as %PATCH_DIR% in the rest of the steps.

2. Change your current working directory to %PATCH_DIR%

3. Identify the Oracle databases serviced by mod_plsql. You can get this
   information by scanning the database connect strings defined inside your
   Database Access Descriptors (DAD) for mod_plsql. 

   Here are the steps to get this information :

   - Identify the setting for the environment variable WV_GATEWAY_CFG.
     This information can be obtained by looking at the setting for
     System environment variables inside the Windows Control Panel.
     The default value for WV_GATEWAY_CFG is
         <ORACLE_HOME>\Apache\modplsql\cfg\wdbsvr.app
   - Open the file as pointed by this environment variable.
   - Search for each unique occurrence of 'connect_string' and
     use the database connection information to identify which database
     instances need to be patched up.
   - If a DAD does not explicitly specify a value for 'connect_string',
     then identify the default database instance for your configuration.

4. For all such database instances,
  
  a.) Verify that you can connect to the database
      - Issue "sqlplus /nolog"
      - At the SQL prompt, issue "conn sys/sys_password@conn_str as sysdba"
      - Make sure that you can connect to the backend repository

      NOTE:
        The following Oracle database parameter settings could disallow
        remote database connections as sysdba
           - O7_DICTIONARY_ACCESSIBILITY = FALSE
           - REMOTE_LOGIN_ PASSWORDFILE = NONE
        If this is the case, either allow remote connections temporarily, or
        upload the patch to the database machine and follow steps 1 through 4
        to patch up the database.

        For more details on these Oracle database parameters, refer to the
        Oracle documentation.

  b.) Invoke the following command to patch up the OWA packages in the SYS
      schema

     patch.cmd -m sysobjects -o <ORACLE_HOME> -c <conn_str> -p <sys_password>

5. Stop the Oracle HTTP Server

6. Issue the following command to patch up mod_plsql

   patch.cmd -m midtier -o <ORACLE_HOME> 

   WARNING :  The newer version of  mod_plsql will not work against a
   database which is not patched up as outlined in step 4.

7. Restart Oracle HTTP Server


o How to undo the patch?
-----------------------------------
The patch script backs up your older data under the following directory
    <ORACLE_HOME>\Apache\modplsql\prepatch

If you run into problems while appyling the patch, you can revert back the
patch as follows:

1. Stop the Oracle HTTP Server

2. Undo the patch by recursively copying over the backed up files
   Change your current directory to <ORACLE_HOME>\Apache\modplsql\prepatch
   Issue the commands
       xcopy /S * ..\
       When prompted about Overwriting data, select "All"
       copy bin\modplsql.dll <ORACLE_HOME>\bin

3. Restart Oracle HTTP Server

End.