<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
mso-margin-top-alt:auto;
margin-right:0cm;
mso-margin-bottom-alt:auto;
margin-left:0cm;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Sprechblasentext Zchn";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.E-MailFormatvorlage18
{mso-style-type:personal-reply;
font-family:"Verdana","sans-serif";
color:#1F497D;}
span.SprechblasentextZchn
{mso-style-name:"Sprechblasentext Zchn";
mso-style-priority:99;
mso-style-link:Sprechblasentext;
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1076123975;
mso-list-template-ids:1619194202;}
@list l0:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:"Courier New";
mso-bidi-font-family:"Times New Roman";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Wingdings;}
@list l1
{mso-list-id:1354530438;
mso-list-template-ids:1181939604;}
@list l1:level1
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:36.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level2
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:72.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level3
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:108.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level4
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:144.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level5
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:180.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level6
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:216.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level7
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:252.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level8
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:288.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
@list l1:level9
{mso-level-number-format:bullet;
mso-level-text:;
mso-level-tab-stop:324.0pt;
mso-level-number-position:left;
text-indent:-18.0pt;
mso-ansi-font-size:10.0pt;
font-family:Symbol;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="DE-CH" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Thank you, Andreas and Jürgen, for your encouraging replies. I actually already managed to install (and configure) Oracle Client before, but I’m
just still uncertain if “manage to install” is enough for later productive use. <o:p>
</o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Maybe I’m too much concerned, and maybe I’m trying too hard to keep things simple. But compared to a simple “apt-get install postgresql-client“,
installing and maintaining the Oracle client on Ubuntu seems like a tremendous effort, if not a hack ;-).<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">I’ll check again if we have any alternative possibilities (e.g. exporting the data and importing them into PostGIS). If not, we’re at least not
the only ones installing Oracle client on Ubuntu. If yes, we’ll gladly avoid it.<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D">Andy
<o:p></o:p></span></p>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<div style="border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt">
<div>
<div style="border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm">
<p class="MsoNormal"><b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">Von:</span></b><span style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> Neumann, Andreas [</span><span lang="DE" style="font-size:10.0pt;font-family:"Tahoma","sans-serif""><a href="mailto:a.neumann@carto.net"><span lang="DE-CH">mailto:a.neumann@carto.n</span>et</a>]
<br>
<b>Gesendet:</b> Mittwoch, 17. </span><span lang="EN-GB" style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">August 2016 11:08<br>
<b>An:</b> Schmid Andreas<br>
<b>Cc:</b> 'qgis-user@lists.osgeo.org'<br>
<b>Betreff:</b> Re: [Qgis-user] Are there any users working with the Oracle client on Ubuntu?<o:p></o:p></span></p>
</div>
</div>
<p class="MsoNormal"><span lang="EN-GB"><o:p> </o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Hi Andy,<o:p></o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">In Uster I did this for Ubuntu Server - but mainly for automated OGR conversions - not really for QGIS server. But it should work for QGIS Server as well.<o:p></o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">In Kanton Zug I installed the Oracle client on CentOS, which is of course rpm based and it worked fine.<o:p></o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Usually you have to set/extend certain environment variables, such as<o:p></o:p></span></p>
<ul type="disc">
<li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">PATH<o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">LD_LIBRARY_PATH<o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">ORACLE_HOME<o:p></o:p></span></li><li class="MsoNormal" style="mso-margin-top-alt:auto;mso-margin-bottom-alt:auto;mso-list:l0 level1 lfo3">
<span style="font-size:10.0pt;font-family:"Verdana","sans-serif"">TNS_ADMIN<o:p></o:p></span></li></ul>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif""><br>
Let me know, if you need assistance.<o:p></o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">Andreas<o:p></o:p></span></p>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif"">On 2016-08-17 10:32, Schmid Andreas wrote:<o:p></o:p></span></p>
<blockquote style="border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 5.0pt;margin-left:0cm;margin-top:5.0pt;margin-right:0cm;margin-bottom:5.0pt">
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">Hi<br>
<br>
While we're usually working with a PostGIS database, for a specific project we're thinking about connecting from QGIS to an Oracle Database this time. This should basically be possible. However, our QGIS runs on Ubuntu 14.04, and it seems that the Oracle client
installation isn't quite straightforward on Ubuntu. The instructions on e.g. </span>
<a href="https://help.ubuntu.com/community/Oracle%20Instant%20Client"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">https://help.ubuntu.com/community/Oracle%20Instant%20Client</span></a><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">
suggest to convert RPM packages from Oracle with alien, which I don't feel comfortable about for a production system.<br>
<br>
In order to get a feel if working this way is wise, I'd like to know if there is anybody of you using QGIS with an Oracle client on Ubuntu in a production environment? Do you consider it reasonable? Or would it be crazy to implement such a setup? Does anybody
know if there exist any original Ubuntu packages of the Oracle client?<br>
<br>
Thanks for your valuable input.<br>
<br>
Andy<br>
<br>
_______________________________________________<br>
Qgis-user mailing list<br>
</span><a href="mailto:Qgis-user@lists.osgeo.org"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">Qgis-user@lists.osgeo.org</span></a><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New""><br>
List info: </span><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">http://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New""><br>
Unsubscribe: </span><a href="http://lists.osgeo.org/mailman/listinfo/qgis-user"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New"">http://lists.osgeo.org/mailman/listinfo/qgis-user</span></a><span lang="EN-GB" style="font-size:10.0pt;font-family:"Courier New""><o:p></o:p></span></p>
</div>
</blockquote>
<p><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
<div>
<p class="MsoNormal"><span lang="EN-GB" style="font-size:10.0pt;font-family:"Verdana","sans-serif""> <o:p></o:p></span></p>
</div>
</div>
</div>
</body>
</html>