oracle-datasource-type

This command sets the identifier type for the Oracle data source.

Syntax

oracle-datasource-type SID

oracle-datasource-type ServiceName

SID: The identifier is an Oracle system identifier (SID). The SID is a unique name for an Oracle database instance. This setting is the default value.
ServiceName: The identifier is an Oracle service name. The service name is a domain-qualified database name. This global database name is defined during installation or database creation. Use this value to connect to Oracle Real Application Clusters (RAC).

The oracle-datasource-type command sets the type of identifier for an Oracle data source. This command is relevant when db is Oracle.

Create the Oraclesource data source. Set the vendor to Oracle with a service name identifier of oracle1.mydomain.com.

# sql-source Oraclesource
# db Oracle
# oracle-datasource-type ServiceName
# id oracle1.mydomain.com