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

From: Yass Khogaly <ykhogaly_at_us.oracle.com>
Date: Sat, 27 Nov 1999 07:57:19 -0800
Message-ID: <81ord7$elr$1@inet16.us.oracle.com>

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 Also these errors occur if the Advanced Networking Option is installed. When the
objects are being created the Installer assumes a database is already in place
and is running. If the Advanced Networking Option is installed and you are creating a database using the 8.0 installer do the following:

Bring up the Installer and create the database objects for the RDBMS option first.
Exit the Installer when this is finished.
Bring the Installer back up and create the database objects for the other products installed.

Solution Explanation:

By doing this you have created the database that is needed for the creation of the Advanced Networking Option database objects

"The Views expressed here are my own and not necessarily those of Oracle Corporation"

NetComrade <netcomradeNOSPAM_at_earthlink.net> wrote in message news:383f81e5.4934007_at_news.earthlink.net...
> hi All,
>
> I have ftp'ed uncompressed and untarred one of my DB's
> Mistakenly tried to open it with 7.3, but it complained about some
> variables not being properly set, then I realized that it was an 8.0.5
> backup, so I installed 8.0.5, and initially it was complaining about
> not having enough memory, and now this.
>
> ORA-01078: failure in processing system parameters
>
> Docs aren't saying anything useful
>
> ORA-01078: failure in processing initialization parameters
> Cause: A failure occurred during processing of the initialization
> parameters during system startup.
>
> Action: Refer to the diagnostic information in the accompanying
> message stack and take appropriate action.
>
>
> The permissions seem to be set right, ownership as well. The only
> thing that is different is that these files used to reside on 2.6
> Solaris, but were restored to a 2.7 Solaris, which shouldn't be a
> problem
>
Received on Sat Nov 27 1999 - 09:57:19 CST