Re: [Qgis-user] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-22 Thread Richard Duivenvoorde via QGIS-User

Hi Fredy,

The oracle oci library needed to connect to Oracle is not free, so not 
available in any Linux distro.
That is the reason that QGIS on Linux is never linked to these libraries, and 
that is why you do not see the Oracle connection in your Data Source Manager.

If you really want this to work on Linux, you have to:
- download the oci/client libraries yourself from Oracle
- build QGIS yourself with instructions where the Oracle libs are etc

Not done this recently, but here is an old blogpost to get the idea:
https://zuidt.nl/blog/html/2015/10/12/build_qgis_master_with_oracle_provider_yourself_on_centos7.html

Depends on your needs and if you are tech savvy enough, if you want to go 
through this hassle.

Which Linux Distro are you on?
I think it is easiest on Debian or Fedora and related distro's

Regards,

Richard Duivenvoorde

On 9/21/23 20:49, Fredy Varon via QGIS-User wrote:

Hi.

I need to configure qgis desktop on Linux enviroment and enable in the explorer 
the opción tio connect to Oracle databases

Please any guise ti do this, un Windows works if before i install Oracle 
client, in Linux i configure the same but dont enable this type of connections 
in qgis

Thanks for any help

Fredy Varón

Obtener Outlook para Android 

___
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


Re: [Qgis-user] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread chris hermansen via QGIS-User
Fredy and list

On Thu, Sep 21, 2023, 19:48 Fredy Varon  wrote:

> Hi chris
>
>
>
> About your questions.
>
>
>
>1. which client are you trying to use? Oracle Database Programming
>interface in C?  JDBC? or... ?
>
> Im trying to use Qgis Desktop 3,22 and 3.28 to Access an Oracle Database
> via OCI (Oracle Call Interface) instaled via Oracle instant client 12c
>
>1. what configuration parameters do you use?
>
> Thats the problema when im install qgis desktop this dont show up the
> option to connect to Oracle
>
> On Windows i see this option on Navigator
>
> But install qgis desktop on Linux enviroment dont permit this option
>
>
>1. what is the error you receive?
>
> I need to install qgis desktop and see the Oracle option to stablish the
> connections to databases that i need to see
>

It looks to me that the QGIS install isn't "aware" of your OCI library.

Possibly a path issue?

Maybe this tutorial would help?

https://freegistutorial.com/how-to-connect-qgis-to-oracle-spatial-database/


Chris

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


Re: [Qgis-user] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread Fredy Varon via QGIS-User
Hi chris

About your questions.


  1.  which client are you trying to use? Oracle Database Programming interface 
in C?  JDBC? or... ?
Im trying to use Qgis Desktop 3,22 and 3.28 to Access an Oracle Database via 
OCI (Oracle Call Interface) instaled via Oracle instant client 12c

  1.  what configuration parameters do you use?
Thats the problema when im install qgis desktop this dont show up the option to 
connect to Oracle
On Windows i see this option on Navigator
[cid:image002.png@01D9ECD5.4A830530]
But install qgis desktop on Linux enviroment dont permit this option
[cid:image005.png@01D9ECD5.4A830530]

  1.  what is the error you receive?
I need to install qgis desktop and see the Oracle option to stablish the 
connections to databases that i need to see.
Thanks for your help

___
FREDY VARON GARCIA
Ing Sistemas

De: chris hermansen<mailto:clherman...@gmail.com>
Enviado: jueves, 21 de septiembre de 2023 1:59 p. m.
Para: fredy varon<mailto:fredyva...@outlook.com>
CC: qgis-user@lists.osgeo.org<mailto:qgis-user@lists.osgeo.org>
Asunto: Re: [Qgis-user] Config qgis desktop on Linux to DISPLAY Oracle 
connections

Fredy and list,

On Thu, Sep 21, 2023 at 11:50 AM Fredy Varon via QGIS-User 
mailto:qgis-user@lists.osgeo.org>> wrote:
Hi.

I need to configure qgis desktop on Linux enviroment and enable in the explorer 
the opción tio connect to Oracle databases

Please any guise ti do this, un Windows works if before i install Oracle 
client, in Linux i configure the same but dont enable this type of connections 
in qgis

Fredy, please provide more details on how you configure the Oracle client in 
Linux and what happens:

  1.  which client are you trying to use? Oracle Database Programming interface 
in C?  JDBC? or... ?
  2.  what configuration parameters do you use?
  3.  what is the error you receive?


--
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.

___
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


Re: [Qgis-user] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread chris hermansen via QGIS-User
Fredy and list,

On Thu, Sep 21, 2023 at 11:50 AM Fredy Varon via QGIS-User <
qgis-user@lists.osgeo.org> wrote:

> Hi.
>
> I need to configure qgis desktop on Linux enviroment and enable in the
> explorer the opción tio connect to Oracle databases
>
> Please any guise ti do this, un Windows works if before i install Oracle
> client, in Linux i configure the same but dont enable this type of
> connections in qgis
>
> Fredy, please provide more details on how you configure the Oracle client
in Linux and what happens:

   1. which client are you trying to use? Oracle Database Programming
   interface in C?  JDBC? or... ?
   2. what configuration parameters do you use?
   3. what is the error you receive?



-- 
Chris Hermansen · clhermansen "at" gmail "dot" com

C'est ma façon de parler.
___
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] Config qgis desktop on Linux to DISPLAY Oracle connections

2023-09-21 Thread Fredy Varon via QGIS-User
Hi.

I need to configure qgis desktop on Linux enviroment and enable in the explorer 
the opción tio connect to Oracle databases

Please any guise ti do this, un Windows works if before i install Oracle 
client, in Linux i configure the same but dont enable this type of connections 
in qgis

Thanks for any help

Fredy Varón

Obtener Outlook para Android
___
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