<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=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
span.E-MailFormatvorlage17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:70.85pt 70.85pt 2.0cm 70.85pt;}
div.WordSection1
{page:WordSection1;}
--></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=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal>We have a QGIS installation running with a Oracle 12 Database.<o:p></o:p></p><p class=MsoNormal>If we open the Qgis Oracle Connection window and set up a connection without saving our username and password, then click on the connect button, and then add any table to qgis, our DBA gets the error below:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>We are experiencing the same problem whether we are connecting from our QGIS 2.2 installation on Linux or our QGIS 2.6 installation on Windows. We experience the same problem with 2 different databases, and with 2 different oracle servers. We have tried increasing the connection timeout on the oracle side to 200 seconds, with no effect. From qgis, we see no hang or connection problems. We are quickly asked for our credentials and the layer loads successfully. The error usually comes after the load is complete. These errors also come with the opening of projects with Oracle tables in them. The end result is that we have to do a daily reboot of our TNS Listener. Our DBA finds this unacceptable, particularly since the number of users is expected to rise sharply. I am not seeing any reports of other users with this problem. Any ideas?<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Thanks,<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Heather<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>The error:<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>Fatal NI connect error 12170.<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal> VERSION INFORMATION:<o:p></o:p></p><p class=MsoNormal> TNS for Linux: Version 11.2.0.4.0 - Production<o:p></o:p></p><p class=MsoNormal> Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production<o:p></o:p></p><p class=MsoNormal> TCP/IP NT Protocol Adapter for Linux: Version 11.2.0.4.0 - Production<o:p></o:p></p><p class=MsoNormal> Time: 16-MAR-2015 13:36:21<o:p></o:p></p><p class=MsoNormal> Tracing not turned on.<o:p></o:p></p><p class=MsoNormal> Tns error struct:<o:p></o:p></p><p class=MsoNormal> ns main err code: 12535<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>TNS-12535: TNS:operation timed out<o:p></o:p></p><p class=MsoNormal> ns secondary err code: 12606<o:p></o:p></p><p class=MsoNormal> nt main err code: 0<o:p></o:p></p><p class=MsoNormal> nt secondary err code: 0<o:p></o:p></p><p class=MsoNormal> nt OS err code: 0<o:p></o:p></p><p class=MsoNormal> Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=10.100.78.43)(PORT=49830))<o:p></o:p></p><p class=MsoNormal>WARNING: inbound connection timed out (ORA-3136)<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p></div></body></html>