Re: Listener under ASM or db?

Somebody please correct me if I'm wrong. It was always my assumption (Could have swore I read a Metalink Document) that the CRS and ASM versions are much like a listener and need to be on the highest version of database on a box (down to the patchset level).

For example, if you wanted to patch a database to 10.2.0.4 and your CRS and ASM were 10.2.0.3. You'd first have to patch your CRS and ASM home to 10.2.0.4 before any database would be patched. With that assumption in mind, we've always kept our RAC listeners in the ASM home.

Bradd Piontek
Oracle Blog: http://piontekdd.blogspot.com Linked In: http://www.linkedin.com/in/piontekdd

On Wed, Sep 17, 2008 at 4:54 PM, Tim Gorman <tim_at_evdbt.com> wrote:

> 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
>
>
>
> *_________**__________________________*
>
> 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