Skip Headers
Oracle® Transparent Gateway for DRDA Installation and User's Guide
10g Release 2 (10.2) for UNIX

Part Number B16217-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

15 Migration and Coexistence with Existing Gateways

Migration to new instances of Oracle Transparent Gateway for DRDA from an existing installation is straightforward, provided some guidelines. This chapter covers how to make these new installations as easy as possible.

This chapter provides information that is specific to 10.2 release of the Oracle Transparent Gateway for DRDA. This chapter contains the following sections:

Migrating Existing V4, V8, or V9 Gateway Instances to New Release

Migration is the process of converting an installed version of an Oracle Database into a later version. This migration generally involves running the Oracle Migrate (MIG) utility to modify Oracle Database control file structures from the format of one version to the format of another version.

Upgrading is the process of converting an Oracle Database from an installed release into a later release of the same version. For example, transforming patch release 8.0.3 into patch release 8.0.4 is called upgrading.

Step 1: Install the New Release

Install the new release of the gateway in a separate directory, as discussed in Chapter 4, "Installing the Gateway".

Caution:

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

Step 2: Transferring initsid.gtwboot Gateway Boot Initialization parameters.

In previous releases, the gateway used two Gateway Initialization files ( initsid.gtwboot and initsid.ora), or it used a Startup Shell Script (drdaDB2.sh) and one initialization file (initsid.ora). In this release, all parameters have been migrated into a single Gateway Initialization file: initsid.ora. Migrating a previous release involves copying the parameters from the initsid.gtwboot or Startup Shell Script into the initsid.ora. The format of the parameters can be found in Appendix C, "DRDA-Specific Parameters".

Step 3: Transferring initsid.ora Gateway Initialization File parameters.

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 "Gateway Initialization File Parameters" in Appendix C, "DRDA-Specific Parameters".

Backout Considerations When Migrating to New Releases

During the migration from version 4, version 8, or version 9 gateway instances to the latest Oracle Database 10g release, if problems are encountered, then it is always possible to revert to the previous version. Assuming a working version 4 gateway instance exists, simply change the TNSNAMES.ORA entries from using the Oracle Database 10g gateway instance to the older version 4 instance. Remember to remove the "(HS=)" entry from the SQL*Net connect definition.

Oracle recommends that you keep the old gateway home and instance configurations intact and operational, when you are installing a new release of the gateway and upgrading the existing instances, in case you have problems with the upgrade. This will ensure minimal downtime between changes to different gateway instances.

New and Changed Parameters When Migrating to Release 10g

The 10.2 release of the Oracle Transparent Gateway for DRDA introduces new and changed initialization parameters if you are migrating from a version 4, version 8, or version 9 gateway to the Oracle Database 10g gateway.

New Parameters

Parameters introduced in the 10.2 release of the gateway, listed in the following table, may be added to the Gateway Initialization File:

  • DRDA_CACHE_TABLE_DESC

  • DRDA_GRAPHIC_LIT_CHECK

  • DRDA_GRAPHIC_PAD_SIZE

  • DRDA_GRAPHIC_TO_MBCS

  • DRDA_MBCS_TO_GRAPHIC

  • DRDA_PROCDESC_STMT

  • DRDA_PROCDESCPARMS_STMT

  • DRDA_PROCCALL_MASK

  • DRDA_FUNCDESC_STMT

  • DRDA_FUNCDESCPARMS_STMT

  • DRDA_FUNCCALL_MASK

  • DRDA_GRAPHIC_CHAR_SIZE

Parameters That Have Been Changed in Usage

The usage of the following parameter has changed in version 9 of the gateway:

  • DRDA_CONNECT_PARM

Parameters That Have Been Renamed

The following table lists the parameters whose names have been changed in version 9 of the gateway, and their corresponding old names. Refer to Oracle Database Heterogeneous Connectivity Administrator's Guide for more detailed information about these parameters.

New Name Old Name
HS_COMMIT_STRENGTH_POINT COMMIT_STRENGTH_POINT
HS_DB_DOMAIN DB_DOMAIN
HS_DB_INTERNAL_NAME DB_INTERNAL_NAME
HS_DB_NAME DB_NAME
HS_DESCRIBE_CACHE_HWM DESCRIBE_CACHE_HWM
HS_LANGUAGE LANGUAGE
HS_NLS_DATE_FORMAT NLS_DATE_FORMAT
HS_NLS_DATE_LANGUAGE NLS_DATE_LANGUAGE
HS_OPEN_CURSORS OPEN_CURSORS
HS_ROWID_CACHE_SIZE ROWID_CACHE_SIZE

Obsolete Parameters

The following parameters are obsolete for the 10g 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

DRDA Server Considerations

A part of the Normal Installation for the gateway involves binding a package and (as an option) installing data dictionary views on the DRDA Server. This release of the gateway (10.2.0) is compatible with version 4, version 8, and version 9 packages that have been previously bound. The data dictionary views, however, have changed with the 10.2 release. If you plan to utilize the data dictionary views that are provided by the gateway, then you must migrate to the new views. Oracle recommends that you install the new views as discussed in Chapter 11, "Configuring the Gateway". If you have changed certain DRDA parameters of the Gateway Initialization parameters as a result of the migration, then a rebind of the package will be required.

Oracle Net Considerations

The gateway uses the Heterogeneous Services (HS) facilities of Oracle Database and Oracle Net. gateway service name entries in the tnsnames.ora need a slight modification so that Oracle Net that the gateway will be using the HS facilities. Refer to "Configuring Oracle Net" for detailed information.