Re: Where should RAC listener run from

The listener can be run from any home.

The separation between ASM and DB homes gives you more flexibility in
patch management.

I imagine that upgrading ASM to more current patchset than DB is
easier (but that configuration is not tested as thorough as same
patchsets ASM and DB) and you might want your listener to be on the
highest patchset as well. But again who knows if there are (un)known
issues specific to 10.2.0.2 DB running with 10.2.0.3 listener?

Also take into consideration that upgrading ASM home will cause outage
to all databases while upgrading oracle home will impact only
database(s) running from this oracle home. But with RAC, I would
expect this maintenance to be rolling.

I follow the rule - if there is one listener per database - run it
from DB home (ASM listener from ASM home). One listener for the node -
run it from ASM home.

Anyone has more thoughts on which Oracle home to use? I don't recall
it discussed in MAA papers but it was a while ago I read them.

On 7/25/07, William Wagman <wjwagman@xxxxxxxxxxx> wrote:

Alex,

Thank you. To follow up on this question I would ask whether it matters
which home the listener is running from. I am running on Linux, RHEL4
with Oracle 10.2.0.3.0 64-bit Enterprise Edition. I have three homes,
one for CRS, one for AS< and one for RDBMS. The listener is currently
running out of the ASM home on each node and seems to be working
properly. What are the ramifications of it running out of the ASM home
as opposed to the RDBMS home?

Thanks.


Bill Wagman
Univ. of California at Davis
IET Campus Data Center
wjwagman@xxxxxxxxxxx
(530) 754-6208
-----Original Message-----
From: gorbyx@xxxxxxxxx [mailto:gorbyx@xxxxxxxxx] On Behalf Of Alex
Gorbachev
Sent: Tuesday, July 24, 2007 7:14 PM
To: William Wagman
Cc: sacrophyte@xxxxxxxxx; freelists
Subject: Re: srvctl remove asm generates PRKS-1033 and CRS-0214

Bill (or William?),

srvctl for CRS home should manage resources related to CRS home - VIP,
ONS, GSD.
srvctl from Oracle home should manage resources from Oracle home -
ASM, Listener, Service, Database, Instance.
I had all kind fancy problems using wrong srvctl in the past asd I
remember that I figured that out when I started research log files to
troubleshoot - I was finding logs in wrong oracle homes.

Regarding tracing - unfortunately, I don't have any references - I
haven't seen it documented anywhere.

Cheers,
Alex




--
Alex Gorbachev, Oracle DBA Brewer, The Pythian Group
http://www.pythian.com/blogs/author/alex http://www.oracloid.com
BAAG party - www.BattleAgainstAnyGuess.com
--
http://www.freelists.org/webpage/oracle-l

Other related posts: