RE: Failure while trying to start the database : Please Help

From: Kevin Kostyszyn <kevin_at_dulcian.com>
Date: Fri, 12 Jan 2001 11:05:35 -0500
Message-Id: <10739.126506@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_0017_01C07C87.964B2470 Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

If this is 8i and on NT, there is a directory under Oracle home called database, there is an init file in there that points to the init.ora file in the pfile folder. If you don't change the name there it won't start. Kev
-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Mark Leith Sent: Friday, January 12, 2001 9:27 AM To: Multiple recipients of list ORACLE-L Subject: RE: Failure while trying to start the database : Please Help

Have you tried to start up using the pfile option?

SQL>startup pfile=PATH/init.ora

Are there any errors in the alert log, or any errors accompanying this error? There should be more information in the error stack..

  HTH   Mark
    -----Original Message-----
    From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of Sanjay Kumar

Sent: Thursday, January 11, 2001 07:26 To: Multiple recipients of list ORACLE-L Subject: Failure while trying to start the database : Please Help

Hi,

I created a database using DB CreateAssistant. Then I went to the pfile where the init.ora is placed. I renamed the filename and after sometime renamed it back to original. But it seems like it is not taking/reading that file.

I get ORA-01078 failure in processing system parameters

Kindly help.

Sanjay

------=_NextPart_000_0017_01C07C87.964B2470 Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; =

charset=3Diso-8859-1">

<META content=3D"MSHTML 5.50.4207.2601" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><SPAN class=3D718130416-12012001><FONT face=3DArial color=3D#0000ff =

size=3D2>If=20
this is 8i and on NT, there is a directory under Oracle home called = database,=20
there is an init file in there that points to the init.ora file in the = pfile=20
folder.  If you don't change the name there it won't=20 start.</FONT></SPAN></DIV>
<DIV><SPAN class=3D718130416-12012001><FONT face=3DArial color=3D#0000ff =

size=3D2>Kev</FONT></SPAN></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT =
face=3DTahoma=20
  size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com=20   [mailto:root_at_fatcity.com]<B>On Behalf Of </B>Mark = Leith<BR><B>Sent:</B>=20
  Friday, January 12, 2001 9:27 AM<BR><B>To:</B> Multiple recipients of = list=20
  ORACLE-L<BR><B>Subject:</B> RE: Failure while trying to start the = database :=20
  Please Help<BR><BR></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D066361914-12012001>Have=20
  you tried to start up using the pfile option?</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001>SQL>startup pfile=3DPATH/init.ora=20
</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN =
class=3D066361914-12012001>Are=20
  there any errors in the alert log, or any errors accompanying this = error?=20
  There should be more information in the error stack.. = </SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001>HTH</SPAN></FONT></DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001></SPAN></FONT> </DIV>
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
  class=3D066361914-12012001>Mark</SPAN></FONT></DIV>
<BLOCKQUOTE style=3D"MARGIN-RIGHT: 0px">
    <DIV class=3DOutlookMessageHeader dir=3Dltr align=3Dleft><FONT = face=3DTahoma=20

size=3D2>-----Original Message-----<BR><B>From:</B> root_at_fatcity.com =

[mailto:root_at_fatcity.com]<B>On Behalf Of </B>Sanjay = Kumar<BR><B>Sent:</B>=20

Thursday, January 11, 2001 07:26<BR><B>To:</B> Multiple recipients = of list=20

ORACLE-L<BR><B>Subject:</B> Failure while trying to start the = database :=20

Please Help<BR><BR></DIV></FONT>

    <DIV><FONT face=3DArial size=3D2>Hi,</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>I created a database using DB =

CreateAssistant.=20

Then I went to the pfile where the init.ora is placed. I renamed the =

filename and after sometime renamed it back to original. But it = seems like=20

it is not taking/reading that file.</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2><STRONG>I get ORA-01078 failure in = processing=20

system </STRONG></FONT></DIV>

    <DIV><FONT face=3DArial =
size=3D2><STRONG>parameters</STRONG></FONT></DIV>
    <DIV><STRONG><FONT face=3DArial =
size=3D2></FONT></STRONG>&nbsp;</DIV>
    <DIV><FONT face=3DArial size=3D2>Kindly help.</FONT></DIV>
    <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial=20

Received on Fri Jan 12 2001 - 10:05:35 CST