In order to set the environment variable, you can follow this procedure [0]
Regarding the Oracle client version, It is either oci-19-8 or oci-19-11 [1], but I would say that both has to work the same way. [0] https://www.howtogeek.com/787217/how-to-edit-environment-variables-on-windows-10-or-11/ [1] http://download.osgeo.org/osgeo4w/v2/x86_64/release/oci/ Regards, Julien > Yes I have also tried using the tnsnames.ora alternative, byut in that case I > have a doubt about where to set the TNS_ADMIN, in case of a > standard Win 11 QGis installation. Could you suggest ? Also, what is the > Oracle client / version used by QGis? Thanks > > Il giorno lun 13 nov 2023 alle ore 10:33 Julien Cabieces via QGIS-User > <qgis-user@lists.osgeo.org> ha scritto: > > Hi, > > Did you try to use a tnsnames.ora file ? > > You can then set the environment variable TNS_ADMIN to point to the > directory which contains the file and then refer to the connexion in > QGIS with the "database name" (dbname in QGIS uri), no host and port > specified. > > I have no expertise in configuring the tnsnames.ora file, but when I > have to face complicated connexion, I generally ask for tnsnames.ora and > go this way to make it work. > > Regards, > Julien > > > Hi, > > > > I have to connect to Oracle DBs for my work with a "proxy" user (security > requirements) and I normally make it with SQLDeveloper, > setting it up > > like: > > > > username: MY_USER[DB_USER] > > password: << MY_USER password >> > > connection type: Base > > host: << DB host address >> > > port: << DB port >> > > service: << DB service name >> > > > > where MY_USER is my personal user, while DB_USER is the name of the schema > where DB tables are present. The DB is an Oracle 12g and > is > > v21, but in order to make this work I had to setup SQLDeveloper > preferences so to use an external Oracle client (instantclient) and the > > Thick/OCI driver. Also, compatibility with the oracle client needs to be > taken care of. I use the Oracle instant client 21.11 and > SQLDeveloper > > 21.4.1. > > > > I'm trying to replicate such an Oracle connection in QGIS, but simply > setting up the connection details as above, it fails with: > > > > ORA-01017 invalid username/password > > > > I've searched a lot already and tried some variations in the QGIS > connection setup, but I haven't been able to solve my problem. Oracle > proxy > > user connection doesn't seem to be supported in QGIS, does it? > > > > Can someone here help me? > > thanks in advance > > Fabio > > > > _______________________________________________ > > QGIS-User mailing list > > QGIS-User@lists.osgeo.org > > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user > > -- > > Julien Cabieces > Senior Developer at Oslandia > julien.cabie...@oslandia.com > _______________________________________________ > QGIS-User mailing list > QGIS-User@lists.osgeo.org > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user -- Julien Cabieces Senior Developer at Oslandia julien.cabie...@oslandia.com _______________________________________________ QGIS-User mailing list QGIS-User@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user