OracleConfiguration Members
OracleConfiguration members are listed in the following tables.
OracleConfiguration Methods
OracleConfiguration methods are listed in Table 6-26.
Table 26 OracleConfiguration Methods
| Method | Description |
|---|---|
| DisableConnectionStringAllowedProperties | Disables connection configuration restriction Not available in ODP.NET, Unmanaged Driver |
| EnableConnectionStringAllowedProperties | Accepts an allowed connection configuration parameter list (Overloaded) Not available in ODP.NET, Unmanaged Driver |
OracleConfiguration Connection Properties
OracleConfiguration Connection properties are listed in Table 6-27.
Table 27 OracleConfiguration Connection Properties
| Property | Description |
|---|---|
| ConfigurationProviders | Enables one or more centralized configuration providers Not available in ODP.NET, Unmanaged Driver |
| DatabaseCharset | Sets the Not available in ODP.NET, Unmanaged Driver |
| DatabaseNCharset | Sets the Not available in ODP.NET, Unmanaged Driver |
| DatabaseEditionName | Specifies the Oracle edition name for the connection object |
| DefaultSDUSize | Specifies the session data unit size (SDU) for Oracle networking communication between client and server |
| DisableOOB | Specifies whether to enable Oracle Net Services to send or receive out-of-band break messages using urgent data provided by the underlying protocol |
| DrcpConnectionClass | Specifies a logical name that identifies the DRCP connection pool that the ODP.NET connection will use |
| HostnameDefaultServiceIsHost | Specifies whether to default the service name to the hostname in Oracle Easy Connect Naming so that the service name does not need to be specified |
| NamesDirectoryPath | Specifies the naming method order used for client name resolution lookups |
| OciCompartment | Gets or sets the Oracle Cloud Identifier (OCID) of the target database’s compartment at the process level |
| OciConfigurationFile | Gets or sets the configuration file location at the process level where the OCI token authentication values can be found. Not available in ODP.NET, Unmanaged Driver |
| OciDatabase | Gets or sets the target database’s Oracle Cloud Identifier (OCID) at the process level |
| OciIamUrl | Gets or sets the URL end point at the process level for getting the database token |
| OciProfile | Gets or sets the OCI profile at the process level to use from the token authentication configuration file. Not available in ODP.NET, Unmanaged Driver |
| OciTenacy | Gets or sets the Oracle Cloud Identifier (OCID) of the IAM user’s cloud tenancy at the process level for retrieving the database token |
| OracleDataSources | Returns a collection of TNS entries added through OracleConfiguration |
| SuppressGetDecimalInvalidCastException | Specifies whether to suppress the Not available in ODP.NET, Unmanaged Driver |
| TAFUsePooledConnections | Indicates whether to use pre-existing connections from the pool for failover Not available in ODP.NET, Unmanaged Driver |
| TcpConnectTimeout | Specifies the time, in seconds, for a client to establish a TCP connection (PROTOCOL=tcp in the TNS connect address) to the database server before it can time out |
| TimeZoneFileLocation | Specifies the time zone file directory |
| TnsAdmin | Specifies the tnsnames.ora and/or sqlnet.ora directory location |
| UseSNI | Specifies whether to use Server Name Indication (SNI) Not Available in ODP.NET, Unmanaged Driver |
OracleConfiguration Secure Connection Properties
OracleConfiguration Secure Connection Properties are listed in Table 6-28.
Table 28 OracleConfiguration Secure Connection Properties
| Property | Description |
|---|---|
| AllowRelativePathForDllPath | Determines whether to allow relative directory paths for loading unmanaged ODP.NET dependencies. Only available in ODP.NET, Unmanaged Driver |
| AllowRelativePaths | Determines whether relative directory paths can be used in any ODP.NET configuration. Not available in ODP.NET, Unmanaged Driver |
| AllowUncPathForDllPath | Determines whether Universal Naming Convention directory paths can be used for loading unmanaged ODP.NET dependencies. Only available in ODP.NET, Unmanaged Driver |
| AllowUncPaths | Allows or disallows ODP.NET access to configuration files with Universal Naming Convention location paths Not available in ODP.NET, Unmanaged Driver |
| PasswordAuthentication | Sets the process level PASSWORD_AUTH parameter value |
| SEPSWalletLocation | Specifies the Secure External Password Store wallet location, typically used for PKCS #12 wallet files |
| SEPSWalletPassword | Stores the password to decrypt the PKCS #12 wallet located in the Secure External Password Store |
| SqlNetAllowWeakCrypto | Allows or disallows weaker encryption and checksum algorithms for database connections |
| SqlNetAllowedLogonVersionClient | Specifies the minimum authentication protocol that is to be used when authenticating against the Oracle database for a given application |
| SqlNetAuthenticationServices | Enables one or more authentication services, such as TCP/IP with SSL |
| SqlNetCloudUser | Specifies an user name for web server HTTP basic authentication |
| SqlNetCryptoChecksumClient | Specifies the checksum client behavior |
| SqlNetCryptoChecksumTypesClient | Specifies the crypto-checksum algorithms the client can use |
| SqlNetEncryptionClient | Specifies the encryption client behavior |
| SqlNetEncryptionTypesClient | Specifies encryption algorithms that the client can use |
| SqlNetIgnoreANOEncrytionForTCPS | Specifies whether to disable double encryption and double checksumming under certain conditions Not available in ODP.NET, Unmanaged Driver |
| SqlNetWalletOverride | Specifies whether the client overrides the strong authentication credential with the stored wallet password credential for the database connection |
| SqlNetURI | Specifies the WebSocket universal resource identifier |
| SSLCertificateThumbprint | Specifies the TLS/SSL certificate thumbprint in the certificate store for the ODP.NET connection to use |
| SSLServerDNMatch | Enforces the database server distinguished name (DN) matches its service name |
| SSLVersion | Enforces the connection to use a specific SSL/TLS version |
| TLSExcludeVersion | Indicates which SSL/TLS versions connections should not be enabled for Not available in ODP.NET, Unmanaged Driver |
| TLSVersion | Enforces the connection to use a specific SSL/TLS version Not available in ODP.NET, Unmanaged Driver |
| TokenAuthentication | Sets the value for TOKEN_AUTH parameter at the process level |
| TokenLocation | Gets or sets the token location directory at the process level where the access token , or database token and private key files, are present for ODP.NET token authentication. |
| UseMITKerberos | Specifies whether to use MIT Kerberos or Kerberos.NET Only available in ODP.NET, Managed Driver |
| WalletLocation | Specifies the location of wallets |
| WalletPassword | Stores the password to decrypt the PKCS #12 wallet Not available in ODP.NET, Unmanaged Driver |
OracleConfiguration Command Properties
OracleConfiguration Command properties are listed in Table 6-29.
Table 29 OracleConfiguration Command Properties
| Property | Description |
|---|---|
| AddOracleTypesDeserialization | Adds ODP.NET-specific data types to the “allow” list to permit deserialization into DataSet or DataTable |
| BindByName | Specifies whether the binding method used for the parameter collection is by name or by position |
| CommandTimeout | Specifies the number of seconds the command is allowed to execute before terminating the execution with an exception |
| GetDecimalRetainTrailingZeros | Specifies whether to retain trailing zeros from an Oracle NUMBER in a .NET Decimal |
| MapVectorColumnAsClob | Specifies whether to retrieve vector types as native vectors or Not available in ODP.NET, Unmanaged Driver |
| ProviderTypeNLSSensitiveToString | Specifies whether to honor the data type's NLS format when the Not available in ODP.NET, Unmanaged Driver |
| TransactionPriority | Specifies the ODP.NET instance's transaction priority level Not available in ODP.NET, Unmanaged Driver |
| UseClientInitiatedCQN | Specifies whether to use Client Initiated Continuous Query Notification (CICQN) or traditional Continuous Query Notification (CQN) that does not rely on a persistent connection |
OracleConfiguration Directories Properties
OracleConfiguration Directories properties are listed in Table 6-30.
Table 30 OracleConfiguration Directories Properties
| Property | Description |
|---|---|
| DefaultAdminContext | Specifies the default directory entry that contains a LDAP Oracle Context from which connect identifiers can be created, modified, or looked up |
| DirectoryServers | Lists the host names and port numbers of the primary and alternate LDAP directory servers |
| DirectoryServerType | Specifies the directory server type used, such as Oracle Internet Directory or Microsoft Active Directory |
| LdapAdmin | Specifies the ldap.ora directory location |
| NamesLdapAuthenticateBind | Specifies whether the LDAP naming adapter should attempt to authenticate using a specified wallet when it connects to the LDAP directory to resolve the name in the connect string |
| NamesLdapAuthenticateBindMethod | Specifies the authentication method the client LDAP naming adapter should use while connecting to the LDAP directory to resolve connect string names |
| NamesLdapConnTimeout | specifies the non-blocking connection timeout to the LDAP server |
OracleConfiguration High Availability Properties
OracleConfiguration High Availability properties are listed in Table 6-31.
Table 31 OracleConfiguration High Availability Properties
| Property | Description |
|---|---|
| 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 |
| DbNotificationAddress | Specifies the address that the provider listens to for all notifications sent by the database for continuous query notification feature. |
| DbNotificationPort | Specifies the port number that the provider listens to for all notifications sent by the database for continuous query notification, Fast Connection Failover, and/or Runtime Connection Load Balancing features |
| DistributedTransactionRecoveryAddress | Specifies the machine name or IP address the OraMTS recovery service runs on to resolve database in-doubt transactions |
| DistributedTransactionRecoveryPort | Specifies the port the OraMTS recovery service listens on to resolve database in-doubt transactions |
| DistributedTransactionTimeToLive | Specifies the time the transaction can remain inactive after it has been detached or delisted from the database |
| HAEvents | Enables the application to receive Fast Connection Failover events for maintaining application high availability |
| MaxCallsPerRequestBoundary | Specifies the maximum request size, or ODP.NET calls, beyond which Application Continuity replay will be disabled |
| OnsConfigFile | Specifies the configuration file to define Oracle Notification Service (ONS) behavior |
| OnsMode | Specifies the ONS daemon mode as either local or remote |
| OnsProtocol | Defines whether the ONS connection uses TCP/IP or TCP/IP with SSL/TLS |
| OnsWalletLocation | Specifies the directory location of the ONS wallets |
| OracleOnsServers | Returns a collection of logical ONS servers added through OracleConfiguration |
| ServiceRelocationConnectionTimeout | Specifies the time to wait before retrying connecting to a service that becomes unavailable. |
OracleConfiguration Performance Properties
OracleConfiguration Performance properties are listed in Table 6-32.
Table 32 OracleConfiguration Performance Properties
| Property | Description |
|---|---|
| FetchSize | Specifies the total memory size, in bytes, that the provider allocates to cache data fetched in one database round-trip |
| LoadBalancing | Enables the application to receive runtime connection load balancing information |
| MaxStatementCacheSize | Specifies the maximum number of statements that can be cached when self-tuning is enabled |
| Pipelining | Enables asynchronous execution on the database server side |
| PerformanceCounters | Specifies the ODP.NET connection performance counters to publish so that they can be monitored |
| ReceiveBufferSize | Specifies the buffer space limit for receive operations of sessions |
| RowsToFetchPerRoundTrip | Specifies the total number of rows to retrieve per database round trip Not Available in ODP.NET, Unmanaged Driver |
| SelfTuning | Specifies whether self-tuning is enabled for an ODP.NET application |
| SendBufferSize | Specifies the buffer space limit for send operations of sessions |
| StatementCacheSize | Specifies the number of cursors or statements to be cached for each database connection |
| TcpNoDelay | Preempts delays in buffer flushing within the TCP/IP protocol stack |
OracleConfiguration Diagnostics and Tracing Properties
OracleConfiguration Diagnostics and Tracing properties are listed in Table 6-33.
Table 33 OracleConfiguration Diagnostics and Tracing Properties
| Property | Description |
|---|---|
| ConnectionIdPrefix | Identifies a particular application's connections by appending its string to the connection identifier Not Available in ODP.NET, Unmanaged Driver |
| DatabaseOpenTelemetryTracing | Enables database OpenTelemetry span instrumentation for ODP.NET public APIs that perform a database round-trip Not Available in ODP.NET, Unmanaged Driver |
| MetricsLevel | Sets the Not Available in ODP.NET, Unmanaged Driver |
| OpenTelemetrySemconvStabilityOptIn | Sets whether ODP.NET OpenTelemetry traces use deprecated tags, new er tags, or both sets of tags |
| OpenTelemetryTracing | Specifies whether to dynamically enable or disable ODP.NET OpenTelemetry tracing instrumentation or not. Not Available in ODP.NET, Unmanaged Driver |
| PoolNames | Specifies a string to identify the monitored connection pool more easily |
| Program | Specifies the application program name Not available in ODP.NET, Unmanaged Driver |
| SuppressErrorURL | Shows or suppresses the Oracle Database Error Messages URL for the specific error with more information on its cause and resolution |
| TraceFileLocation | Specifies the destination directory to output provider traces |
| TraceFileMaxSize | Specifies the maximum file size of each trace file |
| TraceLevel | Specifies the generated trace level to trace ODP.NET calls and diagnose provider issues |
| TraceOption | Specifies whether to generate a single trace file or multiple trace files for multithreaded applications |