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

A, Others,

I understand : you want raw Devices for Performance. I will not dispute that : raw-dev Used To Be faster then anything (and some bearded Ingres adaps still try to convince me that this still holds).

What I do not quite understand (even after I read you conversation with Daniel + HJR)
q1: - Are you trying to set up a RAC db, or just a single-instance and want performance ?
q2 :- your question is just "why won't create-db not accept the file on vxvm?"

For answers to q2, I'm probably not the person to help you. The error in post indicates some AIX level system call is in error. I woudl check some of the obvious stuff:

• umask, ownership of files and of deamon-processes
• size of device
• compatiblity of your technology stack (kernel IO settings?)
• if all fails : open a tar and/or contact Veritas. (and did I mention: latest version only: consider patching to 9204)

To return to q1 : performance of raw-dev Veritas now claim their DB-Edition yields equal performance to raw-devices. I personally never found raw-dev worth the overhead or extra-attn, even with all the sysamin or 3rd party tools available to handle the raw-stuff.
Nothing beats a good, real, CFS for both software and database. Howard mentioned Tru64: I subscribe to that, and disqualify as a grey-beard myself ;-).

10G wants to tilt the table for file-system management though, all balls should roll to Larry now. (G=disk Gobbler, or Gremlin ;-) I'll wait and watch closely.

Regards,

PdV

"A. Fuentes" <alvarof2_at_hotmail.com> wrote in message news:I4acb.80532$KW1.32276_at_twister.austin.rr.com...
>
> The main motivation for using raw devices is the
> dramatic increase in performance of the database
>
> A. Fuentes
>
>
> "pdv_sky" <fa559088_maps_on_at_skynet.be> wrote in message
> news:3f681d7a$0$2959$ba620e4c_at_reader2.news.skynet.be...
> > A,
> >
> > If you have the options, try using
> > the veritas file system instead of raw devices.
> >
> > PdV
> >
> > "A. Fuentes" <alvarof2_at_hotmail.com> wrote in message
> > news:cyt9b.22956$z32.6379_at_twister.austin.rr.com...
> > >
> > > Actually I tried this, without the "reuse" and got the
> > > same error.
> > >
> > > A. Fuentes
> > >
> > >
> > >
> > > "Langelage, Frank" <frank_at_lafr.de> wrote in message
> > > news:bk50td$pc4pf$1_at_ID-48907.news.uni-berlin.de...
> > > > A. Fuentes wrote:
> > > > > Enviroment: Oracle9i/AIX5.2/Veritas vxvm
> > > >
> > > > > connect sys/change.. as sysdba
> > > > > startup nomount pfile=mycorrectpfile.ora
> > > > > create database myoradb controlfile reuse
> > > > > datafile '/dev/vx/rdsk/oradg/system1' size 700M reuse
> > > > > logfile '/dev/vx/rdsk/oradg/log1' size 300M reuse,
> > > > > logfile '/dev/vx/rdsk/oradg/log2' size 300M reuse;
> > > > > exit
> > > >
> > > > > The error message is:
> > > > >
> > > > > "Connected to an idle instance.
> > > > > ORACLE instance started.
> > > > > Total System Global Area xxxxx bytes
> > > > > Fixed Size
> > > > > xxxx bytes
> > > > > Variable Size
> > > > > xxxxx bytes
> > > > > Database Buffers
> > > > > xxxxx bytes
> > > > > Redo Buffers
> > > > > xxxxxx bytes
> > > > >
> > > > > create database "myoradb" controlfile reuse maxdatafiles 700
> > > > > ERROR at line 1:ORA-01501: CREATE DATABASE failed
> > > > > ORA-00301: error in adding log file '/dev/vx/rdsk/oradg/log1'
> > > > > - file cannot be created
> > > > > ORA-27041: unable to open file
> > > > > IBM AIX RISC System/6000 Error: 22: Invalid argument
> > > > > Additional information: 11
> > > > > Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 -
> > 64bit
> > > > > Production
> > > > > With the Partitioning, OLAP and Oracle Data Mining options
> > > > > JServer Release 9.2.0.1.0 - Production"
> > > >
> > > > You may try without REUSE. This is a guess from the explanation of
> error
> > > > 301:
> > > > root_at_sb150:/ oerr ora 301
> > > > 00301, 00000, "error in adding log file '%s' - file cannot be
created"
> > > > // *Cause: The creation of the redo log file failed
> > > > // *Action: Check: 1) there is enough storage space on the
> device
> > > > // 2) the name of the file is valid
> > > > // 3) the device is online
> > > > // 4) an IO error occurred
> > > > // Also, it is possible REUSE was specified on the command line
> and
> > > > // a file of the incorrect size exists. Either do not
specify
> > > REUSE
> > > > // or use a file of the correct size.
> > > >
> > >
> > >
> >
> >
>
>
Received on Wed Sep 24 2003 - 03:33:12 CDT