RE: Stopping a listener

the databases need to register with the listener... so they should be started after the listener is started or MTS is not active

>From: "Jain, Akshay" <Akshay.Jain_at_cit.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: Stopping a listener
>Date: Wed, 07 Jun 2000 07:29:07 -0800
>
>I had a problem with our MTS configured listener on AIX.
>Bouncing the listener would disconnect the database from it, causing
>all future connections to be dedicated by default.
>
>In order to get back to Multi Threaded connections, we had to
>always bounce the databases after bouncing the listener.
>
>Something we did wrong in configuration?
>
>Akshay Jain
>_______________________
>Newcourt-CIT
>Tel. (416) 507-5385
>mailto:Akshay.Jain_at_cit.com
>_______________________
>
>
>-----Original Message-----
>Sent: Tuesday, June 06, 2000 5:50 PM
>To: Multiple recipients of list ORACLE-L
>
>
>
>Tom,
>
>I believe you are right on Solaris also. I once have to bounced a heavily
>used listener. No one noticed at all.
>
>Or I am just lucky that time! :)
>
>Winnie
>
>
>
>
>
>"Tom Pall" <tpall_at_cdproc.com> on 06/06/2000 01:12:13 PM
>
>To: steve_at_arzoo.com, "Oracledba" <oracledba_at_QuickDoc.co.uk>, "Oracle-L"
> <oracle-l_at_fatcity.com>
>cc: (bcc: Winnie Liu/HQ/ISC)
>
>
>
>
>
>Sparc Solaris 2.6, 2.7. When I stop the tcp listener, the dedicated
>processes remain,
>but new people cannot log in. When I restart, everything is back to
>normal.
>
>Recently on a box with Oracle 8.0.5 and 8.1.6 were running, each with its
>own listener
>(one on port 1521, the other on 1526). I shut down the 8.0.5 listener,
>refreshed the
>8.1.6 listener (listener.ora file edited for listening on ports 1521 and
>1526 for both databases).
>Nobody noticed. And this is a heavily hit back end to an e-commerce site.
>----- Original Message -----
>To: Oracledba <oracledba_at_QuickDoc.co.uk>; Oracle-L <oracle-l_at_fatcity.com>
>Sent: Tuesday, June 06, 2000 1:23 PM
>
>
> > What's the effect of stopping a TCP listener on Solaris? I thought it
> > always stopped any existing connections but here's what it says in a
>clip
> > from Appendix A of the Net8 Admin Guide:
> >
> > "On some platforms and with some protocols, when a listener is stopped
> > any Net8 connections currently running are shut down. In some
> > situations the connections continue, but it is then not possible to
> > start the listener again until the running processes have been closed."
> >
> >
> > Are there any protocols which do not get immediately disconnected on
> > Solaris?
> >
> >
> > Steve Orr
> >
> >
> > --------
> > If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
> > to unsubscribe, send a blank email to
>oracledba-unsubscribe_at_quickdoc.co.uk
> > to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
> >
>
>
>--------
>If you're bored, then visit the list's website: http://www.lazydba.com
>(updated daily)
>to unsubscribe, send a blank email to oracledba-unsubscribe_at_quickdoc.co.uk
>to subscribe send a blank email to oracledba-subscribe_at_quickdoc.co.uk
>
>
>
>
>
>--
>Author:
> INET: Winnie_Liu_at_infonet.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).
>--
>Author: Jain, Akshay
> INET: Akshay.Jain_at_cit.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).