The following table summarizes connection properties required to connect to a database.

Table 1. Required properties
Property Characteristic
LDAPDistinguishedName Specifies the distinguished name for the LDAP entry that contains your connection information. Using an LDAP entry provides simplified maintenance by allowing you to centrally store and access connection information.
Note: If this property is specified, do not specify value for the following properties: AlternateServers, FailoverMode, LoadBalancing, SDUSize, ServerType, ServiceName, SID, TNSNamesFile, and TNSServerName.
PortNumber Specifies the TCP port of the primary database server that is listening for connections to the database.

The default is 1521.

ServerName

 Specifies the name or IP address of the server to which you want to connect.

ServiceName

 Database service name that specifies the database used for the connection.
Note: This property is mutually exclusive with the LDAPDistinguishedName, SID, TNSNamesFile, and TNSServerName properties.

SID

 Oracle System Identifier that refers to the instance of the Oracle database running on the server.
Note: This property is mutually exclusive with the LDAPDistinguishedName, ServiceName, TNSNamesFile, and TNSServerName properties.

The default is ORCL.

TNSNamesFile

 The path and filename to the tnsnames.ora file from which connection information is retrieved. The tnsnames.ora file contains connection information that is mapped to Oracle net service names. Using a tnsnames.ora file to centralize connection information simplifies maintenance when changes occur.
Note: This property is mutually exclusive with the ServerName, PortNumber, LDAPDistinguishedName, SID, and ServiceName properties.

TNSServerName

 The Oracle net service name that is used to reference the connection information in a tnsnames.ora file. The value of this property must be a valid net service name entry in the tnsnames.ora file specified by the TNSNamesFile property.
Note: This property is mutually exclusive with the ServerName, PortNumber, LDAPDistinguishedName, SID, and ServiceName properties.