ORA-24960 with macOS (ARM64) client library

[filiabel]

I have issues connecting to my Oracle 19c database using python-oracledb. I develop Node applications on the same machine, and have not had similar issues occuring with node-oracledb. No issues with similar application code on WSL Ubuntu.

The same issue has been discussed on Stack Overflow, but not for the macOS specific case.

1. What versions are you using?

platform.platform: macOS-15.3.1-arm64-arm-64bit
sys.maxsize > 2**32: True
platform.python_version: 3.12.9
oracledb.__version__: 3.0.0

2. Is it an error or a hang or a crash?
   Database error, crashes when calling create_pool.

3. What error(s) or behavior you are seeing?
   DatabaseError: ORA-24960: the attribute OCI_ATTR_PASSWORD is greater than the maximum allowable length of 1024

4. Does your application call init_oracle_client()?
   Yes, I am using thick mode.

5. Include a runnable Python script that shows the problem.

import oracledb

oracledb.init_oracle_client()
pool = oracledb.create_pool(
    user="user",
    password="pw",
    dsn="your-dsn-string",
    min=1,
    max=5,
    increment=1,
)

[cjbj]

What's the exact DB version?

What's your client version?

Is your password actually > 1024 characters?

[filiabel]

Hi @cjbj. Thanks for reaching out.

What's the exact DB version?

Oracle Database 19c Enterprise Edition Release 19.0.0.0.0

What's your client version?

Basic Package v. 23.3.0.23.09 (latest from here)

Is your password actually > 1024 characters?

No, it is not.

The same code is running without problems in a Docker container starting like this:

FROM ghcr.io/oracle/oraclelinux9-python:3.12-20241217

RUN  dnf -y install oracle-instantclient-release-23ai-el9 && \
     dnf -y install oracle-instantclient-basiclite && \
     rm -rf /var/cache/dnf

[cjbj]

I would expect this to be an Oracle Client issue.

[filiabel]

Thanks @cjbj. I just find it odd that the same client library is working for node-oracledb?

[hjamil-24]

I tried with following configuration, and is not reproduced:

platform.platform: macOS-15.3.2-arm64-arm-64bit
sys.maxsize > 2**32: True
platform.python_version: 3.13.2
oracledb.__version__: 3.0.0
Basic Package v. 23.3.0.23.09
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.24.0.0.0

Probably, an exact db version can help us reproduce it.

[filiabel]

Thanks for looking into this, @hjamil-24!

The exact version is Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production Version 19.18.0.0.0.
Sorry for not providing full version previously.