RE: Listener under ASM or db?

Thanks Tim. For some reason I was thinking that with ASM, each request involving storage would use the listener to start new connections to the ASM instance. Guess I could have run a few tests on that first (which I did just now).

I'm in the process of configuring 9 more servers for 10.2.0.4 & ASM and wanted to be PAINFULLY aware of all details.

Dave

Dave Herring, DBA | A c x i o m M I C S / C S O

630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax

-----Original Message-----
From: Tim Gorman [mailto:tim_at_evdbt.com] Sent: Thursday, September 18, 2008 10:21 AM To: Herring Dave - dherri
Cc: oracle-l_at_freelists.org
Subject: RE: Listener under ASM or db?

Taking a TNS Listener down does not "break" existing database connections -- it only means new connection requests from clients get no response.

So, before patching/upgrading /lsnr, "move" the listener to the ORACLE_HOME with the highest version temporarily, then patch/upgrade /lsnr. Outage is very very brief (i.e. /lsnr/bin/lsnrctl stop, /db_2/bin/lsnrctl start). Once upgrade of /lsnr is complete (and it is only the "relink" phase that really matters), then "move" the listener back to /lsnr (i.e. /db_2/bin/lsnrctl stop, /lsnr/bin/lsnrctl start)...

Quoting Herring Dave - dherri <Dave.Herring_at_acxiom.com>:

> Good points, but now I?m even more confused. Let?s say I?ve got
> /asm, /db_1, and /db_2 homes and then place the listener in it?s own
> home /lnsr. Now I want to patch or upgrade /db_2. If I want to
> keep the listener at the highest release, then I?d want to
> patch/upgrade /lnsr. But, to do that I?d have to take the listener
> down, which would break all communication with ASM, which would in
> effect bring both databases down.
>
>
>
> What am I missing or have an incorrect understanding of?
>
>
>
> Dave
>
>
>
>
>
> ___________________________________
>
> Dave Herring, DBA | A c x i o m M I C S / C S O
>
> 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
>
> ________________________________
>
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Tim Gorman
> Sent: Wednesday, September 17, 2008 4:54 PM
> To: oracle-l_at_freelists.org
> Subject: Re: Listener under ASM or db?
>
>
>
> I was thinking the same thing, for the same reason, but hadn't seen
> the MetaLink note, and in reading it, I don't see it explicitly
> advising that the TNS listener reside under ASM home -- the note is
> geared toward the CSS.
>
> Still, it makes good sense to locate a server-wide service such as
> the TNS Listener alongside other server-wide services such as ASM
> and CSS, except for the one glitch: generally it is advisable to
> run the TNS Listener under the most up-to-date version of the RDBMS,
> because the TNS Listener is always backward-compatible (up to a
> point), but it is often not forward-compatible. This backward- and
> forward-compatibility may not be such an issue with ASM and CSS (?),
> but it can be a huge issue with TNS.
>
> So, with that backward- and forward-compatibility issue in mind,
> think about it again and ask: which ORACLE_HOME's are likely to be
> upgraded/patched to the highest level over time? One of the
> ORACLE_HOMEs dedicated to one (or more) RDBMS instances? Or the
> (single) ORACLE_HOME dedicated to the (single) ASM instance?
>
> Patching or upgrading the ORACLE_HOME of the ASM would involve
> taking it down, which of course means taking all RDBMS instances on
> the server down as well.
>
> So, from the standpoint of aesthetics and symmetry, it sounds good
> to recommend placing the TNS Listener under the ASM home, but from a
> practical standpoint, I suspect that it would prove unwieldy over
> time.
>
> Alternatives? Run the TNS Listener under the ORACLE_HOME with the
> latest version of the RDBMS? Run the TNS Listener under its own
> separate ORACLE_HOME?
>
>
>
> Herring Dave - dherri wrote:
>
> So if we ever add an addition 1+ database(s) to the server using
> ASM, then it makes most sense to keep the listener under ASM. I?ll
> buy that. I just wanted a reason behind using one location of the
> other. Thanks Mark!
>
>
>
> Dave
>
>
>
>
>

<mailbox://C%7C/Documents%20and%20Settings/Tim%20Gorman/Application%20Da ta/Thunderbird/Profiles/cjwu3zzh.default/Mail/Local%20Folders/Inbox.sbd/ ORACLE-L?number=43658727&header=quotebody?=1.2&filename=image001.gif>
>
> ___________________________________
>
> Dave Herring, DBA | A c x i o m M I C S / C S O
>
> 630-944-4762 office | 630-430-5988 wireless | 630-944-4989 fax
>
> ________________________________
>
> From: Mark Strickland [mailto:strickland.mark_at_gmail.com]
> Sent: Wednesday, September 17, 2008 3:59 PM
> To: Herring Dave - dherri
> Cc: oracle-l_at_freelists.org
> Subject: Re: Listener under ASM or db?
>
>
>
> Dave, see Metalink Note #279353.1. You should run the listener and
> CSS from the ASM home. We're doing that here for new RAC
> installations.
>
> Regards,
> Mark Strickland
> Seattle
>
>

--
http://www.freelists.org/webpage/oracle-l