Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Error ORA-01034: ORACLE not avilable

Re: Error ORA-01034: ORACLE not avilable

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 19 Aug 2000 09:44:56 +1000
Message-ID: <399dca3c$1@news.iprimus.com.au>

"Dave Morrison" <9904538_at_tay.ac.uk> wrote in message news:966431599.1442396631_at_silver...
> Hi,
> I am getting the same sort of problem as ppaxman_at_tampabay.rr.com and
> Alain Léglise Consultant <alc.info.conseil_at_freesurf.fr> (see two earlyer
> threads).
> I have just installed Oracle8i and created a database using dbassist.
> When I try to log into the database using eather SQLplus or the Oracle
 Server
> Manager I get the Error ORA-01034: ORACLE not avilable error.
> I have tryed to find out what this means and how to fix it in the oracle
> documentation but have so far come up blank.

The standard explanation is that the error message means you don't have your Instance running. However, it could be that it *is* running, just that when you type your connect string, Oracle is trying to connect to the wrong Instance (for example, if ORACLE_SID is not set properly) HJR
> Does anyone know where this error is documented or even better how to fix
 it.
> Note that my problem is different from Alain Léglise Consultant's who can
> at least get into his DB form an external client.
> I hope that someone will be able to help me out,
> David Morrison
Received on Fri Aug 18 2000 - 18:44:56 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US