The Oracle service name that specifies the database used for the connection. The service name is a string that is the global database name—a name that is comprised of the database name and domain name, for example:
sales.us.acme.com
The service name is included as part of the Oracle connect descriptor, which is a description of the destination for a network connection. The service name is specified in the CONNECT_DATA parameter of the connect descriptor, for example:
(CONNECT_DATA=(SERVICE_NAME=sales.us.acme.com))
In this example, you would specify sales.us.acme.com as the value for the Service Name connection option.
Valid Values
service_name | %DEFAULT%
where:
service_name
is the description of the destination for a network connection.
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 Service Name 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, SID, Server Name, and TNSNames File options.
Default
None. If no values are specified for the SID, Service Name, and TNSNames options, the driver attempts to connect to the ORCL SID by default.
This option is mutually exclusive with the LDAP Distinguished Name, SID, Server Name, and TNSNames File options.