Oracle-L: RE: Listener

From: Odland, Brad <Brad.Odland_at_qtiworld.com>
Date: Mon, 14 Apr 2003 14:22:22 -0800
Message-ID: <F001.00580E1A.20030414142222@fatcity.com>

should only be for those that attempt to connect The listener just validates the address from incoming connection requests and hands off the request to a database service.

-----Original Message-----
Sent: Monday, April 14, 2003 3:44 PM
To: Multiple recipients of list ORACLE-L

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).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: Odland, Brad
INET: Brad.Odland_at_qtiworld.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------