13 Migrating From Existing Gateways
Migrating to new instances of Oracle Database Gateway for APPC from an existing installation is straightforward, provided you follow some guidelines. The following topics provide information to make these new installations as easy as possible. They also provide the parameters you need if you are using the TCP/IP for IMS Connect communication protocol on your gateway.
The following sections provide information that is specific to this release of Oracle Database Gateway for APPC for IBM AIX on POWER Systems (64-Bit), Linux x86-64, Oracle Solaris on SPARC (64-Bit), and HP-UX Itanium:
Migrating An Existing Gateway Instance to a New Release Using SNA Protocol
Follow these steps to migrate an existing gateway to12c Release 2 (12.2) of the gateway using the SNA communication protocol.
Note that if you are using the gateway TCP/IP support for IMS Connect, you will not be migrating an existing release to the current release of the gateway. However, you will need to place valid Heterogeneous Services parameters into your init
sid.
ora
file. Proceed to "Parameter Changes: Version 4 to 12c Release 2 (12.2) of the Gateway".
Step 1: Install the New Release
Install the new release of the gateway in a separate directory as outlined in Installing the Gateway.
Note:
Do not install the gateway over a previously existing gateway installation. Doing this corrupts the existing installation.
Step 2: Transferring the initsid.ora Gateway Initialization File Parameters
Copy the init
sid.
ora
file from the old gateway instance to the new instance.
If you are migrating from Release 9.0.1 or earlier of the gateway, PGA_TRACE
is not supported. You need to modify the parameter to TRACE_LEVEL
instead.
If you have encrypted some of the parameters at file init
sid
.ora
by using dg4pwd
, copy the $ORACLE_HOMRE/dg4appc/admin/init
sid
.pwd
file from the old gateway instance to the new instance.
Backout Considerations When Migrating to New Releases
Oracle recommends that you keep the old gateway Oracle home directory and instance configurations intact and operational when you are installing a new release of the gateway and upgrading existing instances, in case there are problems with the upgrade. This helps to ensure minimum down time between changes to different gateway instances.
Oracle Net Considerations
Oracle Database Gateway for APPC uses the Heterogeneous Services (HS) facilities of Oracle and Oracle Net. If you are upgrading from a version 4 gateway, then you need to slightly modify the gateway service name entries in the tnsnames.ora
file. Add an (HS=)
clause to tell Oracle Net that the gateway uses HS facilities. For more information, refer to Configuring Your Oracle Network.
Parameter Changes: Version 4 to 12c Release 2 (12.2) of the Gateway
This release of Oracle Database Gateway for APPC introduces new and changed initialization parameters if you are migrating from a Version 4 gateway to 12c Release 2 (12.2) of the gateway.
Note:
The "Parameter Changes: Version 4 to 12c Release 2 (12.2) of the Gateway" section does not apply to you if you are migrating to Release 10.2.0 from Version 8 of the Oracle Database Gateway for APPC.
If you are using the gateway TCP/IP support for IMS Connect, you will not be migrating from Version 4 to the current release of the gateway. However, you need to place valid Heterogeneous Services parameters into your init
sid.
ora
file.
Migration from existing gateways contains references to the particular HS parameters that you need to run the gateway.
Note:
Refer to the Oracle Database Heterogeneous Connectivity User's Guide for a complete list and descriptions of all HS parameters used in Oracle products.
New Gateway Initialization Parameters
The following parameters are in the gateway initialization file (init
sid.
ora
):
-
Note:
The
HS_
parameters are specific to Oracle Heterogeneous Services. For details on HS parameters, refer to the Oracle Database Heterogeneous Connectivity User's Guide.
Renamed Gateway Initialization File Parameters
Following is a list of the gateway initialization file (init
sid.
ora
) parameters that have been renamed in this release of the gateway. The former names of the parameters are shown in parentheses.
-
HS_COMMIT_STRENGTH_POINT
(formerlyCOMMIT_STRENGTH_POINT
) -
HS_DB_DOMAIN
(formerlyDB_DOMAIN
) -
HS_DB_NAME
(formerlyDB_NAME
) -
HS_DESCRIBE_CACHE_HWM
(formerlyDESCRIBE_CACHE_HWM
) -
HS_LANGUAGE
(formerlyLANGUAGE
) -
HS_NLS_DATE_FORMAT
(formerlyNLS_DATE_FORMAT
) -
HS_NLS_DATE_LANGUAGE
(formerlyNLS_DATE_LANGUAGE
) -
HS_OPEN_CURSORS
(formerlyOPEN_CURSORS
) -
HS_ROWID_CACHE_SIZE
(formerlyROWID_CACHE_SIZE
)
Obsolete Parameters
The following parameters are obsolete. If necessary, remove them from your configuration files:
-
MODE
-
SERVER_PATH
-
ERROR_LOGGING
-
ERROR_REPORTING
-
ERRORTAG
-
GATEWAY_SID
-
GROUP_BY_OFF
-
GTWDEBUG
-
INCREMENT_CURSORS
-
INIT_CURSORS
-
LIST
-
MAX_LOG_SIZE
-
OPTIMIZE_FILE_OPEN
-
ORDER_BY_OFF
-
RESOLVE_BINDS
-
RETRY
-
SET
-
SNMP_SUPPORT
-
SQL_TRACE
-
TRIM_CURSORS
-
D_OPEN_CURSORS
-
D_INIT_CURSORS
-
D_INCREMENT_CURSORS
-
D_TRIM_CURSORS
-
PGA_TRACE
Migrating from an Existing Gateway to TCP/IP Using SNA
The following sections are for those users who have an existing release of the gateway using the SNA protocol, but who want to switch to using TCP/IP support for IMS Connect.
The TCP/IP support for IMS Connect feature in this release of the gateway enables you to continue to use existing TIPs.