Home

	Expand Search

DirectConnect for Oracle Installation/Reference for Windows NT

Appendix B: Sample Configuration File

Appendix B

Sample Configuration File

The following is a sample configuration file. It can also be found in SYBASE\sample\access\oracle\sample.cfg.

; sample.cfg                    October, 1997 

; Sample configuration file -- DirectConnect for Oracle
; Release 11.0
; Lines with a semi-colon in column 1 are comment lines. 
;
[ORACLEDC]
max_users = 25
max_packetsize = 4096
language = us_english
charset = iso_1
administrator = system
connect_string = @T:nautilus:ora_svr4
number_mode = 1
truncate_text = 0

[ORATEST]
connect_string = local,ora_nt
number_mode = 1
truncate_text = 0
default_precision = 30
default_scale = 2
;
; This sample.cfg defines a DirectConnect server named ORACLEDC.
; This server has two services. ORACLEDC can communicate with
; two different Oracle databases. The two services are:
;
; [ORACLEDC]-identified with connect_string @T:nautilus:ora_svr4
; [ORATEST]-identified with connect_string local,ora_nt
;
; Note that ORACLEDC is also a required service name.
; ORACLEDC.cfg would be the configuration file name
; for this server. 
;
; Attributes of server [ORACLEDC]: 
;
; -    The maximum number of users is 25. 
;
; -     The maximum packet size between the client application
;    and this server is 4096.
;
; -    The default language is us_english. The client language
;    overrides this value. When connecting to Oracle,
;    the language requested is that of the client, which might
;     not be this default value.
;
; -    The default character set is iso_1. This character
;    set is requested when connecting to Oracle. Results
;    are converted to the clients character set when results are
;    sent to the client. 
;
; -    The Oracle system administrator is set to the user named
;    "system". The DirectConnect allows only the user "system" 
;    to execute the system stored procedure "sp_shutdown". 
;
; -     For the [ORACLEDC] service, the connect_string is
;     "@T:nautilus:ora_svr4". For [ORACLEDC], "nautilus" is the 
;     network name of the remote node where Oracle is running.
;     "ora_svr4" is the Oracle system id (sid) for this instance 
;     of an Oracle server. The value for a sid is determined by 
;     the Oracle system administrator when the Oracle products are
;     installed. The format of this connect_string shows that this
;     service uses SQLNET V1.
;
; -     For the [ORATEST] service, the connect_string is
;     "local,ora_nt". "ora_nt" is the Oracle system id (sid) for
;     the instance of the Oracle server running on the same 
;     machine as this DirectConnect server. No SQLNET is 
;     required. The [ORATEST] service inherits all global 
;     properties defined in the [ORACLEDC] service. The ORATEST 
;     service identifies some service-specific options,
;    overriding default values.
;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
;
; A service using SQLNET V2 requires an entry in the TNSNAMES.ORA
; file, and that entry name is part of the connect_string.
;
; Define each service in the interfaces file. For this sample,
; there would be entries ORACLEDC and ORATEST. All other
; parameters in these two interfaces entries must be identical.  
;
;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;;
; To use sample.cfg as a template, copy it to the SYBASE
; directory. Rename it to match the name of your DirectConnect
; for Oracle server. For example, this configuration file would
; be named "ORACLEDC.cfg". Modify your file, reflecting the node
; names and Oracle system ids for your configuration.
; Customize other configuration properties to meet your
; requirements.
;
;
;To start the server:

;-    Set the SYBASE environment variable to the installation
;     location. For example: c:\SYBASE.
;
;-    Include the SYBASE\bin, SYBASE\dll and orant\bin 
;     directories in your PATH environment variable.
;
;-    Change directory to SYBASE\bin.
;
;-    Start the DirectConnect, specifying the name of the server.
;    For example: dco -SORACLEDC      

; copyright (c) Sybase, Inc. Emeryville, CA 1997.  All rights
; reserved.