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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Fri, 14 Nov 2003 14:39:58 -0800
Message-ID: <1068849620.911805@yasure>

Sybrand Bakker wrote:

> 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

Or would the connected time parameter in the user profile do the job?

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Fri Nov 14 2003 - 16:39:58 CST