Database link freezes

From: Frank an der Heiden <fh_at_energotec.de>
Date: Wed, 13 Sep 2000 00:44:27 +0200
Message-ID: <8pmbl0$rke$1@oxygen.technet.net>

hi folks,

i have a strange problem concerning a database connection between two oracle 8.1.5 databases via net8

if i create a database-link between these databases and execute my dml-operations, everythink works fine.

if for a longer time no transaction was executed, the first transaction fails with the message "hostdefinition or extension doesn't exist"

the second transaction works fine without doing anythink .....

does anybody know about this behaviour?

perhaps there is a kind of timeout parameter to be configured and which keeps the database connection open.

i know about an init.ora parameter "job_queue_keep_connections = true/false",
but during startup of the database instance i get the message, that this parameter is obsolete!

thanx in advance for your help

frank Received on Tue Sep 12 2000 - 17:44:27 CDT