Oracle Transparent Gateway for Ingres II Administrator's Guide
Release 8.1.6

Part Number A82871-01

Contents

Index

Go to previous page. Go to next page.

C
Heterogeneous Services Initialization Parameters

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:

Initialization Parameter File Syntax

The syntax for the initialization parameter file is as follows:

  1. The file is a sequence of commands.

  2. Each command should start on a separate line.

  3. End of line is considered a command terminator (unless escaped with a backslash).

  4. Each command can have one of the following forms:

  5. <param> = <value>

  6. set <param> = <value>

  7. private <param> = <value>

  8. set private <param> = <value>

    where:

    <param> is an initialization parameter name.

    <value> is the initialization parameter value.

    'set' and 'private' are keywords.

  9. 'set' and 'private' are reserved keywords. You cannot use either as an initialization parameter name. The 'set' keyword indicates that the initialization parameter should be set as an environment variable in the agent. The 'private' keyword indicates that the initialization parameter should be private to the agent and should not be uploaded to the server. Most initialization parameters should not be private. If, however, you are storing something sensitive like a password in the initialization parameter file, then you may not want it uploaded to the server because the initialization parameters and values are not encrypted when uploaded. Making these initialization parameters private prevents the upload from happening.

  10. An initialization parameter name is a string of characters starting with a letter and consisting of letters, digits and underscores. Initialization parameter names are case sensitive.

  11. An initialization parameter value is either:

    1. A string of characters that does not contain any backslashes, white space or double quotation marks (")

    2. A quoted string beginning with a double quotation mark and ending with a double quotation mark. The following can be used inside a quoted string:

      • backslash (\) is the escape character

      • \n inserts a newline

      • \t inserts a tab

      • \" inserts a double quotation mark

      • \\inserts a backslash

      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.

HS_FDS_CONNECT_INFO

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.

HS_FDS_RECOVERY_PWD

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.

HS_FDS_TIMEZONE

Default value: 

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.

HS_FDS_TRACE_LEVEL

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:

HS_FDS_TRANSACTION_MODEL

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:


Go to previous page. Go to next page.
Oracle logo.
Copyright © 2000 Oracle Corporation.

All Rights Reserved.

Contents

Index