Oracle-L: RE: Multiple Listeners

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Wed, 16 Oct 2002 11:59:33 -0800
Message-ID: <F001.004EB2B1.20021016115933@fatcity.com>

I respectfully disagree. I am currently working on a Sun 4500 cluster with Veritas. The cluster services each maintain their own nic/ip, that's 1 per instance. Obviously, each instance also has its own listener. This has been very easy to implement and not at all confusing. It also avoids things like where you can't use a 8.0.5+ listener for 8.0.4- instances. Each SID has its own listener at its own version level. I would suggest coming up with a good standard for determining ports and such however. For instance, I use 15 concatenated with the last 2 digits of the assigned IP.

Before walking into the cluster world, I would have agreed with Tom. Of course now I have seperate HOMEs for each instance too.

John P Weatherman
Database Administrator
Replacements Ltd.

-----Original Message-----

Sent: Wednesday, October 16, 2002 2:40 PM To: Multiple recipients of list ORACLE-L

Rachna,

Do yourself a favor - use the most recent listener for all databases. Have only one listener running on a machine and use that for all databases on that machine. In your case, use the 817 listener.

In the long run, it will be much easier and less confusing.

Hope this helps.

Tom Mercadante
Oracle Certified Professional

-----Original Message-----

Sent: Wednesday, October 16, 2002 2:13 PM To: Multiple recipients of list ORACLE-L

DBAs,

Any quick start guides / scripts / notes for having multiple version listeners on same Solaris box?

Scenario :
I am in process of upgrading.
There are two databases on a machine db6 and db7 db6 <---------> 8.1.6
db7 <---------> 8.1.6
db6 and db7 use the "listener" of version 8.1.6

Now,
db7 migrated to 8.1.6
I am thinking of something like :
db6 <---------> listener of 8.1.6 (status quo) db7 <---------> listener_817 of 8.1.7 (new version listener)

Two separate listener.ora files

lsnrctl status listener (for 8.1.6 listener) lsnrctl status listener_817 (for 8.1.7 listener)

Thanks in advance,

-Rachna
--

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

Author: Rachna Vaidya
INET: rachnavaidya_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).
--

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

Author: Mercadante, Thomas F
INET: NDATFM_at_labor.state.ny.us

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

Author: John Weatherman
INET: john.weatherman_at_replacements.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