This is the error I am getting from RStudio (and R, run using sudo):

> odbc::dbConnect(odbc::odbc(), driver = "/opt/oracle/instantclient_23_4/libsqora.so.23.1")
Error: nanodbc/nanodbc.cpp:1138: 00000
[unixODBC][Driver Manager]Can't open lib '/opt/oracle/instantclient_23_4/libsqora.so.23.1' : file not found 

Running isql with the DSN leads to:

[28000][unixODBC][Oracle][ODBC][Ora]ORA-01017: invalid username/password; logon denied

So maybe the problem lies in the R odbc package?

Session info:

R version 4.4.0 (2024-04-24)
Platform: x86_64-pc-linux-gnu
Running under: Ubuntu 22.04.4 LTS

other attached packages:
[1] odbc_1.4.2 DBI_1.2.2 

libsqora is set with permissions 777:

ls -l /opt/oracle/instantclient_23_4/libsqora.so.23.1
-rwxrwxrwx 1 rdpdp rdpdp 802848 Apr 25 01:38 /opt/oracle/instantclient_23_4/libsqora.so.23.1

and:

odbcinst --version
unixODBC 2.3.9