The D3 Oracle Gateway dm,hosts, file entries can be configured during installation or at a later time. All OSFI data sources MUST be identified by an entry in the dm,hosts, file. The dm,hosts, file converts a host name to a driver number and connection information. Each Oracle dm,hosts, file item identifies a specific schema -- the intersection of the computer name, the Oracle instance name within that computer, and the schema name within that instance.
The item-ID identifies the specific Oracle schema. It can be used within super Q-pointers and fully qualified path names.
Attribute 1 of the dm,hosts, record is always the driver number for an OSFI driver. In the case of the D3 Oracle Gateway, the driver number is 3.
Attribute 2 contains the logon string used to log on to the Oracle database for this schema. The password can appear as part of the logon string (scott/tiger@orcl).
Example dm,hosts, entry:
Attr | Data | Description |
---|---|---|
item-ID | Oravms | The D3 name for the specific schema that is the intersection of the computer name, database instance name and schema name. |
1 | 3 | Unique driver number. This is the same for all D3 Oracle Gateway dm,hosts, file entries. |
2 | scott/tiger@orcl | Logon string: |
scott (user name) | ||
tiger (password) | ||
orcl (as defined in the tnsnames.ora file) |