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: Langelage, Frank <frank_at_lafr.de>
Date: Mon, 15 Sep 2003 20:37:33 +0200
Message-ID: <bk50td$pc4pf$1@ID-48907.news.uni-berlin.de>

  1. 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 - 13:37:33 CDT

Original text of this message

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