Re: AIX/Oracle9i: dbca to use raw devices

"A. Fuentes" wrote:

> Fellow Oracle Netters:
>
> Enviroment: AIX5.2/Oracle9i
>
> I am trying to use raw devices to store my Database datafiles, instead of
> the jfs filesystem.
>
> I created several raw devices (ie AIX logical Volumes) and chown to the
> oracle:dba.
>
> The situation is: If I create the database manually and do:
>
> create database mydatabase .....datafile '/dev/my_rsystem_raw_device'
> ....logfiles '/dev/mylog_rraw_device1'
> ....etc
> it works! (Of course, using the character raw device, rdevice)
> Oracle stores the datafiles in the raw devices.
>
> However, if I launch the dbca, to take advantage of all the features that
> Oracle offers
> to create a database, when it asks for the location of the datafiles and I
> enter my
> character raw devices (and their location), like /dev/rsystem_raw.dbf, etc,
> on the
> screen that asks for datafiles locations,
> (and of course making sure no typos and the correct names as in /dev are
> there)
> it fails. The dbca comes with "write fail" when it tries to access the raw
> device.
> Of course, previously I made sure that I could write my self to those raw
> devices
> (AIX logical volumes) with the dd command.
>
> So,
> 1)is there a special way or an additional steps I should take to tell the
> dbca to use raw devices?
>
> 2)Is there a special field/variable in the dbca response file that I should
> set
> pointing to my raw devices?
>
> The Old installers, back in Oracle 8.0.5, prompted you for this option of
> using
> raw devices.
>
> Any info/ideas about this issue will be greatly appreciated.
>
> Best,
>
> A. Fuentes
> 512-297-9937

DBCA can not handle raw devices. You need to create your build script by hand and execute it directly form the command prompt.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)