You'll need to restore a backup copy of usr1orcl.ora and then do a recovery
procedure. I strongly suggest to call Oracle Tech support to assist you
with this.
--
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:j9sd4.3393$JI.74539_at_news3.mia...
> 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 of
> 1915680 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
