Thanks for everythingee Hi guy

[binjovi]

Thanks for everythingee
Hi guys am getting a funny error ,you guys can help me in it.
my system is oracle 8i and the system is in non archive log mode . From the next startup I wananna start archiving so I went to the init.ora file and uncommented the 3 parameters after shutting down the database
Log_archive_start=true,etc...

in the next logon the system is showing an error
cannot startup instance..

when i comment it again its working perfect .

thanks
bins

 

[rcurva]

Can you post which parameters you uncommented from init.ora?
Post also the error that you encountered while bringing up the db.

I suspect a typo error here...

 

[sem]

How about log_archive_dest? Does it point to some directory you (oracle) can write to?

 

[lfoata]

When you enable log archiving, the first thing oracle does when Iit goes up it to write a log, if the operation fails, oracle will not go up.
Check the write permissions in the log directory and also check is the variable log_archive_dest is set.

 

[binjovi]

Thanks Guys
Sorry I coudnt come back to you yesterday

The parameter which I uncommented are
log-archive_start=true
log_archive_dest_1=path..
log_archive_format='%....

The error which pops up is
ora-439
can not startup oracle8i instance..

But if I comment these parameters again its start the db

Thanks
Bins

 

[rcurva]

The parameter which I uncommented are
log-archive_start=true
log_archive_dest_1=path..
log_archive_format='%....


I found something, log-archive_start should be log_archive_start.

Check also if the log_archive_dest is existing or the Oracle user has write privs to it (ref to sem & lfoata postings).

 

[binjovi]

Thanks rcurva
Thazzz was a typing mistake by me Log_archive_start=true and as posted by sem and ifoata it all has satisfied..

The error shown is

ora-439
can not startup oracle8i instance..

Regards
bins

 

[rcurva]

Found another one, log_archive_dest_1, I haven't used multiple archive destinations, so i can not say if its incorrect, but i suggest you start with the basics first.

Your parameters should be:

log_archive_start=true
log_archive_dest=/log/archive
log_archive_format='ark%t_%s.dbf'