Re: SQLNET.EXPIRE_TIME for a *single* DB only when several DBs run on the same server

On 14 Nov 2003 04:57:21 -0800, spendius_at_muchomail.com (Spendius) wrote:

>Hi,
>Has someone already set up this SQL*Net option for a
>single DB only, when you have several databases running
>on the same server ? We need to activate this option
>only for a specific DB: is it possible to play with it
>at the listener level (as this option must be set in
>the sqlnet.ora file) ?
>
>Thanks.
>Spendius

It is not possible.
You are going to end up with different sqlnet.ora listener.ora tnsnames.or combo's in different directories and different settings of TNS_ADMIN.
You don't want that as you'll end up in a mess. Why don't you use MTS on the affected instance?

--
Sybrand Bakker, Senior Oracle DBA