Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA-16024: - ORA-32004 - Parameter modification Error

641067Sep 3 2009 — edited Sep 3 2009

Hi all,
I have two errors after modifying the LOG_ARCHIVE_DEST_1 parameter. I've run this...

ALTER SYSTEM SET LOG_ARCHIVE_DEST_1='LOCATION=/u04/archive/EST OPTIONAL REOPEN=300' SCOPE=spfile;

and after restarting the instance, I found these errors

ORA-32004: obsolete and/or deprecated parameter(s) specified
ORA-16024: parameter LOG_ARCHIVE_DEST_1 cannot be parsed

I checked the spfile and I discovered an error in it due this change:

*.log_archive_dest_1='LOCATION=/u04/archive/EST OPTIONAL REPO^H^HOPEN=300'

"^H^H" these characters were inserted because an stty config error and I was not able to see them.

How should I procede to recover my instance?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 1 2009

Added on Sep 3 2009

#general-database-discussions

5 comments

2,686 views