469,579 Members | 1,063 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

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

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/log1, /dev/vx/rdsk/oradg/system1, etc without any
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
daemons are running). I also have the AIX bos.rte.vxvm to allow both AIX and
Volume Managers to coexist.

The Problem:

When I try to create a very simple database like (at the SQL> prompt logged
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;
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.


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
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 - 64bit
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release - 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
Any ideas/thoughts/clues/suggestions would be greatly appreciated.


A. Fuentes

Jul 19 '05 #1
0 5973

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by Fred Palmer | last post: by
1 post views Thread by frederic.germaneau | last post: by
2 posts views Thread by Ruslan A Dautkhanov | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.