Using Thin Mode in MacOS throws Error

[pythonic-shk]

1. What versions are you using?

python 3.11.9
Oracledb 3.3.0
Macos Sequoia

Give your Oracle Database version, e.g.:

Oracle 23.9.0.25.08

Give your Oracle Client version (if you are using Thick mode):

print(oracledb.clientversion())
Using Thin mode

Also run Python and show the output of:

import sys
import platform

print("platform.platform:", platform.platform())
print("sys.maxsize > 2**32:", sys.maxsize > 2**32)
print("platform.python_version:", platform.python_version())

platform.platform: macOS-15.6.1-arm64-arm-64bit
sys.maxsize > 2**32: True
platform.python_version: 3.11.9

And:

print("oracledb.__version__:", oracledb.__version__)

oracledb.version: 3.3.0

2. Is it an error or a hang or a crash?

Error

3. What error(s) or behavior you are seeing?

Traceback (most recent call last):
File "/Users/sshafikh/cessearch/Automation/populate_dml_configs.py", line 169, in
main()
File "/Users/sshafikh/cessearch/Automation/populate_dml_configs.py", line 162, in main
connection = connect_to_db(args.env)
^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/sshafikh/cessearch/Automation/populate_dml_configs.py", line 92, in connect_to_db
connection = oracledb.connect(user=user,
^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/sshafikh/cessearch/.venv/lib/python3.11/site-packages/oracledb/connection.py", line 1360, in connect
return conn_class(dsn=dsn, pool=pool, params=params, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
File "/Users/sshafikh/cessearch/.venv/lib/python3.11/site-packages/oracledb/connection.py", line 721, in init
impl.connect(params_impl)
File "src/oracledb/impl/thin/connection.pyx", line 536, in oracledb.thin_impl.ThinConnImpl.connect
File "src/oracledb/impl/thin/connection.pyx", line 532, in oracledb.thin_impl.ThinConnImpl.connect
File "src/oracledb/impl/thin/connection.pyx", line 475, in oracledb.thin_impl.ThinConnImpl._connect_with_params
File "src/oracledb/impl/thin/connection.pyx", line 456, in oracledb.thin_impl.ThinConnImpl._connect_with_description
File "src/oracledb/impl/thin/connection.pyx", line 418, in oracledb.thin_impl.ThinConnImpl._connect_with_address
File "/Users/sshafikh/cessearch/.venv/lib/python3.11/site-packages/oracledb/errors.py", line 199, in _raise_err
raise error.exc_type(error) from cause
oracledb.exceptions.OperationalError: DPY-6005: cannot connect to database (CONNECTION_ID=eoSysA5DBvAQdUCtIsMLRw==).
[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: self-signed certificate in certificate chain (_ssl.c:1006)

4. Does your application call init_oracle_client()?

No

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

import oracledb

oracledb.enable_thin_mode()

    user=os.environ.get('DB_USER')
    password=get_secrets(os.environ.get('DB_SECRET'))
    dsn=os.environ.get('DB_CS_DSN')
       
connection = oracledb.connect(user=user,
                password=password,
                dsn=dsn)
 print("connection established")

[cjbj]

Starting by referring to some relevant Google hits: #161 (comment) or https://stackoverflow.com/a/74867715/4799035

If this doesn't help, share details like the connection string so we can see what options you are passing.

[pythonic-shk]

By providing wallet_location parameter as suggested in https://stackoverflow.com/a/74867715/4799035
worked for me.

But using a wallet for thin client defeats the purpose. I was looking for a way to completely avoid wallet dependency

[cjbj]

@pythonic-shk If this is for ADB, then make sure the instance is set to allow access from Secure access from allowed IPs and VCNs only. See https://python-oracledb.readthedocs.io/en/latest/user_guide/connection_handling.html#one-way-tls-connection-to-oracle-autonomous-database This means you won't need a wallet on the client.