I didn't really think it mattered for the shutdown. Though I know in Oracle 7 it did matter for the startup (we use MTS). Another DBA seemed to imply that the sequence was important on shutdown of 8i.
So if in doubt I RTFM, suffer the metalink search and post to the list. As usual, the most successful path is the list.
Thx
David
From: Jeremiah Wilton <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Listener/Database shutdown sequence Date: Mon, 03 Mar 2003 08:19:06 -0800
Why do you/they think it matters, regardless of the documentation?
You can shut them down in any order you want. Users just get a different error if the listener is up vs. when it is down.
Starting up, if services are registered via local_listener or mts_dispatchers, the listener should be up before the database opens. Otherwise, you will have to wait for instance registration with the listener, or force it with 'alter system register'.
For dedicated connections, this problem can be avoided with a sid_desc in the listener.ora
-- Jeremiah Wilton http://www.speakeasy.net/~jwilton
On Mon, 3 Mar 2003, david davis wrote:
>
> Should the databases be shutdown before the listener or the other way
> around.
>
> A DBA here (actually at Service Provider) believes that the listener has to
> be shutdown before the databases in 8i according to some documentation (they
> can't recall).
>
> I am proposing:
>
> Set Oracle 817 environment
> shutdown database
> stop 817 listener
> set Oracle 806 environment
> stop 806 listener
>
> They feel it should be the other order:
> Shutdown Listeners
> Shutdown databases
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
_________________________________________________________________
The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page=features/junkmail
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).