Re: Creating PFILE from SPFILE with *.

From: Dave <x_at_x.com>
Date: Tue, 01 Mar 2005 20:12:55 GMT
Message-ID: <b14Vd.26398$8B3.10368@text.news.blueyonder.co.uk>

"HARI OM" <hari_om_at_hotmail.com> wrote in message news:1109703369.287586.7730_at_g14g2000cwa.googlegroups.com...
>I create my PFILE from my SPFILE using
> SQL> CREATE PFILE FROM SPFILE
>
> It creates a file when I OPEN it is NOT a NORMAL INIT.ORA File...
> Everyline starts with *. Example:
>
> *.aq_tm_processes=1
> *.compatible='9.2.0.0.0'
>
> When I start my DB with this file... it gives me ERRORS...
> SQL> startup nomount;
> ORA-01078: failure in processing system parameters
> LRM-00101: unknown parameter name 'q_tm_processes'
> SQL>
>
> Can anyone please HELP me on this...
>
> HARI OM
>

Yes it is a normal init.ora file. Its for RAC * is the instance, in this case any.

You have other issues with the file Received on Tue Mar 01 2005 - 14:12:55 CST