Connecting to Oracle

Name
(Required)

Name of the SQL Server connection, unique in the SKP.

NA

Description

Enter a brief description stating the purpose of this connection.

NA

Hostname
(Required)

Specifies the network address of the Oracle database server. This may be a fully qualified domain name or an IP address. The client uses this value to establish the TCP/IP connection to the Oracle listener.

Supported values:

* Fully qualified domain name, for example, oracle-prod.company.com

* An IP address , for example, 192.168.10.50

* Load balancer name, for example, rac-name.company.com

Username
(Required)

Defines the Oracle database user account used to authenticate the connection.

The account must have the necessary privileges for the operations being performed.

Password
(Required)

The password for the username specified above.

This value is used to authenticate the connection to the database.

Port

Indicates the TCP port on which the Oracle listener is running.

The default port is 1521, but this may vary depending on the server configuration.

Service Name

Represents the logical Oracle service to which the client connects.

The service name identifies the specific database or pluggable database (PDB) within a multitenant environment, for example, ORCL, ORCLPDB1.

Connection Timeout

Defines the maximum amount of time, in seconds, that the system waits for a connection attempt to succeed before failing.

Default value: 60 seconds.

Proxy User

Specifies the Oracle database user on whose behalf the primary user connects. Proxy authentication allows one authenticated user to assume the identity and permissions of another without directly providing that user’s password.

This property is commonly used for:

* Fine-grained auditing

* Centralized authentication with per-user accountability

* Application servers managing user identities.

The primary user must be configured in Oracle with the appropriate GRANT CONNECT THROUGH privilege for the proxy user.

Proxy Password

The password associated with the Proxy User.

This credential is used only when proxy authentication is enabled and required. For external authentication scenarios,for example, Kerberos), this field may be left empty.

Pooling

Connection pooling allows the system to reuse existing database connections instead of creating a new connection for every operation.

This improves performance when queries or updates are executed repeatedly.

Min Pool Size

Defines the minimum number of open connections that the pool always maintains.

* If set to 0, no connections are created until the application requests one.

* Increasing this value ensures a baseline of ready connections for low-latency workloads.

Max Pool Size

Specifies the maximum number of open connections allowed in the pool. Once this threshold is reached, new connection requests will wait until an existing connection is released. This value protects the Oracle server from excessive concurrent connections.

Default value: 100.

Incremental Pool Size

Determines how many new connections are created when the pool needs to grow.

For example, when load increases and the pool must expand, connections are created in batches of this size.

This helps avoid performance degradation during scaling.

Default value: 5.

Decremental Pool Size

Defines how many idle connections are closed during pool shrink operations.

The pool periodically evaluates idle connections and reduces the total by this amount until it reaches the Min Pool Size.

This helps optimize resource usage during low-activity periods.

Default value: 1.

Connection Lifetime

Specifies the maximum lifetime (in seconds) of a pooled connection before it is automatically closed and replaced.

This property helps:

* Prevent use of stale or long-running connections.

* Rotate connections in environments with network policies or firewall idle timeouts.

* Improve long-running stability.

A value of 0 disables lifetime enforcement.