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: Listener/Database shutdown sequence

Re: Listener/Database shutdown sequence

From: david davis <ddoralist_at_hotmail.com>
Date: Mon, 03 Mar 2003 10:36:27 -0800
Message-ID: <F001.0055EAE9.20030303103627@fatcity.com>


Jeremiah

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 <jwilton_at_speakeasy.net>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: jwilton_at_speakeasy.net
>
>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).
>



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: ddoralist_at_hotmail.com

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 Mon Mar 03 2003 - 12:36:27 CST

Original text of this message

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