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

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