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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Tim Gorman
Sent: Wednesday, September 17, 2008 4:54 PM
To: oracle-l@xxxxxxxxxxxxx
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/ORACLE-
L?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@xxxxxxxxx] 
Sent: Wednesday, September 17, 2008 3:59 PM
To: Herring Dave - dherri
Cc: oracle-l@xxxxxxxxxxxxx
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

Other related posts: