Re: STARTUP Instance with (s)pfile -> invalid character
From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Tue, 22 Jun 2004 20:02:55 +0200
Message-ID: <cb9rvc$1m2$1_at_news3.tilbu1.nb.home.nl>
>>Hello,
>>
>>I try to do a STARTUP by SQL*Plus, but it gives me the following error messages.
>>By Oracle Enterprise Manager, shutdown and startup works.
>>
>>
>>SQL> startup pfile=\\C0027\database\SPFILEZWEITEDB.ORA
>>LRM-00123: invalid character 0 found in the input file
>>ORA-01078: failure in processing system parameters
>>SQL>
>>
>>
>>(9i , Windows2K)
>>
>>Any Idea?
>>
>>Thank You
>>
>>Joachim
Date: Tue, 22 Jun 2004 20:02:55 +0200
Message-ID: <cb9rvc$1m2$1_at_news3.tilbu1.nb.home.nl>
Romeo Olympia wrote:
[Quoted] > Seems to me that you're trying to start the instance by specifying a > spfile (SPFILEZWEITEDB.ORA) in a pfile parameter. Doesn't work that > way. > > You start the instance by either: > (1) Using the traditional text parameter file. > STARTUP PFILE={your text init.ora} > [Quoted] > (2) Or by a server parameter file. > STARTUP > > Joachim Hofmann <speicher_at_freenet.de> wrote in message news:<40D7FF7C.FD9E5809_at_freenet.de>... >
>>Hello,
>>
>>I try to do a STARTUP by SQL*Plus, but it gives me the following error messages.
>>By Oracle Enterprise Manager, shutdown and startup works.
>>
>>
>>SQL> startup pfile=\\C0027\database\SPFILEZWEITEDB.ORA
>>LRM-00123: invalid character 0 found in the input file
>>ORA-01078: failure in processing system parameters
>>SQL>
>>
>>
>>(9i , Windows2K)
>>
>>Any Idea?
>>
>>Thank You
>>
>>Joachim
Hm - missed that; the subject led me to believe an either/or situation; but you're right; pfile will not read (binary!) spfile data
-- Regards, Frank van BortelReceived on Tue Jun 22 2004 - 20:02:55 CEST