Re: After Recovery: ORA-01078: failure in processing system parameters

You might be right about the compatible setting. When I used the default init.ora file (and modified it) to start up the DB I got the following in my alert file: alter database open
Switching redo format version from 8.0.5.0.0 to 8.0.0.0.0 at change 12239010
Sat Nov 27 16:52:25 1999
but I added compatile=8.0.5.0.0
Switching redo format version from 8.0.0.0.0 to 8.0.5.0.0 at change 12239026
Sat Nov 27 17:09:31 1999
and I found the bug :)

The original init.ora file was stating
compatible=8.0.5
(no zeroes)
Maybe it was never even started up with that parameter, b/c before it was shutdown and backed up it was running flawlessly for about 3 months.

Thanx for your help

On Sat, 27 Nov 1999 07:57:19 -0800, "Yass Khogaly" <ykhogaly_at_us.oracle.com> wrote:

>Verify the "compatible" setting. This should be set to a version equal to
>or lower than the current version being migrated. Also make sure the
>"ifile" parameter is valid. It should point to a valid "config<sid>.ora"
>file.Some of the parameters present in Oracle7 are obsolete in Oracle8 like
>:
>
>INIT_SQL_FILES,
>LM_DOMAINS,
>LM_NON_FAULT_TOLERANT,
>PARALLEL_DEFAULT_MAX_SCANS,
>PARALLEL_DEFAULT_SCANSIZE,
>SEQUENCE_CACHE_HASH_BUCKETS,
>SERIALIZABLE,
>SESSION_CACHED_CURSORS
>

Andrey Dmitriev	 eFax: (978) 383-5892  Daytime: (917) 373-5417
AOL: NetComrade	 ICQ: 11340726 remove NSPAM to email