Open

This method opens a connection to an Oracle database.

Declaration

// C#
public overide void Open();

Implements

IDbConnection

Exceptions

ObjectDisposedException - The object is already disposed.

InvalidOperationException - The connection is already opened or the connection string is null or empty.

OracleException – For token authentication, errors include "ORA-25707: The token is invalid.", "ORA-25708: The token has expired.", and "ORA-50109: Configuration for token-based authentication is invalid."

Remarks

The connection is obtained from the pool if connection pooling is enabled. Otherwise, a new connection is established.

It is possible that the pool does not contain any unused connections when the Open() method is invoked. In this case, a new connection is established.

If no connections are available within the specified connection timeout value, when the Max Pool Size is reached, an OracleException is thrown.

For client-side validation of an access token:

The access token must be 16KB bytes or less.
There needs to be two periods, ".".
It must be valid base 64.
It must be valid JSON.
There must be "sub" and "exp" claims.

The opened connection will have same AutoCommit property value as set by the application.

If the opened connection enlists in a distributed transaction, auto-commit will be disabled regardless of the AutoCommit value. Once that transaction completes, auto-commit functionality resets to the AutoCommit value.

The opened connection has the same IsolationLevel value as set by the application. If that connection enlists in a distributed transaction created using TransactionScope, then the application’s IsolationLevel value is overridden. The connection object’s IsolationLevel remains overridden once that transaction is over.