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

Actually I tried this, without the "reuse" and got the same error.

1. 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 Mon Sep 15 2003 - 20:19:04 CDT