Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Marian, Yes - I follow the thread, but I don't know how to help. In your situation I wouldn't try and bother with ODBC but try to get the native Oracle connection working. I only very occasionally connect to Oracle and usually on Windows. I got Oracle on Linux running with OGR, but I haven't tested with QGIS. Maybe Jürgen Fischer has an idea how to get it working. Sorry that I can't help any better, Andreas On 26.06.2015 15:55, Tudorache, Marian wrote: Hi Andreas, 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. One thing that I found and it is related to Red Hat. When I tested the if all dependencies are working for libsqora.so.11.1 running the command bellow ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 I got libodbcinst.so.1 = not found I have fixed this issue by creating a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2. This fix made the unixODBC workable from a terminal windows and other applications which use ODBC connectivity but QGIS still does not have Oracle connectivity icon and it is not able to create an Oracle connection. Is this a QGIS bug? Thanks, Marian -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Andreas, 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. One thing that I found and it is related to Red Hat. When I tested the if all dependencies are working for libsqora.so.11.1 running the command bellow ldd /usr/lib/oracle/11.2/client64/lib/libsqora.so.11.1 I got libodbcinst.so.1 = not found I have fixed this issue by creating a symbolic link from /usr/lib64/libodbcinst.so.1 to /usr/lib64/libodbcinst.so.2. This fix made the unixODBC workable from a terminal windows and other applications which use ODBC connectivity but QGIS still does not have Oracle connectivity icon and it is not able to create an Oracle connection. Is this a QGIS bug? Thanks, Marian -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
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) GermanyIRC: jef on FreeNode signature.asc Description: Digital signature ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
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-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Jürgen E. Fischer Sent: June-26-15 11:26 AM To: qgis-user@lists.osgeo.org; ottawa_us...@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) GermanyIRC: 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
Hi Andreas, Yes I have installed Oracle Client and SQL Developer. I am able to create a connection via SQL Developer and it works fine. That I knew as well so I was very surprised to see the Oracle connectivity icon is not there. What else can I check? Thanks, marian -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user
Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser
I have echoed ORACLE_HOME and I got /usr/lib/oracle/11.2/client64/lib. I have echoed LD_LIBRARY_PATH and I got nothing. -Original Message- From: qgis-user-boun...@lists.osgeo.org [mailto:qgis-user-boun...@lists.osgeo.org] On Behalf Of Andreas Neumann Sent: June-18-15 4:53 PM To: qgis-user@lists.osgeo.org Subject: Re: [Qgis-user] Missing Oracle connectivity on QGIS Browser Hi Marian, Do you already have an Oracle client on this machine? Note that QGIS on Linux does not provide an Oracle client like it does on the Windows version. You would have to install the Oracle client yourself and make sure it is in the LIBRARY Path and that ORACLE_HOME is defined and the name resolution (tnsnames.ora or similar mechanisms) work fine. Have a look at the Oracle documentation on how to install the Oracle client on Linux. I think the instant client is enough - you don't need the full client. Andreas On 18.06.2015 22:13, Tudorache, Marian wrote: Hi, I have installed the latest QGIS 2.8 Wien on Linux Red Hat 7 and I do not see the Oracle Connectivity icon in. I have MSSQL, SpatialLite, PostGIS, OWS, WCS, WFS, WMS. I sued to have it on Windows version of QGIS. Can someone help me how to install it? Thanks, Marian 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. ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user ___ Qgis-user mailing list Qgis-user@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/qgis-user