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

did this error happen the first time you ran the create database command?

If the error happened the second time you ran the create database command (after the first one produced errors), you need to erase all files created -- control files, datafiles, and log files.

In article <Zf%R3.235$hp5.12108_at_dfiatx1-snr1.gtei.net>,   "John Haskins" <76054.334SPAMBEGONE_at_compuserve.com> wrote:
> 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
> ;
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Oct 28 1999 - 21:09:08 CDT