Message-ID: <F001.0055EAE9.20030303103627@fatcity.com>
Date: Mon, 03 Mar 2003 10:36:27 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "david davis" <ddoralist@hotmail.com>
Subject: Re: Listener/Database shutdown sequence
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain; format=flowed
Content-Transfer-Encoding: 7bit

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