Think of the listener as a switchboard with an operator who connects
the incoming call to the database and then gets off the line.
So you can stop the listener and it will not affect anyone currently
connected to any of your databases. No one will be able to make a new
connection though, until you restart it.
Rachel
- CSP2201_at_netscape.net wrote:
> Hi Gurus,
>
> We have four database instances, three of them are using Oracle8i and
> one using Oracle9i. Presently, the listener service is using
> Oracle8i binaries. Due to some issues with Intelligent Agent, we want
> to migrate/upgrade the listener service to Oracle9i. All the
> databases are accessed all the time and there are active connections
> to all these databases. My question is, if I quickly stop the
> listener and start the listener using Oracle9i environment, will
> there be any disruption to the connections which are already made to
> the database? Will the effect be limited to the connections if any
> made during the duration between the shutting down the listener and
> starting up the new listener? Please help me understand the effect
> of this plan.
>
> OS : Sun Solaris 32bit.
> Oracle: Oracle8i (8.1.7.4) and Oracle9i (9.2.0.1)
>
> Thanks a lot in advance!
> CP
>
>
> __________________________________________________________________
> Try AOL and get 1045 hours FREE for 45 days!
> http://free.aol.com/tryaolfree/index.adp?375380
>
> Get AOL Instant Messenger 5.1 for FREE! Download Now!
> http://aim.aol.com/aimnew/Aim/register.adp?promo=380455
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
> INET: CSP2201_at_netscape.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).
>
Do you Yahoo!?
Yahoo! Tax Center - File online, calculators, forms, and more
http://tax.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.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 Apr 14 2003 - 17:22:25 CDT