Add Oracle OCI Driver Support for TNS Aliases and Wallet Authentication #1779
Description
Prerequisites
- Search the current open issues
What are you trying to do that currently feels hard or impossible?
Description
Add a new Oracle source that uses the official Oracle OCI driver (godror) to enable connections to Oracle databases that require TNS aliases and wallet-based mutual TLS authentication.
Motivation
The existing oracle source kind uses the go-ora driver (pure Go implementation), which is excellent for simple direct connections but lacks support for:
- TNS aliases from tnsnames.ora
- Oracle Wallet for mutual TLS authentication
- Mutual TLS (mTLS) connections required by Oracle Cloud databases
Use Cases
This feature would enable users to connect to:
- Oracle Autonomous Database - Requires wallet-based mutual TLS authentication
- Oracle Cloud Database services - Often require mutual TLS for secure connections
- TNS-configured deployments - Enterprises using tnsnames.ora for connection management
- Wallet-secured environments - Any Oracle deployment using wallet authentication
Suggested Solution(s)
Add a new oracle-oci source kind that:
- Uses the godror driver (official Oracle driver with full OCI support)
- Supports TNS aliases from tnsnames.ora
- Supports Oracle Wallet authentication for mutual TLS
- Supports all standard connection methods (TNS alias, connection string, host+port+serviceName)
- Requires Oracle Instant Client at runtime
- Uses build tags (
-tags oracleoci) to remain optional and non-breaking
Alternatives Considered
No response
Additional Details
No response