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

[Terry Dykstra]

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 <mses...@aldensys.com> wrote in message
news:ITnd4.2868$JI.6...@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
>
>

[Michael Sessions]

[Michael Sessions]

Is this included with Oracle 8.05? Where is it located??

IIFThen
Terry Dykstra <tdyk...@cfol.ab.ca> wrote in message
news:hYnd4.89173$n3.12...@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 <mses...@aldensys.com> wrote in message
> news:ITnd4.2868$JI.6...@news3.mia...

[Michael Sessions]

Scratch previous message, I found SVRMGR30. What INTERNAL password do I
use?? It's giving me insufficient privileges ORA-01031.

[Michael Sessions]

Scratch previous message. I used the ORACLE password. Let's hope it works.

IFFThen

[Michael Sessions]

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]

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 <mses...@aldensys.com> wrote in message

news:ISqd4.3250$JI.7...@news3.mia...

[Michael Sessions]

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 <tdyk...@cfol.ab.ca> wrote in message

news:Jyrd4.89194$n3.12...@news0.telusplanet.net...

[Michael Sessions]

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.

[Terry Dykstra]

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 <mses...@aldensys.com> wrote in message

news:j9sd4.3393$JI.7...@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.
>