Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem

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

From: pdv_sky <fa559088_maps_on_at_skynet.be>
Date: Wed, 17 Sep 2003 10:38:34 +0200
Message-ID: <3f681d7a$0$2959$ba620e4c@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 17 2003 - 03:38:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US