Skip to main content

ArpeOracle — Compatibility

Which Oracle versions, cloud services, auth methods, and client platforms ArpeOracle is known to work with. The support states used across the Arpeio driver family:

StateMeaning
✅ ValidatedVerified directly against a live server or service.
🟢 SupportedExpected to work and covered by the same protocol surface, but not run continuously. Report issues and they will be treated as bugs.
🟡 Not yet validatedShould be compatible on protocol grounds, but unverified. No promise yet.
❌ Not supportedRefused by the driver.

ArpeOracle speaks TNS (Oracle Net) + TTC (Two-Task Common) natively over TCP (+ optional TCPS/TLS or Native Network Encryption). The primary target is Oracle 19c and Oracle Cloud Autonomous Database; the type mapping is in Data types.


Oracle Database (on-premises / IaaS)​

VersionStateNotes
Oracle 19c✅ ValidatedPrimary target. Password, TLS, NNE, OCI IAM token, OAuth2/Entra all verified live.
Oracle 18c✅ ValidatedType-matrix round-trip verified live (18c XE).
Oracle 12c✅ ValidatedType-matrix round-trip verified live (Enterprise 12.2.0.1), including the 12c O5LOGON password verifier.
Oracle 21c✅ ValidatedType-matrix round-trip verified live (21c XE).
Oracle 23ai✅ ValidatedType-matrix round-trip verified live. Native BOOLEAN, JSON, and VECTOR column types decode and round-trip.
Oracle 26ai (23.26)✅ ValidatedOracle's rebrand of 23ai — same protocol family; full type-matrix and native BOOLEAN/JSON/VECTOR verified live.
Oracle 11g and older❌ Not supportedRefused at connect with a clear "Oracle 12.1 or later is required" error. Oracle 12.1 is the minimum.

Oracle Spatial (MDSYS.SDO_GEOMETRY, on 19c EE + Spatial) is ✅ Validated end to end: an SDO_GEOMETRY column reads as geoarrow.wkb, and a geoarrow.wkb column ingests back as SDO_GEOMETRY — SRID included. See Data types for the supported geometry kinds (read handles point / line / single-ring polygon, 2D, 3D, measured and 4D; write additionally supports interior rings and the multi-part kinds).

There is no z/OS / mainframe Oracle edition — that concept is specific to the Db2/DRDA sibling (ArpeDb2) and does not apply to Oracle.

19c is the primary target; 12c, 18c, 21c, 23ai, and 26ai are all validated live — the type-matrix round-trip passes on each.


Oracle Cloud​

ServiceStateAuthNotes
Autonomous Database (ADB)✅ Validatedpassword, OCI IAM token, OAuth2/EntraVerified live over mutual TLS with the downloaded instance wallet (ewallet.pem). Use a _low/_tp/… service on port 1522 and ssl_mode=verify-full.

ADB requires mutual TLS — pair every ADB connection with the wallet (wallet_location + wallet_password). See Connection.


Authentication methods​

All verified live (on-prem 19c and/or Autonomous Database):

MethodStateNotes
Password (O5LOGON, 12c PBKDF2-HMAC-SHA512 and 11g SHA-1 verifiers)✅ ValidatedPassword never crosses the wire in clear, even without TLS.
Proxy authentication (CONNECT THROUGH)✅ ValidatedRides the O5LOGON login, no extra round trip.
Change-password-at-connect✅ ValidatedThe way in past an expired password.
OCI IAM database token✅ ValidatedOracle Cloud; token + RSA proof-of-possession signature.
OAuth2 / Microsoft Entra ID bearer token✅ ValidatedGlobal user resolved from the token's upn claim.
TLS (TCPS), incl. downloaded ADB wallet✅ Validatedrequire / verify-ca / verify-full; mutual TLS with wallets.
Native Network Encryption (AES-256 + SHA-256/SHA-1)✅ ValidatedNo TCPS required; connects a SQLNET.ENCRYPTION_SERVER=REQUIRED server.

Not implemented: NTS/NTLM and Windows integrated authentication (SSPI). See Authentication.


Client platforms​

PlatformStateNotes
Linux x64✅ ValidatedPrimary platform. The released .so is self-contained and runs on RHEL 8 / Rocky 8 and newer.
Windows x64🟢 SupportedPassword/O5LOGON, TLS, OCI IAM token, and OAuth2/Entra all work. The released win-x64 .dll is self-contained.
macOS—No released binary.

ADBC conformance​

ArpeOracle implements the ADBC 1.1.0 surface: query, prepared statements + bound parameters, DML/DDL update, transactions (commit/rollback + autocommit), bulk ingest, LOB streaming, query cancellation, and catalog/metadata (GetInfo, GetObjects, GetTableSchema, GetTableTypes, GetStatistics, GetStatisticNames).

ExecuteSchema returns a query's result schema without running it (queries only, without bound parameters). Other statements, a statement with Bind/BindStream data, or a query the server describes without a column list return NOT_IMPLEMENTED, so the caller can fall back to executing the query. Without an explicit arpeoracle.sdo.srid, an SDO_GEOMETRY column's CRS is not part of the described schema (ExecuteQuery takes it from the first fetched row).

A bound stream (BindStream) runs an INSERT/UPDATE/DELETE/MERGE or PL/SQL statement once per batch, each batch array-bound like Bind, and adds up the row counts; a query with a bound stream returns NOT_IMPLEMENTED (bind its parameters with Bind). Since v0.3.12; before that a bound stream was ignored on ordinary statements.

GetStatistics (since v0.3.12): with approximate it reports Oracle's optimizer statistics (row count, null count, distinct count, average column width, as DBMS_STATS last gathered them), so a table that has never been analyzed has none and nothing is scanned; without approximate it counts every matching table exactly (one COUNT scan per table).

GetParameterSchema (since v0.3.12) returns one field per distinct bind placeholder, in order of first appearance and named as Oracle resolves it (:a and :A are one placeholder), each with the null type: Oracle does not describe bind types. It reads the statement text, so it needs no round trip.

Partitioned execution and Substrait plans are not supported.

See also​