| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| 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?
I tried that and got the following svrmgr30 errors:
ORA-01122: database file 2 failed verification check ORA-01110: data file 2: 'E:\orant\database\usr1orcl.ora' ORA-01200: actual file size of 1328914 is smaller than correct size of1915680 blocks.
Is my usr1orcl.ora file which (I think) stores my database info like tables, sps, etc. corrupted??? This is something I obviously haven't run across before.
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 CST
 |
 |