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 >
_______________________________________________ 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