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

The main motivation for using raw devices is the dramatic increase in performance of the database

1. 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 - 00:37:44 CDT