AIX/Oracle9i: dbca to use raw devices

From: A. Fuentes <alvarof2_at_hotmail.com>
Date: Fri, 22 Aug 2003 12:12:25 GMT
Message-ID: <JMn1b.6094$Xp4.323725@twister.austin.rr.com>

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,

1. Fuentes 512-297-9937

Received on Fri Aug 22 2003 - 07:12:25 CDT