Skip to content

[source-oracle] Old version of oracle client. #44559

Open
@slords

Description

@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

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions