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

[Fabio Fumi]

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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20231113/9f02b7d6/attachment.htm>