[Qgis-user] Connecting to Oracle Spatial using a proxy user

[Julien Cabieces]

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 at 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 at 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.cabieces at oslandia.com
>  _______________________________________________
>  QGIS-User mailing list
>  QGIS-User at 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.cabieces at oslandia.com