Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle Error: ORA-01034, Oracle not available. Any ideas?
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...Received on Fri Jan 07 2000 - 00:00:00 CST
> 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
> > >
> > >
> >
> >
>
>
![]() |
![]() |