connect to Oracle from Macbook with M1 Max processor

[explorercpp]

1. What versions are you using?
   python 3.9.6.

3. Is it an error or a hang or a crash?
   error
4. What error(s) or behavior you are seeing?
   Tried to create a python script to connect to remote Oracle 19 server. instant client has no special build for MacOS with "silicon" processor, such as M1 Max.

line 5, in <module>
    oracledb.init_oracle_client()
  File "src/oracledb/impl/thick/utils.pyx", line 458, in oracledb.thick_impl.init_oracle_client
  File "src/oracledb/impl/thick/utils.pyx", line 482, in oracledb.thick_impl.init_oracle_client
  File "src/oracledb/impl/thick/utils.pyx", line 403, in oracledb.thick_impl._raise_from_info
oracledb.exceptions.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "dlopen(libclntsh.dylib, 0x0001): tried: 'libclntsh.dylib' (**mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64')**), '/System/Volumes/Preboot/Cryptexes/OSlibclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib' (no such file, not in dyld cache), 'libclntsh.dylib' (mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64')), '/usr/local/lib/libclntsh.dylib' (no such file), '/usr/lib/libclntsh.dylib' (no such file, not in dyld cache)". See https://python-oracledb.readthedocs.io/en//latest/user_guide/initialization.html#setting-the-oracle-client-library-directory for help

Thin client did not connect with following error.

connection = oracledb.connect(dsn) File "/Users/xxxx/Library/Python/3.9/lib/python/site-packages/oracledb/connection.py", line 1008, in connect return conn_class(dsn=dsn, pool=pool, params=params, **kwargs) File "/Users/xxxx/Library/Python/3.9/lib/python/site-packages/oracledb/connection.py", line 130, in __init__ impl.connect(params_impl) File "src/oracledb/impl/thin/connection.pyx", line 314, in oracledb.thin_impl.ThinConnImpl.connect File "src/oracledb/impl/thin/connection.pyx", line 202, in oracledb.thin_impl.ThinConnImpl._connect_with_params File "src/oracledb/impl/thin/connection.pyx", line 173, in oracledb.thin_impl.ThinConnImpl._connect_with_description File "src/oracledb/impl/thin/connection.pyx", line 107, in oracledb.thin_impl.ThinConnImpl._connect_with_address File "/Users/xxxx/Library/Python/3.9/lib/python/site-packages/oracledb/errors.py", line 118, in _raise_err raise exc_type(_Error(message)) from cause oracledb.exceptions.OperationalError: DPY-6005: cannot connect to database. [Errno 8] nodename nor servname provided, or not known

<!-

Cut and paste text showing the command you ran. No screenshots.

Use a gist for long screen output and logs: see https://gist.github.com/

-->

5. Does your application call init_oracle_client()?
   yes, and thin client no, I tried both versions from your doc portal

6. Include a runnable Python script that shows the problem.
   used the one from your examples in docs, just changed the value to my credentials

[anthony-tuininga]

The error provided tells you that the host name you provided is invalid. This is not a bug! Correct the host name and you should be able to connect. If you can provide the connect string you used we might be able to help further.

[mareksm]

You need to either switch to Thin mode driver or use Rosetta from terminal (arch -x86_64 zsh).

[explorercpp]

You were right, it is not a bug. Thin client worked eventually. Instant client had issues with rosetta for remote connection. Probably privilege issues. Thank you.

[cjbj]

@explorercpp Instant Client 23.3 for macOS ARM is available https://www.oracle.com/database/technologies/instant-client/macos-arm64-downloads.html