Pleas help me!!

[james07]

Does anyone know what this mean?

$dbstart
sql>Connected to an idle instance.
sql> ORA-00439: feature not enabled: Managed Standby
sql> Disconnected.

Database "usaf" warm started.

and from there, I can't mount or opend it up. When I check the Ora process running, there was none, only the listener is running..

help pleasee..

thanks

[wren01]

try shutdown abort, then startup again.

[james07]

I have try that already.. also try to dbstart force..

I don't know what the heck happened.

anymore ideas?

thanks

[sambavan]

What are you trying to start through the dbstart?

O.K if you are trying to start an oracle instance, usaf try doing the following (Cosidering that you are in the Unix environment)

set the environment variable


ORACLE_SID=usaf
also make sure that ORACLE_HOME, LD_LIBRARY_PATH and the PATH are set correctly.

$ svrmgrl
SVRMGR> Connect internal
SVRMGR> shutdown abort

SVRMGR> startup nomount
SVRMGR> alter database mount;

if you have the database in the archive mode, then issue
SVRMGR> recover database;

else
SVRMGR> alter database open;

SVRMGR> exit

This should help you to start the server.

If you encounter any error messages, please post them with the three letter extension of it.

Good luck,
Sam

[sreddy]

I don't know which version you guys are talking about. There is bug with Oracle Provided 816Startup script. Due to the banner info change, the script doesn't work. Try renaming existing one copying 815/817 dbstart script.

[gram2000]

Check your alert log for any details on the error. Somtimes you might find
some reference to trace files. you will have to look at those trace files too.

[james07]

Yeah, I have try your method, but I didn't get too far.

this is what I got when I try to start the instance.

SVRMGR> startup nomount
ORA-00439: feature not enabled: Managed Standby

And I did check all the settings.
oracle_sid
oracle_home


thanks.

[pando]

Sreddy that 8.1.6 buggy script simply doesnt start the database but doesnt give error as james is mentioning.

James are you using Enterprise Edition? Are you trying to enable archive log...?

[Edited by pando on 02-17-2001 at 08:23 PM]

[james07]

pando,

I'm using Standard 8.1.6 on Solaris 7..

I got it working now, and I know what it was. It had something to do with the stupid archive log. If I uncomment them out in initusaf.ora, then the damn thing give me the error, and it won't start the database, just warm instance.

i'm good for now, but gotta figure out a way to used the archive log, without having it messing up my database.


thanks

[pando]

you have log_arcgive_dest1 enabled I think standard edition doesnt support multiple archive destinations that's why