From: alvarof2@hotmail.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,   
      
   A. Fuentes   
   512-297-9937   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)