RE: Listener under ASM or db?
- From: "Herring Dave - dherri" <Dave.Herring@xxxxxxxxxx>
- To: "Tim Gorman" <tim@xxxxxxxxx>
- Date: Thu, 18 Sep 2008 11:48:53 -0500
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@xxxxxxxxx]
Sent: Thursday, September 18, 2008 10:21 AM
To: Herring Dave - dherri
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxx>:
> 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@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%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@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
>
>
************************************************************************
*
> The information contained in this communication is confidential, is
> intended only for the use of the recipient named above, and may be
> legally privileged.
>
> If the reader of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or copying of
this
> communication is strictly prohibited.
>
> If you have received this communication in error, please resend this
> communication to the sender and delete the original message or any
copy
> of it from your computer system.
>
> Thank you.
>
************************************************************************
*
>
--
//www.freelists.org/webpage/oracle-l
Other related posts:
