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
