Oracle error ORA-01034 1

[thehutt]

I'm getting Oracle error ORA-01034 when trying to connect to oracle 8i using anything.
All of the Oracle services are running, the PATH seems to be set correctly, and yet it still gives me the same error.
I'd like to avoid reinstalling oracle.. any ideas?

 

[carp]

This error typically means your instance isn't up, but can also be due to other problems..
If you go to Metalink and query on ORA-1034, you will get quite a few articles returned - you should be able to find the answer to your problem in one of these articles.

 

[thehutt]

I found the source of the error. As it turns out, Oracle was set up to use more room than was available on the hard drive it was installed on. Changing all everything to the "small" settings in the init file solved the problem.

Too bad oracle gives such crappy error messages...

 

[MikeLacey]

you should have a command line utility that might help you with error numbers
[tt]
oerr ora 01034
[/tt]

Mike
michael.j.lacey@ntlworld.com

 

[Guest_imported]

What is the default password for the internal user in svrmgr30? I have the same problem now I have no way to the database to reset the configurations. Do I have to reinstall.