Oracle Transparent Gateway for Ingres II Administrator's Guide Release 8.1.6 Part Number A82871-01 |
|
The Oracle database server init.ora parameters are distinct from heterogeneous services (HS) initialization parameters. Set Heterogeneous Services parameters in the initialization parameter file using an agent-specific mechanism, or set them in the Oracle data dictionary using the DBMS_HS package. All string values for Heterogeneous Services parameters must be lowercase.
This appendix contains information about the following Heterogeneous Services initialization parameters:
The syntax for the initialization parameter file is as follows:
<param> = <value>
set <param> = <value>
private <param> = <value>
set private <param> = <value>
where:
<param> is an initialization parameter name.
<value> is the initialization parameter value.
'set' and 'private' are keywords.
A backslash at the end of the line continues the string on the next line. If a backslash precedes any other character then the backslash is ignored.
If there is a syntax error in an initialization parameter file, none of the settings take effect.
Default value: |
none |
Range of values: |
not applicable |
Specifies the information needed to connect to the Ingres II database.
This is a required parameter, whose format is:
HS_FDS_CONNECT_INFO=
vnode::database_name
where:
The entry for database_name is case-sensitive. You can specify an environment variable instead of the database name if your logical database is distributed among several physical databases. The Oracle Transparent Gateway for Ingres II translates the logical name before binding. For example, a logical name (ALL_SITES) can be defined to use as the database name for a logical database distributed among two physical databases (BOSTON_DB and PARIS_DB), as follows in the UNIX shell:
setenv ALL_SITES BOSTON_DB,PARIS_DB
HS_FDS_RECOVERY_ACCOUNT
Default value: |
RECOVER |
Range of values: |
any valid userid |
Specifies the name of the recovery account used for the commit-confirm transaction model. An account with user name and password must be set up at Ingres II. For more information about the commit-confirm model, see the HS_FDS_TRANSACTION_MODEL parameter.
Default value: |
RECOVER |
Range of values: |
any valid password |
Specifies the password of the recovery account used for the commit-confirm transaction model set up at Ingres II. For more information about the commit-confirm model, see the HS_FDS_TRANSACTION_MODEL parameter.
Default value: |
0 |
Range of values: |
any value between -24 and +24 |
Sets the number of hours behind GMT. For example, HS_FDS_TIMEZONE=4 is the United States East Coast time zone (which is four hours behind GMT). A negative number sets the number of hours ahead of GMT.
Default value: |
off |
Range of values: |
off, on |
Specifies whether error tracing is turned on or off for gateway connectivity.
The following values are valid:
$ORACLE_HOME/TG4INGR/LOG
.
Default value: |
COMMIT_CONFIRM |
Range of values: |
COMMIT_CONFIRM, READ_ONLY, or SINGLE_SITE |
Specifies the type of transaction model that is used when the Ingres II database is updated by a transaction.
The following values are possible:
|
![]() Copyright © 2000 Oracle Corporation. All Rights Reserved. |
|