Thanks Julien for your suggestions. I don't think I managed to make it work like that. Is there anyone who has connected QGIS to an Oracle DB with a proxy user?
Il giorno mar 14 nov 2023 alle ore 08:56 Julien Cabieces < julien.cabie...@oslandia.com> ha scritto: > > 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