Oracle
Supported databases
This connector uses the Oracle JDBC Thin Driver (ojdbc8) and supports:
Supported Oracle versions
- Oracle Database 12c Release 2 (12.2) and newer
- Oracle Database 18c
- Oracle Database 19c (Long Term Support)
- Oracle Database 21c
- Oracle Database 23c
Supported Oracle editions
- Oracle Enterprise Edition
- Oracle Standard Edition
- Oracle Standard Edition 2
- Oracle Express Edition (XE)
Supported deployment types
- On-premise Oracle Database
- Oracle Cloud Infrastructure (OCI)
- Oracle Autonomous Database (ATP / ADW)
- Oracle databases running in virtual machines or containers
Required connection parameters
Users must provide:
- Host – database server hostname or IP address
- Port – default:
1521 - Service name (recommended) or SID
- Username
- Password
Note: Service name is strongly recommended for Oracle 12c and newer.
Supported connection features
- Oracle RAC (using service name–based connections)
- Pluggable Databases (PDBs)
- Container Databases (CDBs)
- SYS and non-SYS users (subject to permissions)
Not supported
- Oracle Database versions older than 12c
- TNS alias resolution using
tnsnames.ora - OS authentication (external users)
- Kerberos authentication
- Wallet-only authentication without username/password
- Bequeath or shared memory connections
Authentication limitations
The connector supports username/password authentication only.
The following authentication methods are not supported:
- Oracle Wallet–only authentication
- OCI IAM token authentication
- Kerberos / Active Directory authentication
If such mechanisms are required, credentials must be resolved outside the application and provided as a username and password.
Notes
- This application uses thin JDBC connections over TCP/IP only.
- Easy Connect and Easy Connect Plus formats are supported internally.
- Firewall rules must allow access to the configured host and port.