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

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Error: ORA-01034, Oracle not available. Any ideas?

Re: Oracle Error: ORA-01034, Oracle not available. Any ideas?

From: Terry Dykstra <tdykstra_at_cfol.ab.ca>
Date: 2000/01/07
Message-ID: <Jyrd4.89194$n3.1223705@news0.telusplanet.net>#1/1

Try a shutdown abort (ugly, but sometimes you have no choice). That should cleanup that error. Then try to startup again.

--
Terry Dykstra (TeamSybase)
Canadian Forest Oil Ltd.
Check out Sybase Developer's Network: http://www.sybase.com/sdn

Michael Sessions <msessions_at_aldensys.com> wrote in message
news:ISqd4.3250$JI.71593_at_news3.mia...

> I'm now getting the following message:
>
> ORA-01033: Oracle startup or shutdown in progress
> Cause: An attempt was made to log on while Oracle is being started up or
> shut down.
>
> Action: Wait a few minutes. Then retry the operation.
>
> Well.... I waited for 1hr. and still got same message. I restarted the
> services and I'm back to ORA-01034.
>
> ???????
>
> IIFThen
> Terry Dykstra <tdykstra_at_cfol.ab.ca> wrote in message
> news:hYnd4.89173$n3.1217750_at_news0.telusplanet.net...
> > Run server manager, connect internal and try to startup.
> >
> > --
> > Terry Dykstra
> > Canadian Forest Oil Ltd.
> > Check out Sybase Developer's Network: http://www.sybase.com/sdn
> >
> > Michael Sessions <msessions_at_aldensys.com> wrote in message
> > news:ITnd4.2868$JI.64629_at_news3.mia...
> > > I cannot access Oracle. Get the error message:
> > >
> > > ORA-01034: Oracle not available
> > >
> > > The Oracle help documentation for this error says:
> > >
> > > [Start]
> > > Cause: Oracle was not started up. Possible causes include the
following:
> > >
> > > The SGA requires more space than was allocated for it. {What is
SGA????}
> > >
> > > The operating system variable pointing to the instance was improperly
> > > defined.
> > >
> > > Action: Refer to accompanying messages for possible causes and correct
the
> > > problem mentioned in the other messages. Retry after Oracle has been
> > > initialized.
> > >
> > > If Oracle has been initialized, then on some operating systems, verify
that
> > > Oracle was linked correctly. See the platform-specific Oracle
documentation.
> > > [End]
> > >
> > > Want I've done already:
> > >
> > > * restarted the following Oracle services:
> > >
> > > - OracleServiceORCL, OracleStartORCL, OracleWebAssistant,
OracleAgent80
> > >
> > > Did not fix my problem.
> > >
> > > * restarted server running Oracle.
> > >
> > > Did not fix my problem.
> > >
> > > Is there anything more I can try? Any other Oracle help doc, log
files, etc,
> > > that might point me to the problem and hopefully a solution?
> > >
> > > Thanks to all who respond.
> > >
> > > IIFThen
> > >
> > >
> >
> >
>
>
Received on Fri Jan 07 2000 - 00:00:00 CST

Original text of this message

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