Re: 7.3.4 Database Creation Problem

Your database is in archivelog mode but you never issued 'archive_log_start' command and you apparently do not have the parameter 'log_archive_start = true' in your initxxx.ora file.

Take your database down. Put the parameter in your initxxx.ora file and then restart the database. Make sure you also have a 'log_archive_dest' parameter which points to the directory where you want to put your archived redo logs.

If you do not want to have archived redo logs then you must stop the database and the bring it back up with 'start mount' and then enter the command 'alter database noarchivelog' and then you can 'alter database open' to bring it up the rest of the way.

Ken

Michel Dupont wrote:

> when we create the database on SOLARIS 2.6 we have the message
>
> Thread 1 advanced to log sequence 4
> Current log# 4 seq# 4 mem# 0: /export/home/log4SGUTEST.dbf
> Mon Aug 2 18:04:12 1999
> ORACLE Instance sgutest - Can not allocate log, archival required
> Thread 1 cannot allocate new log, sequence 5
> All online logs needed archiving
> Current log# 4 seq# 4 mem# 0: /export/home/log4SGUTEST.dbf
> Mon Aug 2 18:05:39 1999
> could not connect to listener address:
> (ADDRESS=(PROTOCOL=ipc)(KEY=sgutest))
> Mon Aug 2 18:07:39 1999
> could not connect to listener address:
> (ADDRESS=(PROTOCOL=ipc)(KEY=sgutest))
> Mon Aug 2 18:09:40 1999
>
> What must we do?
Received on Mon Aug 02 1999 - 11:56:04 CDT