OracleConnection Properties

OracleConnection properties are listed in Table 7-49

Table 7-49 OracleConnection Properties

Property	Description
AccessToken	Used to get or set `OracleAccessToken` on the connection
ActionName	Specifies the action name for the connection
AllowCertificateSelectionUI	Indicates whether to allow the user to select a specific TLS/SSL certificate via a graphical interface for their database connection when using a MCS wallet location Not Available in ODP.NET, Unmanaged Driver
ChunkMigrationConnectionTimeout	This setting pauses the connection request until the migration completes or fails to migrate in the specified time, then connect to the correct shard with the data requested. Not Available in ODP.NET, Unmanaged Driver
ClientId	Specifies the client identifier for the connection
ClientInfo	Specifies the client information for the connection
ConnectionString	Specifies connection information used to connect to an Oracle database
ConnectionTimeout	Indicates the maximum amount of time that the `Open` method can take to obtain a pooled connection before the request is terminated
ConnectionType	Determines whether a particular connection object is associated with a TimesTen database connection, an Oracle database connection, or no physical connection Not Available in ODP.NET, Managed Driver and ODP.NET Core
`Container`	Inherited from `System.ComponentModel.Component`
Credential	Used to get or set an `OracleCredential` object on the connection
Database	Not Supported
DatabaseDomainName	Specifies the name of the database domain to which the connection is set
DatabaseEditionName	Sets or gets the edition name for the `OracleConnection` object
DatabaseName	Specifies the name of the database to which the connection is set
DataSource	Specifies the Oracle Net Services Name, Connect Descriptor, or an easy connect naming that identifies the database to which to connect
DRCPConnectionClass	Specifies a logical name that identifies the DRCP connection pool that the ODP.NET connection will use
DRCPPurity	Specifies whether an application can reuse a pooled session (`Pooled`) or must use a new session (`New`)
HostName	Specifies the name of the host to which the connection is set
InstanceName	Specifies the name of the instance to which the connection is set
KeepAlive	Specifies whether to keep an idle connection alive. Not Available in ODP.NET, Unmanaged Driver
KeepAliveInterval	Specifies the time interval after an unacknowledged probe before a new probe is sent. Not Available in ODP.NET, Unmanaged Driver
KeepAliveTime	Specifies the idle time before a keepalive probe is sent. Not Available in ODP.NET, Unmanaged Driver
ModuleName	Specifies the module name for the connection
OciCompartment	Gets or sets the Oracle Cloud Identifier (OCID) of the target database's compartment
OciDatabase	Gets or sets the target database's Oracle Cloud Identifier (OCID)
OciIamUrl	Gets or sets the URL end point for getting the database token
OciTenacy	Gets or sets the Oracle Cloud Identifier (OCID) of the IAM user’s cloud tenancy to retrieve the database token
PasswordAuthentication	Sets the connection `PASSWORD_AUTH` parameter value
PDBName	Used to set and get the name of the pluggable database to which the session is connected to
ProviderVersion	Specifies the ODP.NET assembly version
ServerVersion	Specifies the version number of the Oracle database to which the `OracleConnection` has established a connection
ServiceName	Specifies the name of the service to which the connection is set
`Site`	Inherited from `System.ComponentModel.Component`
SqlNetAuthenticationServices	Enables one or more authentication services, such as TCP/IP with SSL.
State	Specifies the current state of the connection
StatementCacheSize	Specifies the current size of the statement cache associated with this connection
SwitchedConnection	If the returned pooled connection changed its service name (`ServiceName`) or pluggable database (`PDBName`) in order to connect to the desired pluggable database, then this property will consider the connection switched.
TnsAdmin	Specifies the directory location of `tnsnames.ora` or `sqlnet.ora`, or both Not Available in ODP.NET, Unmanaged Driver
TokenAuthentication	Sets the value for `TOKEN_AUTH` parameter for the connection
TokenLocation	Gets or sets the token location path for the connection where the signature token and private key files are located
UseHourOffsetForUnsupportedTimezone	Specifies whether the hour offset can be used for the session time zone, when the Oracle time zone region name that is associated with the .NET locale is not supported by the Oracle database being used Not Available in ODP.NET, Unmanaged Driver
WalletLocation	Specifies the location of wallets. Wallets are certificates, keys, and trustpoints processed by SSL/TLS Not Available in ODP.NET, Unmanaged Driver