[Qgis-user] Oracle connection Timeout

[Jürgen E. Fischer]

Hi Heather,

On Mon, 16. Mar 2015 at 14:12:23 +0100, Hillers Heather wrote:
> We have a QGIS installation running with a Oracle 12 Database.
> 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:
 
> 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?

Never seen this either.  Googling suggests that it might be a firewall between
client & server that kills "idle" connections.


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                         
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 827 bytes
Desc: Digital signature
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20150316/53749597/attachment.sig>