Re: DISABLE_OOB = ON

On Tue, Apr 22, 2003 at 08:11:46AM -0800, Hemant K Chitale wrote:
>
> 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.

Yes, 2 dbs across a dblink is what I'm chasing here.

dblinks are persistent? I thought they were the same as any client and the characteristics where established for each sql making use of it. That is why I was thinking this db restart was frivolous. Is that not the case, are dblinks some kind of tunneled connection?

> 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).

-- 
===============================================================
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).