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

1. Fuentes wrote:

>Daniel,
>
>Thanks for your reply.
>
>Actually, /dev/vx/rdsk/oradg/system1, /dev/vx/rdsk/oradg/log1,
>/dev/vx/rdsk/oradg/log2,
>etc are SEPARATE volumes!. system1, log1, log2, etc are the names of the
>volumes
>(Not the names of the files to be loaded in the volume or partition). oradg
>is the Veritas
>disk group.
>
>So all the issues of the original posting still aply.
>
>
>

I built an AIX 5L database a month ago on raw devices. Here's an edited version of my create script that may help.

CREATE DATABASE xxx
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
CHARACTER SET UTF8
NATIONAL CHARACTER SET UTF8
   DATAFILE '/opt/oracle/diskmap/system-disk1/' SIZE 300M    AUTOEXTEND ON NEXT 10240K MAX SIZE UNLIMITED DEFAULT TEMPORARY TABLESPACE "TEMP"
   TEMPFILE '/opt/oracle/diskmap/temp-disk2/' SIZE 10240M    AUTOEXTEND OFF
UNDO TABLESPACE "UNDOTBS1"
   DATAFILE '/opt/oracle/dismap/undo1-disk3/' SIZE 16777200K -- esential sizing for a 16GB raw partition

   AUTOEXTEND OFF
LOGFILE
   GROUP 1 ('/opt/oracle/diskmap/log1a-disk20/'

                     '/opt/oracle/diskmap/log1b-disk21/') SIZE 10240M,
   GROUP 1 ('/opt/oracle/diskmap/log1c-disk22/'
                     '/opt/oracle/diskmap/log1d-disk23/') SIZE 10240M;

And be sure to use STARTUP NOMOUNT before executing the script.

HTH

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