RE: Starting and stopping listener -fears??

From: Adams, Matthew (GEA, 088130) <MATT.ADAMS_at_APPL.GE.COM>
Date: Tue, 19 Dec 2000 13:43:03 -0500
Message-Id: <10715.124942@fatcity.com>

Note that this will cause rollback segment usage to go up dramitically if the export lasts a long time.

You may need to add space to the RBS tablespace(s).

---

Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Doing linear scans over an associative array is like   trying to club someone to death with a loaded Uzi.

• Larry Wall (creator of Perl)

> -----Original Message-----
> From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us]
> Sent: Tuesday, December 19, 2000 10:57 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Starting and stopping listener -fears??
>
>
> Just specify consistent=y and there will be no problem. RBG
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Tuesday, December 19, 2000 1:00 AM
>
>
> > Are there no implications to consistency of data if people
> update the
> > database during export?
> >
> > -----Original Message-----
> > Kostyszyn
> > Sent: Monday, December 18, 2000 6:36 PM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > If you're just doing exports why would you want to
> disconnect the users?
> > Kev
> >
> > -----Original Message-----
> > Tapiwanashe
> > Sent: Monday, December 18, 2000 9:25 AM
> > To: Multiple recipients of list ORACLE-L
> >
> >
> > Hie list,
> >
> > I use export for my back ups. I want to prevent users from
> connecting to
> > Oracle while backup is proceeding. I have in mind "stopping Oracle
> listener"
> > before backup and "starting it" afterwards using
> > lsnrctrl stop and lsnrctrl start.
> > Now my fears are, since some users may be actively
> connected, if I use
> this
> > won't listener crush (sic) and fail to re-start.
> >
> > Thanks in advance.
> >
> > Tapiwa
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Zhou, Tapiwanashe
> > INET: tzhou_at_border.co.zw
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Kevin Kostyszyn
> > INET: kevin_at_dulcian.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > 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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Zhou, Tapiwanashe
> > INET: tzhou_at_border.co.zw
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access /
> Mailing Lists
> > --------------------------------------------------------------------
> > 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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ruth Gramolini
> INET: rgramolini_at_tax.state.vt.us
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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
Received on Tue Dec 19 2000 - 12:43:03 CST