Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Sun Solaris Close - cannot turn archive log on

Re: Sun Solaris Close - cannot turn archive log on

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Fri, 7 Jun 2002 10:03:11 +0100
Message-ID: <3d0076d0$0$231$ed9e5944@reading.news.pipex.net>


It looks to me (you don't say) as though you have standard edition but are using log_archive_dest_n=<blah> in your init.ora. This will give the managed standby err message. For standard edition use log_archive_dest=<blah>.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************
"Eva Haiden" <eva.haiden_at_engnetworld.com> wrote in message
news:52046b21.0206070058.12778413_at_posting.google.com...

> Dear Oracle users,
>
> I have the following problem: I am running Oracle 8.1.7 on a Sun
> Solaris Sparc Clone. Using the Database Assistent I am trying to
> create a database instance with archive mode enabled.
>
> If I turn the archive log on, the database instance will not be
> created. When starting the instance, I receive the error message:
> "ORA-01034 Oracle not available".
>
> If I turn the archive log off, the database instance is created fine.
> But if I try to turn on the archive log after the instance has been
> created with ALTER DATABASE it lasts only as long as the database is
> not shutdown. With the next start of the instance the archive log mode
> is turned off again.
>
> If I modify the init<instance name>.ora file to enable the archive
> mode, the database instance starts with the error message: "ORA-00439
> feature not enabled Managed standby" and acts like a standby database
> even it is the initial database.
>
> I appreciate any help!
Received on Fri Jun 07 2002 - 04:03:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US