Re: DISABLE_OOB = ON

The sqlnet.ora file is used by the client. If you update it, fresh connections from the same client would take the setting. The server does NOT have to be restarted.

However, if your "client" is itself a database which has a persistent database link
to another database, your analyst might be asking you to restart the database that is the client.

To escalate you can call your local Support Hotline, enter the TAR# and ask for the supervisor or update the TAR saying that you are not happy with the response and ask for a supervisor.

Hemant

At 10:11 AM 21-04-03 -0800, you wrote:
>On Mon, Apr 21, 2003 at 07:32:20AM -0800, Hemant K Chitale wrote:
> >
> > See Note 61444.1 on "Out-of-Band Breaks" [OOB].
> > OOB is enabled by default and Unix servers running TCPIP do support OOB.
> > There is a cost involved in using "In-Band Breaks" and "Out-of-Band Breaks"
> > are preferred.
> >
> > Note 208433.1 seems to indicate that Intel-Linux does not support OOB.
> >
> > The "disable_oob" is set in the sqlnet.ora on the client. It does not need
> > a database instance restart. The client specifies to the server when it
> > connects whether it will be using "in-band" or "out-of-band".
>
>
>
>Thanks.
>
>Can you specify the docs that states, "It does not need a database
>instance restart?"
>This oracle analyst insists on it and I'm really ticked off because I'm
>sure it is
>not necessary, but I can't prove it.
>
>Is there a way to assess the value of the parameter in a connection?
>
>How do you ask to speak with "the supervisor" on a tar?
>
>
>
>
>
>
>
>
>
>
> >
> > Search Metalink for "disable_oob" or "oob" or "out-of-band"
> >
> > Hemant
> >
> > At 05:52 AM 21-04-03 -0800, you wrote:
> >
> > >Anybody using this sqlnet parameter setting? I can't find a good
> > >description. Some oracle analyst thinks it will solve all my remote
> > >query woes or at least get rid of me for a week or so. He says both
> > >dbs have to be bounced to set it. I find that hard to believe, but
> > >don't know how to query the setting.
> > >
> > >Gotta love the double negitive.
> > >===============================================================
> > >Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > >--
> > >Author: Ray Stell
> > > INET: stellr_at_cns.vt.edu
> > >
> > >Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > >San Diego, California -- Mailing list and web hosting services
> > >---------------------------------------------------------------------
> > >To REMOVE yourself from this mailing list, send an E-Mail message
> > >to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > >the message BODY, include a line containing: UNSUB ORACLE-L
> > >(or the name of mailing list you want to be removed from). You may
> > >also send the HELP command for other information (like subscribing).
> >
> > Hemant K Chitale
> > My personal web site is : http://hkchital.tripod.com
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: Hemant K Chitale
> > INET: hkchital_at_singnet.com.sg
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
>
>--
>===============================================================
>Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Ray Stell
> INET: stellr_at_cns.vt.edu
>
>Fat City Network Services -- 858-538-5051 http://www.fatcity.com
>San Diego, California -- Mailing list and web hosting services
>---------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).

Hemant K Chitale
My personal web site is : http://hkchital.tripod.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Hemant K Chitale
  INET: hkchital_at_singnet.com.sg

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).