Re: D1000, Veritas, and Oracle Parallel Server questions

Here are a few points which might be helpful:

We run OPS (Oracle 8.1.6) on 2 E4500s.

The way it is setup (which you might want to look at in greater detail) is

2 E4500s - Solaris 8
2 D1000s
Sun Cluster 2.2
OPS (Oracle 8.1.6)

The way this works is we have the Sun Cluster managing the shared disk array (D1000s). This does the usual failover etc between the two nodes. The D1000s are mirrored using Veritas.
NOTE: Sun CLuster comes with either DiskSuite or Veritas option. The Veritas option is much the preferred one for most setups.

Veritas can handle raw devices.

One control per D1000 is acceptable though for improved performance and redundancy you might want to add controller(s)

One other point to make sure is you allocate enough space for the archive logs. This often gets overlooked and one or both of the OPS node(s) can grind to a halt if this fills up.

Hope that helps

Arv

Allen (allenh_at_starbase.neosoft.com) wrote:

: I'm a DBA and the company I recently started working at is using 2 Sun
: e220 servers hooked up to a D1000 unit running Veritas volume manager
: (also running Oracle 8.1.6 and Solaris 7). Right now Veritas monitors the
: database on server #1 and if it goes down, it brings up the DB on server
: #2.. These sun boxes share the drives in the D1000 where the oracle
: datafiles are installed.
 

: Down the road, we're expecting a huge increase in the amount of data being
: processed and stored in Oracle (24x7), and I suspect we'll need to move to
: a parallel server environment (OPS).
 

: Being a newbie to OPS, I believe I read somewhere that OPS requires raw
: devices. Does this mean we will not be using Veritas volume manager if we
: switch to OPS, or can Veritas handle this? And will the D1000 drives work
: in an OPS environment?
 

: Also, I'm a little concerned that the D1000 (which can hold 10 drives)
: only has 1 drive controller. Is this a cause of concern with possible I/O
: contention or is this controller effective when reading/writing to 10
: disks at once?
 

: Another D1000 question - right now we only have 6 drives in it, resulting
: in 3 mirrored pairs in a RAID 5 environment. Are the raid mirrored drives
: that big of an advantage in Oracle, or would I be better off with 6
: individual volumes? Since our current D1000 has room for 4 more disks,
: I've requested that they be added as non mirrored drives which would give
: me 7 volumes to play with (3 mirrored, 4 non). Again, does this sound
: feasable with a D1000 that has only 1 disk controller?
 

: Finally, if/when we switch to OPS, I can't imagine why we would need
: Veritas to monitor the status of our database, since if one goes down the
: other parallel servers take over (right?). And if we are forced to switch
: to unix raw devices.. then is our $20,000 Veritas license useless?
 

: Any advice much appreciated..thx..
 

: Allen

--