| 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: help: ORA-01034 Oracle not available
Here is a more detailed set of messages about this error:
Cause:ORACLE was not started up. Possible causes are:
·The SGA requires more space than was allocated for it.
·The operating system variable pointing to the instance is 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, verify that ORACLE was linked correctly. Also, refer to the installation or user's guide for additional information about this error.
Also, the database service can be running without the instance being started.. Try
( from a cmd prompt )
set ORACLE_SID=[inset your sid name here]
svrmgrl
connect internal
startup pfile=[your init<sid>.ora file]
If it starts and opens ok, then the database itself has no problem ( like the lack of SGA space referred to in the above messages) and the problem probably is in the registry settings for auto-starting the instance on startup of the service..
hth
"Darren Anderson" <darren.anderson_at_uk.bosch.com> wrote:
>Oracle 8.0.5 on NT on Intel;
>
>We've been running this server for over a year in which time we've restarted
>the server on many occassions without any problems. However, after
>restarting it today, I'm getting "ORA-01034 Oracle not available" when
>trying to connect to either of my DBs.
>
>The LISTENER.ORA has not bee changed and looks fine, the listener service is
>running as are the DB services.
>
>Does anyone know why I'm getting this problem, especially given the fact
>that nothing has changed on the server?
>
>Darren.
>
-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Jul 12 2001 - 09:49:35 CDT
 |
 |