CREATE DATABASE causes "ORA-00376: file 1 cannot be read at this time" - Why?

From: John Haskins <76054.334SPAMBEGONE_at_compuserve.com>
Date: Thu, 28 Oct 1999 16:57:29 GMT
Message-ID: <Zf%R3.235$hp5.12108@dfiatx1-snr1.gtei.net>

Greetings, all:

I'm trying to figure out why I can't create a new database on an existing system that already has four instances. This is in Oracle 7.3.4.0.1 running on Solaris 2.6. The CREATE DATABASE command is producing the following error message in SVRMGRL:

     ORA-00603 Oracle Server session terminated by fatal error The Oracle docs say to check the trace log when this occurs. The trace file contains these messages:

     ORA-00376: file 1 cannot be read at this time
     ORA-01110: data file 1: '/u01/oracle/oradata/CC/system01.dbf'

About the ORA-00376, the Oracle docs only say "An attempt was made to read from a file that is not readable. The most likely cause is that the file is off line."

Oddly, the system01.dbf file is created. I can't figure out why Oracle cannot subsequently use it. Any help on this will be much appreciated!

My CREATE DATABASE commands follow. They aer a modification of the commands shown in O'Reilly's "Oracle Database Administration: The Essential Reference".

     spool create_CC.log
     connect internal
     startup nomount pfile=/u01/app/oracle/product/7.3.4/dbs/initCC.ora
     CREATE DATABASE CC
     MAXINSTANCES 10
     MAXLOGFILES 32
     MAXLOGMEMBERS 3
     MAXLOGHISTORY 100
     MAXDATAFILES 1000
     CHARACTER SET US7ASCII
     DATAFILE


          '/u01/oracle/oradata/CC/system01.dbf'


          SIZE 80M
          AUTOEXTEND ON
     LOGFILE


          '/u06/oracle/oradata/CC/CC_01.rlf' SIZE 20M,


          '/u06/oracle/oradata/CC/CC_02.rlf' SIZE 20M,


          '/u06/oracle/oradata/CC/CC_03.rlf' SIZE 20M,


          '/u06/oracle/oradata/CC/CC_04.rlf' SIZE 20M,


          '/u06/oracle/oradata/CC/CC_05.rlf' SIZE 20M


     ;

Received on Thu Oct 28 1999 - 11:57:29 CDT