Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Failure while trying to start the database : Please Help

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

From: Sanjay Kumar <ora_user_at_hotmail.com>
Date: Fri, 12 Jan 2001 09:35:31 -0800
Message-Id: <10739.126528@fatcity.com> 





This is a multi-part message in MIME format.



------=_NextPart_000_0036_01C07C7B.01C34550
Content-Type: text/plain;


        charset="iso-8859-1"


Content-Transfer-Encoding: quoted-printable



Thanks to all those who replied.



I found the problem and I would be happy and thankful if someone could =
give me an explanation.



In addition to renaming file, I commented out the "mts_dispatchers" =
parameter. This was the reason why it gave that error.=20



I am sorry to have U troubled.



Could someone give me an explanation as to why does it throw this error =
message. Should it not establish a dedicated server connection.
I am using NT with 816.



Sanjay





  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=3DPATH/init.ora=20



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



    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=20
      parameters

      Kindly help.

      Sanjay





------=_NextPart_000_0036_01C07C7B.01C34550
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.4134.600" name=3DGENERATOR>

<STYLE></STYLE>

</HEAD>

<BODY bgColor=3D#ffffff>

<DIV><FONT face=3DArial size=3D2>Thanks to all those who =

replied.</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>I found the problem and I would be =

happy and=20


thankful if someone could give me an explanation.</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>In addition to renaming file, I =

commented out the=20


"mts_dispatchers" parameter. This was the reason why it gave that error. =



</FONT></DIV>

<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>I am sorry to have U =

troubled.</FONT></DIV>


<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>Could someone give me an explanation as =

to why does=20


it throw this error message. Should it not establish a dedicated server=20
connection.</FONT></DIV>


<DIV><FONT face=3DArial size=3D2>I am using NT with 816.</FONT></DIV>

<DIV>&nbsp;</DIV>

<DIV><FONT face=3DArial size=3D2>Sanjay</FONT></DIV>

<BLOCKQUOTE dir=3Dltr=20



style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV style=3D"FONT: 10pt arial">----- Original Message ----- </DIV>
  <DIV=20


  style=3D"BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: =
black"><B>From:</B>=20


  <A title=3Dkevin_at_dulcian.com href=3D"mailto:kevin_at_dulcian.com">Kevin =
Kostyszyn</A>=20


  </DIV>


  <DIV style=3D"FONT: 10pt arial"><B>To:</B> <A =
title=3DORACLE-L_at_fatcity.com=20


  href=3D"mailto:ORACLE-L_at_fatcity.com">Multiple recipients of list =
ORACLE-L</A>=20


  </DIV>


  <DIV style=3D"FONT: 10pt arial"><B>Sent:</B> Friday, January 12, 2001 =
8:21=20


  AM</DIV>


  <DIV style=3D"FONT: 10pt arial"><B>Subject:</B> RE: Failure while =
trying to=20


  start the database : Please Help</DIV>
  <DIV><BR></DIV>


  <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.&nbsp; 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=20


  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> <A=20
    href=3D"mailto:root_at_fatcity.com">root_at_fatcity.com</A>=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=20
    class=3D066361914-12012001>Have you tried to start up using the =
pfile=20


    option?</SPAN></FONT></DIV>


    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D066361914-12012001></SPAN></FONT>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D066361914-12012001>SQL&gt;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>&nbsp;</DIV>
    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D066361914-12012001>Are there any errors in the alert log, or =
any=20


    errors accompanying this error? There should be more information in =
the=20


    error stack.. </SPAN></FONT></DIV>


    <DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
    class=3D066361914-12012001></SPAN></FONT>&nbsp;</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>&nbsp;</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=20


      [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=20
      CreateAssistant. Then I went to the pfile where the init.ora is =
placed. I=20
      renamed the filename and after sometime renamed it back to =
original. But=20
      it seems like it is not taking/reading that file.</FONT></DIV>
      <DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</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>


Received on Fri Jan 12 2001 - 11:35:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US