Re: Host Enterprise Manager

From: Mark Brinsmead <pythianbrinsmead_at_gmail.com>
Date: Mon, 21 Apr 2008 18:45:32 -0600
Message-ID: <cf3341710804211745w44b32947xc84d03a90e90fe95@mail.gmail.com>


This is mostly true, but not quite completely accurate.

There are numerous ways to implement RAC storage:

  1. Clustered Filesystem (as mentioned by Finn)
  2. ASM (also as mentioned by Finn)
  3. Shared raw partitions (still requires clusterware; most would find ASM preferable). Well, these were still supported with 10gR2...
  4. NFS (with numerous caveats and restrictions -- not just "any" NFS will do)
  5. Several other technologies -- relatively exotic and usually very expensive. Not the sort of thing for first-time RAC implementations.

As I do very little with RAC myself, that's as far as I will go on this topic. There are lots of other people on this list who can answer RAC questions better than I.

Now, as for Oliver's *current* configuration -- Virtual IP addresses really would be a good idea. More formalized active-passive cluster software (e.g., HACMP) use them for several very good reasons, "convenience" being pretty much the last of them. Without using virtual IPs, you are likely to find that your database connection times *increase enormously* when one of the cluster nodes is offline and not responding to the network. That is, one of the main purposes of the virtual IPs is to prevent network timeouts.

Anyway, if you choose not to use VIPs, you can probably still work around your OEM "problem", with more-or-less the method I sketched. Just remove the configuration file built by the OEM agent (once you find it (sorry I cannot say where it is) and restart the agent. Or perhaps equally good -- just ignore the host information (mis-)reported by RAC. :-)

On Mon, Apr 21, 2008 at 12:54 PM, Finn Jorgensen <finn.oracledba_at_gmail.com> wrote:

> Oliver,
>
> Without a cluster filesystem or ASM you cannot create a RAC database. The
> datafiles has to be available on both nodes simultaneously. You would have
> to install and configure CRS and once that's running you can create your ASM
> instances and then finally your RAC instances. Bear in mind that RAC also
> requires a VIP, but netca will create it for you.
>
> Finn
>
>
> On 4/21/08, Oliver aka v1k1ng0 <ofabelo_at_gmail.com> wrote:
> >
> > Hello,
> >
> > 2008/4/21, Mark Brinsmead <pythianbrinsmead_at_gmail.com>:
> > >
> > > Oliver,
> > >
> > > <snip>
> > >
> >
> >
> >
>
>

-- 
Cheers,
-- Mark Brinsmead
Senior DBA,
The Pythian Group
http://www.pythian.com/blogs

--
http://www.freelists.org/webpage/oracle-l
Received on Mon Apr 21 2008 - 19:45:32 CDT

Original text of this message