RE: Starting and stopping listener -fears??

From: Zhou, Tapiwanashe <tzhou_at_border.co.zw>
Date: Tue, 19 Dec 2000 08:01:49 +0200
Message-Id: <10714.124899@fatcity.com>

Are there no implications to consistency of data if people update the database during export?

-----Original Message-----

From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Kevin Kostyszyn
Sent: Monday, December 18, 2000 6:36 PM
To: Multiple recipients of list ORACLE-L Subject: RE: Starting and stopping listener -fears??

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