1

I have recently installed QGIS 2.8 and Oracle 11.2 Client on Linux Red Hat 7.

Everything was fine, I am able to access Oracle database, as well as running QGIS. Unlike QGIS 2.8 from WIndows, Linux version does not have Add Oracle spatial layers and Oracle new connection icons.

I think the Oracle support was removed by QGIS. Is this correct?

The machine where QGIS runs has installed Oracle Client 11g, unixODBC and SQL Developer.

I have tested the oracle connectivity from a terminal windows as well as from SQL Developer and it works.

I tried as alternative to load spatial data the followings:

  • cx_Oracle module from python: it connects to oracle from QGIS python console but cx_Oracle does not have functions to add SDO date to a QGIS layer.
  • Add vector layer from Database ODBC- does not connect to an Oracle