Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: DISABLE_OOB = ON

Re: DISABLE_OOB = ON

From: Hemant K Chitale <hkchital_at_singnet.com.sg>
Date: Wed, 23 Apr 2003 08:56:51 -0800
Message-ID: <F001.00587D11.20030423085651@fatcity.com>

DB links, per se, are not persistent. I was talking of "a database which has a persistent database link to another database", meaning that your application might be setting up a connection and not closing it.
Hemant
At 09:06 AM 22-04-03 -0800, you wrote:
>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).

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).
Received on Wed Apr 23 2003 - 11:56:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US