16 Migration From Previous Releases

This chapter describes how to migrate to new instances of Oracle Database Gateway for DRDA from an existing installation. Perform the following steps to migrate to a new release of Oracle Database Gateway for DRDA from an existing release:

  1. Install the New Release

  2. Copy the Gateway Initialization Parameter File

  3. Update the Initialization Parameters

  4. Bind Gateway Package

  5. Install/Upgrade Data Dictionary Views

Install the New Release

Install the new release of the gateway in a separate directory, as discussed in Chapter 12, "Installing Oracle Database Gateway for DRDA".

Caution:

Do not install the gateway over a previously existing gateway installation. This corrupts the existing installation.

Copy the Gateway Initialization Parameter File

Copy the initsid.ora from the old gateway instance to the new instance. The formats of the parameters in the initsid.ora gateway initialization file have changed. Refer to "Oracle Database Gateway for DRDA Initialization Parameters" .

Update the Initialization Parameters

The next step in migrating to a new release of Oracle Database Gateway for DRDA consists of updating the initialization parameters.

Changed Parameters

The use of DRDA_CONNECT_PARM has changed in this version. Refer to Appendix C, "Initialization Parameters" for the syntax of the parameter.

Obsolete Parameters

The following parameters are obsolete for the 11g version. Remove them from your configuration files:

  • MODE

  • SERVER_PATH

  • DRDA_OVERRIDE_FROM_CODEPAGE

  • DRDA_OVERRIDE_TO_CODEPAGE

  • ERROR_LOGGING

  • ERROR_REPORTING

  • ERRORTAG

  • GATEWAY_SID

  • GROUP_BY_OFF

  • GTWDEBUG

  • INCREMENT_CURSORS

  • DRDA_CALLDESC_STMT

  • DRDA_CALLDESC_PROC

Bind Gateway Package

When upgrading to 11g release you must rebind the gateway package if you have changed any of the following initialization parameters:

  • DRDA_DISABLE_CALL

  • DRDA_ISOLATION_LEVEL

  • DRDA_PACKAGE_COLLID

  • DRDA_PACKAGE_CONSTOKEN

  • DRDA_PACKAGE_NAME

  • DRDA_PACKAGE_OWNER

  • DRDA_PACKAGE_SECTIONS

Install/Upgrade Data Dictionary Views

You must install or upgrade the data dictionary views when upgrading the Oracle Database Gateway for DRDA. Refer to Chapter 14, "Configuring Oracle Database Gateway for DRDA" for more information on creating data dictionary views.