STARTUP Instance with (s)pfile -> invalid character

[Joachim Hofmann]

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

[Frank van Bortel]

Joachim Hofmann wrote:
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

You can't use a network drive, and UNC naming
--

Regards,
Frank van Bortel

[Romeo Olympia]

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}

(2) Or by a server parameter file.
STARTUP

Joachim Hofmann <speicher@freenet.de> wrote in message news:<40D7FF7C.FD9E5809@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

[Frank van Bortel]

Romeo Olympia wrote:
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} (2) Or by a server parameter file. STARTUP Joachim Hofmann <speicher@freenet.de> wrote in message news:<40D7FF7C.FD9E5809@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.ORALRM-00123: invalid character 0 found in the input fileORA-01078: failure in processing system parametersSQL>(9i , Windows2K)Any Idea?Thank YouJoachim

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 Bortel

[Joachim Hofmann]

Romeo Olympia wrote: 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.
Or by a server parameter file. STARTUP

Yes, thanks.

How does Oracle know where to look for the server parameter file?

Joachim

[Norman Dunbar]

On Wed, 23 Jun 2004 11:31:50 +0200, Joachim Hofmann
<speicher@freenet.de> wrote:
Romeo Olympia wrote: 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. Or by a server parameter file. STARTUPYes, thanks.How does Oracle know where to look for the server parameter file?Joachim


Morning,

the SPFILE is found on Unix in :

$ORACLE_HOME/dbs/spfileSID.ora

then

$ORACLE_HOME/dbs/spfile.ora


On Windows it is :

%ORACLE_HOME%\database\spfileSID.ora

then

%ORACLE_HOME%\database\spfile.ora


If STARTUP cannot find one of the above, it will drop down to a PFILE
called initSID.ora in the appropriate place. See note 16249.1 for all
the gory details.

You cannot specify a STARTUP SPFILE=, so what you do is this :

create a PFILE which has SPFILE='blah blah' as the only entry then
startup using that.


Cheers,
Norman.



Remove the obvious bit to reply to my email address.

[Romeo Olympia]

There is a default location for it. In unix, $ORACLE_HOME/dbs; in
windows, $ORACLE_HOME\database.

You can also create or use spfiles in non-default locations if you
want. See the Administrator's Guide for details.

Cheers.

Joachim Hofmann <speicher@freenet.de> wrote in message news:<40D94E06.4A021FBB@freenet.de>... Romeo Olympia wrote: 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. Or by a server parameter file. STARTUP Yes, thanks. How does Oracle know where to look for the server parameter file? Joachim