RE: cannot allocate new log

I am siding with Scott and would double-check that automatic archiving is on. Also, what are your log_archive_dest settings? If you are using log_archive_dest_n make sure you add the "reopen = nn" attribute.

At 08:49 AM 6/2/2003 -0800, you wrote:
>Nuala,
>
>It looks like the DB is waiting for you to manually archive the
>logs. Like Lisa suggested, could you do an archive log list from the
>sqlplus prompt and post the results? There are two steps in setting up
>archiving. You have to set the proper parameters in the init.ora file,
>and then bring the db up in mount mode to start the archiver before you
>open the database.
>
>-Scott

Wolfgang Breitling
Oracle7, 8, 8i, 9i OCP DBA
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).