[source-oracle] Old version of oracle client.

[slords]

Connector Name

source-oracle

Connector Version

0.5.2

What step the error happened?

Configuring a new connector

Relevant information

Oracle has implemented stronger encryption on the client and requires drivers that are at least 19.12 or newer. The current driver that is being used is 19.7.0.0. This makes is so when connecting to a database that has sqlnet.allow_weak_crypto_clients = false you receive a ORA-12269 error. The only way to resolve this is to upgrade the client to a supported version.

$ oerr ora 12269 12269, 00000, "client uses weak encryption/crypto-checksumming version" // *Cause: Encryption/crypto-checksumming version used by client is not // supported by server configuration. // *Action: Upgrade the client to use stronger version of the encryption and // crypto-checksumming adapter. If support for weaker version is // needed, add the following to sqlnet.ora file to allow connections // to weak clients: // sqlnet.allow_weak_crypto_clients = true // // CAUTION: This parameter allows insecure network connections between // a client and server. Hence, it must not be used unless the client // cannot be updated to run stronger version of the encryption and // crypto-checksumming adapter. User is strongly advised to consider // the implications of this parameter before configuring it to allow // weak connections.

Relevant log output

2024-08-22 18:44:45 platform > Check connection job received output: io.airbyte.config.StandardCheckConnectionOutput@54e14378[status=failed,message=State code: 64000; Error code: 1226; Message: Oracle Error ORA-12269,additionalProperties={}]

Contribute

• [ ] Yes, I want to contribute