Oracle Transparent Gateway Sybase Administrator's Guide Release 8.1.6 for Windows NT Part Number A80982-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 takes effect.
Default value: |
none |
Range of values: |
not applicable |
Specifies the information needed to connect to the Sybase database.
This is a required parameter, whose format is:
HS_FDS_CONNECT_INFO=
server_name.
database_name
where:
The entries for both the server_name and database_name are case-sensitive.
Default value: |
none |
Range of values: |
any value |
The name of the table owner that is used for the Sybase tables if an owner is not specified in the SQL statements.
Default value: |
none |
Range of values: |
any value |
Enables return values from functions. By default, all stored procedures and functions do not return a return value to the user.
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 Sybase. 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 Sybase. For more information about the commit-confirm model, see the HS_FDS_TRANSACTION_MODEL parameter.
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\tg4sybs\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 Sybase database is updated by a transaction.
The following values are possible:
|
Copyright © 2001 Oracle Corporation. All Rights Reserved. |
|