Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help: Oracle9i/AIX5.2/Veritas vxvm raw devices Problem
> 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 - 13:37:33 CDT