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 -> ORA-01274 When trying to run create database command on Oracle 9i, Suse 7.2

ORA-01274 When trying to run create database command on Oracle 9i, Suse 7.2

From: rshome <rshome_at_ntlworld.com>
Date: Wed, 12 Sep 2001 17:34:54 +0100
Message-ID: <b7Mn7.27351$9h7.472868@news11-gui.server.ntli.net>


Getting this error. Have not got any of the OMF (Oracle Managed Files) parameters set. At a loss here, anyone got any ideas ?

Richard

SQL> connect sys/change_on_install as sysdba Connected.
SQL> create database RJS9
  2 maxinstances 1
  3 maxlogfiles 8

  4  datafile '/u01/app/oracle9/oradata/RJS9/system01.dbf' size 200M reuse
  5  logfile  '/u01/app/oracle9/oradata/RJS9/redo01.log'   size 10M ,
  6           '/u01/app/oracle9/oradata/RJS9/redo02.log'   size 10M ,
  7           '/u01/app/oracle/oradata/RJS9/redo03.log'   size 10M ;
create database RJS9
*
ERROR at line 1:
ORA-01501: CREATE DATABASE failed
ORA-01276: Cannot add a file with an Oracle Managed Files file name. Received on Wed Sep 12 2001 - 11:34:54 CDT

Original text of this message

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