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

I've also received the following message when I try to connect as internal.

ORA-01219: database not open: queries allowed on fixed tables/views only.

IIFThen
Terry Dykstra <tdykstra_at_cfol.ab.ca> wrote in message news:Jyrd4.89194$n3.1223705_at_news0.telusplanet.net...
> 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 CET