Re: raw partitions, some simple questions

Maciej Kwapulinski wrote:
>
> sybrandb_at_my-deja.com wrote:
>
> > In article <3A76EB8F.B10218F2_at_univ.gda.pl>,
> > Maciej Kwapulinski <pikpok_at_univ.gda.pl> wrote:
> > > I'm new to oracle (although a few years experience with unixes)
> > > I have a question about raw partitions.
> > > I don't understand when do we use them during the oracle instalation
> > > process.
> > > Can I install everything on raw partition, I mean all oracle tree, for
> > > example :
> > > ..../oracle/admin
> > > ..../oracle/doc
> > > ..../oracle/jre
> > > ...../oracle/oradata
> > > ...../oracle/oui
> > > ....../oracle/product
> > >
> > > or I use it only while creating new databases, while the rest is
> > > installed in ufs filesystem
> > >
> > > documentation doesn't answer these basic (very important) questions,
 so
> > > i don't understand this
> > >
> > > greetings
> > > Maciek
> > >
> > >
> > My understanding is you use raw partitions for tablespaces only,
> > where 1 tablespace = 1 raw partition.
> > All the rest should be on cooked ufs file systems.
> >
> > Hth,
> >
> > --
> > Sybrand Bakker, Oracle DBA
> >
> > All standard disclaimers apply
> > ------------------------------------------------------------------------
> >
> > Sent via Deja.com
> > http://www.deja.com/
>
> This is the way I started to go 2 hours ago.
> I assumed, that the tablespaces are the .dbf files , for exmaple :
> system01.dbf
>
> I created 4 raw partitions with apriopriate sizes
> c2t0d0s[3456]
>
> I created file named 'mapping_ascii', which included lines :
>
> /aw/oracle_new/oradata/dpikpok/system01.dbf /dev/rdsk/c2t0d03
> /aw/oracle_new/oradata/dpikpok/users01.dbf /dev/rdsk/c2t0d04
> /aw/oracle_new/oradata/dpikpok/rbs01.dbf /dev/rdsk/c2t0d05
> /aw/oracle_new/oradata/dpikpok/temp01.dbf /dev/rdsk/c2t0d06
>
> I export(ed) the environment variable DBCA_RAW_CONFIG which pointed on
> 'mapping_ascii" file
>
> then I started dbassist and created database with name 'dpikpok'
> and it created these table spaces on on ufs filesystem instead of creating
> it on raw devices
>
> what am I doing wrong ?
> greetings
> Maciej

When I did this recently, into Veritas "raw" volumes - each 600Mb, I also read about the environment variable DBCA_RAW_CONFIG. However when I tried to use dbassist for the creation, all the fields were left blank and I couln't cut and paste into dbassist.

I also found a note saying that dbassist didn't work with raw volumes and that the workaround was to type in the raw locations for each dbf file and then at the end, where it gives you the choice to create now or write to a script, you should write to a script.

This will leave you a bunch of sql scripts and one bourne shell script which you will have to chmod 755 to run and it locates it into $ORACLE_HOME/assistants/dbca.

I also note, that your file looks different from mine. Yours seem to specify Ufs locations on the left and raw on the right. Mine was of the form (name on the left and raw location on the left). In any case, my file didn't get used anyway when running dbassist, because I ended up typing each location in by hand.

Good luck,

-Dirk Received on Wed Jan 31 2001 - 14:19:52 CST