RE: Listener under ASM or db?

Just spit-balling here but I believe I've read from multiple sources that the ASM instance has to be the highest version of all the database homes it supports. Backward compatability is not a problem.  

    -Randy

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%20Data/ Thunderbird/Profiles/cjwu3zzh.default/Mail/Local%20Folders/Inbox.sbd/ORACLEL ?number=43658727&header=quotebody&part=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