SID
- Last Updated: February 4, 2020
- 1 minute read
- DataDirect Connectors
- ODBC
- Oracle Database Wire Protocol 8.0
- Documentation
Attribute
SID (SID)
Purpose
The Oracle System Identifier that refers to the instance of Oracle running on the server.
Valid Values
sid | %DEFAULT%
where:
- sid
- is the name of the Oracle System Identifier.
Behavior
If set to sid, the driver attempts to connect to the Oracle instance that corresponds to the specified Oracle System Identifier.
If set to %DEFAULT%, the driver attempts to connect to the SID specified by the DEFAULT_SERVICE_LISTENER property in the server-side listener.ora file.
Notes
- This option is mutually exclusive with the LDAP Distinguished Name, Service Name, Server Name, and TNSNames File options.
Default
None. If no values are specified for the LDAP Distinguished Name, SID, Service Name, and TNSNames options, the driver attempts to connect to the ORCL SID by default.