skip to main content
Connection Option Descriptions : SID
  

Try DataDirect Drivers Now

SID

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.

GUI Tab

General tab