Re: Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem

> Not quite. Cluster File Systems have been around for quite some time, and
> were perfectly useable with 9iR1. Tru64 was the first certified Unix
> Cluster File System, and that was most definitely for 9iR1.

Also SUN Cluster 2.2, 3.0, IBM-HACMP. (I was thinking of in terms of a Cluster File System from Oracle)

> The Oracle software can *not* be installed onto a raw device. Period. It
> consists of over 60,000 files, each one of which would require the
creation
> of a separate raw partition. And a lot of them are text files which can't
> be stored on a raw partition in any case.
>

The initial posting referred to the Oracle Software living on a file system (either Veritas or JFS/JFS2 as I have it now) and only the datafiles in raw volumes.
(Of course that the Oracle Product can NOT be installed in a raw partition!)

> If you have raw devices for your shared disk storage, then neither the
> Oracle installation itself, nor archive logs, nor the init.ora can be
> shared between instances using the raw device.

Oracle instances "living" in diferent RAC nodes can share the same raw devices.
( The system file, control files, redo files of instances can share the same raw partition.
Refer for example to the guide of "Configuring Raw Volumes for RAC on UNIX http://www.csis.gvsu.edu/GeneralInfo/Oracle/rac.920/a96600/cfgdsk.htm#100855 4 )

However, the scope of this posting was a search for hints about how to create a database
or why sql CREATE DATABASE failed when instructed to use veritas raw devices. (It doesnt
fail when CREATE DATABASE is issued to use AIX raw devices So controlfiles and logs CAN be
writen to a raw partition). I became interested in this issue because I know it was done before, in
a big Company. I got Oracle to use Veritas raw devices for the datafiles but as I stated
before by first creating the database in a Veritas FileSystem and then afterwards using the
ALTER DATABASE RENAME FILE 'xxx' TO 'my veritas-raw volume' command. ie migrating the datafiles to the Veritas Raw device.

Still, any clue about this issue of how to create a database using Veritas raw volumes
will be dearly appreciated

Best,

Alvaro Fuentes
512-297-9937

"Howard J. Rogers" <howardjr2000_at_yahoo.com.au> wrote in message news:3f6ed8d5$0$10355$afc38c87_at_news.optusnet.com.au...
> A. Fuentes wrote:
>
> >
> >
> > Thanks for clarifying this. Howard is correct. After 9.2.0.2 raw devices
> > are not required for RAC. We can use OCFS.
>
>
> Not quite. Cluster File Systems have been around for quite some time, and
> were perfectly useable with 9iR1. Tru64 was the first certified Unix
> Cluster File System, and that was most definitely for 9iR1.
>
> >
> > However, for this particular setup, I need to put the database files
> > on Veritas raw devices. And I don't know if the Oracle Software needs to
> > live in a Veritas FS vxfs, instead of the jfs where is now.
>
> The Oracle software can *not* be installed onto a raw device. Period. It
> consists of over 60,000 files, each one of which would require the
creation
> of a separate raw partition. And a lot of them are text files which can't
> be stored on a raw partition in any case.
>
> If you have raw devices for your shared disk storage, then neither the
> Oracle installation itself, nor archive logs, nor the init.ora can be
> shared between instances using the raw device.
>
>
>
>
>
>
>
>
>
> > A. Fuentes
> > 512-297-9937
> >
> >
> > "Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message
> > news:1063948891.425987_at_yasure... Howard J. Rogers wrote:
> >
> > A. Fuentes wrote:
> >
> >
> > Thanks again for trying to help
> >
> > A fact that may matter here is that, I do have the Oracle9i Software
> > installed in an AIX jfs filesystem and only the database files are the
> > ones going to the Veritas Raw partitions. Perhaps it would make the
> > difference if I would had the Oracle Software installed on a Veritas
> > Filesystem and then try to use Veritas Raw devices for the database
files.
> > In Oracle RAC this fact is transparent, ie the Oracle software can live
in
> > a different filesystem from where the datafiles live ( Raw devices are
> > required in RAC).
> >
> >
> > No they're not. That's what cluster file systems are there for.
> >
> > Regards
> > HJR
> >
> > Howard is correct. You do not need raw devices for RAC.
> >
>
Received on Wed Sep 24 2003 - 00:36:38 CDT