[Qgis-user] Missing Oracle connectivity on QGIS Browser

[Tudorache, Marian]

Hi Jürgen/Andreas,

I think you misunderstood my issue.
First let's be clear.
There is no issue with Oracle connectivity from Linux.
The oracle client runs properly and I am able to access oracle database using wither sqlplus or SQL developer interface.


The issue is when I am trying to add a vector layer using SDO data from an Oracle spatial database: there is not Oracle connectivity icon on QGIS under Linux Red Hat.
I only have connectivity to the fowling database types:
- MSSQL;
- OGDI Vectors;
- PostGIS;
- SpatiaLite;

As alternative way I have tried Add Vector Layer/Source Type Database.
On the database type the dropdown list gave those options:

- ODBC;
- ESRI Personal Geodatabase;
- MSSQL;
- OGDI Vectors;
- PostgreSQL;
- MySQL

So again no Oracle option.

But I said let's try ODBC to see if I can use it to pull Oracle spatial data. So this option does not work either.

I have tried to use GDAL/OGR's OCI driver so I had a look here: http://www.gdal.org/index.html I have installed but how can be used?

The only clear document is this: http://www.igismap.com/connect-qgis-oracle-spatial-quantum-gis/
But since I do not have Oracle spatial as the tutorial says I can't use it.

Do you know where I have learn how to connect to oracle using GDAL/OGR?

Thanks,
Marian





When I tested QGIS on Windows 7 there is an Oracle connectivity icon that I was able to use it without problem.
But our requirements were to use QGIS 2.8 on Linux Red Hat with Oracle spatial.

After I installed QGIS on red hat I observed there is not Oracle connectivity on QGIS as in the windows version.
I have sent an email about this issue a while ago.

Andreas thought the issue is because I do not have installed Oracle Client.

But the this wasn't the issue because I had oracle client installed on the Linux machine

-----Original Message-----
From: qgis-user-bounces at lists.osgeo.org [mailto:qgis-user-bounces at lists.osgeo.org] On Behalf Of Jürgen E. Fischer
Sent: June-26-15 11:26 AM
To: qgis-user at lists.osgeo.org; ottawa_users at lists.osgeo.org
Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser

Hi Marian,

On Fri, 26. Jun 2015 at 09:55:47 -0400, Tudorache, Marian wrote:
> Do you still follows this thread?
> I have tested the oracle client on my machine and it does work.
> I am able to connect to Oracle from a terminal windows using either isql or sqlplus.

Are you aware there is a oracle provider in QGIS.  You don't have to use the OGR provider to access oracle (same as with postgres and mssql).

I've never used Oracle via ODBC on Linux.  From qgis I use the native oracle provider and from the command line GDAL/OGR's OCI driver.


Jürgen

--
Jürgen E. Fischer           norBIT GmbH             Tel. +49-4931-918175-31
Dipl.-Inf. (FH)             Rheinstraße 13          Fax. +49-4931-918175-50
Software Engineer           D-26506 Norden             http://www.norbit.de
QGIS release manager (PSC)  Germany                    IRC: jef on FreeNode

This electronic message, as well as any transmitted files included in the electronic message, may contain privileged or confidential information and is intended solely for the use of the individual(s) or entity to which it is addressed. If you have received this electronic message in error please notify the sender immediately and delete the electronic message. Any unauthorized copying, disclosure or distribution of the electronic message is strictly forbidden. NAV CANADA accepts no liability for any damage caused by any virus and/or other malicious code transmitted by this electronic communication.

Le présent message électronique et tout fichier qui peut y être joint peuvent contenir des renseignements privilégiés ou confidentiels destinés à l’usage exclusif des personnes ou des organismes à qui ils s’adressent. Si vous avez reçu ce message électronique par erreur, veuillez en informer l’expéditeur immédiatement et supprimez le. Toute reproduction, divulgation ou distribution du présent message électronique est strictement interdite. NAV CANADA n’assume aucune responsabilité en cas de dommage causé par tout virus ou autre programme malveillant transmis par ce message électronique.