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

From: A. Fuentes <alvarof2_at_hotmail.com>
Date: Mon, 15 Sep 2003 05:20:57 GMT
Message-ID: <Z_b9b.18050$KW1.16627_at_twister.austin.rr.com>


Fellow Oracle Netters:

I have the following problem:

Enviroment: Oracle9i/AIX5.2/Veritas vxvm

I am trying to create an Oracle database using RAW devices UNDER the Veritas vxvm.(Veritas Volume Manager).

Brief Antecedents:

I created the necessary veritas raw devices for the Oracle Database files
(controlfiles, system, logfiles, datafiles), /dev/vx/rdsk/oradg/cntrl1,
/dev/vx/rdsk/oradg/cntrl2,
/dev/vx/rdsk/oradg/log1, /dev/vx/rdsk/oradg/system1, etc without any problem,
I changed the permissions and ownership to oracle:dba, and ofcourse enabled write permissions.

To check that I can write to the Veritas raw volumes (devices) I used the dd commnad, and AIX wrote to them just fine. (Also I checked the veritas vxvm
daemons are running). I also have the AIX bos.rte.vxvm to allow both AIX and Veritas
Volume Managers to coexist.

The Problem:

When I try to create a very simple database like (at the SQL> prompt logged as
sys as sysdba ofcourse):

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

it FAILS to create the database (see error message at the end of this post). Now if I do the database creation using the SAME raw devices but UNDER the AIX volume manager creates the database without any problem and uses the raw devices.
Also if I do the trick, of creating a soft link to the veritas raw device it fails and works if I use the raw device under AIX LVM.

Questions:

1)Is there something else to tell Oracle sql that the files to be used for the database creation
are under Veritas?

2)I understand that if I was using RAC, I would have to export DBCA_RAW_CONFIG=myveritas_rawdevices_mapping.txt, but it is not the case here. So is there a similar mapping like this when NOT using RAC?

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"

(Note, in the above run, I used jfs files for the control files, so the
first veritas to
try to access were the log1 and log2, but comes with the same stream or ORA errors if I use the Veritas raw devices to place the control
files)

Any ideas/thoughts/clues/suggestions would be greatly appreciated.

Best,

  1. Fuentes 512-297-9937
Received on Mon Sep 15 2003 - 07:20:57 CEST

Original text of this message