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

For some reason, our news feed is giving me the replies to this without the original message, so I'm not 100% clear on the scenario here.

The 1274 error is normally referring to standby (see below). Are you running that?

ORA-01274 cannot add datafile 'string' - file could not be created

Cause: Automated standby file management was enabled but an added file could not automatically be created on the standby. The error from the creation attempt is displayed in another message. The controlfile file entry for the file will be 'UNNAMEDnnnnn'.

Action: Temporarily set STANDBY_FILE_MANAGEMENT to MANUAL and use the ALTER DATABASE CREATE DATAFILE statement to create the file. Then set STANDBY_FILE_MANAGEMENT to AUTO and restart standby recovery.

--
HTH.  Additions and corrections welcome.

Pete
Author of "Oracle8i: Architecture and Administration Exam Cram"
Now got a life back again that the book is released!

"Controlling developers is like herding cats."
Kevin Loney, Oracle DBA Handbook

"Oh no, it's not.  It's much harder than that!"
Bruce Pihlamae, long-term Oracle DBA

"rshome" <rshome_at_ntlworld.com> wrote in message
news:uQ0o7.874$QV4.14962_at_news11-gui.server.ntli.net...


> I've checked and I don't - both the db_create_file_dest and

> db_create_online_log_dest_1 parameters are null.

>

> I've tried setting those parameters and running the create database

command


> again without specifying the filenames and it still came up with the same

> error.

>

> Any more ideas?

>

> Richard

> godmann <allanwtham_at_yahoo.com> wrote in message

> news:95cd51c.0109121939.2b342b4_at_posting.google.com...

> > Hi there,

> >

> >   Check if you have a parameter DB_CREATE_FILE_DEST in your init.ora.

> >

> > Allan W. Tham

> > DBA

>

>