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

Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-01034: Oracle not Available

Re: ORA-01034: Oracle not Available

From: John Schneider <JohnSchneider_at_bigfoot.com>
Date: 2000/06/27
Message-ID: <395908DA.89A3DFCB@bigfoot.com>#1/1

I'm having the same problem. I had Oracle running fine on my laptop for a previous project. Once that project was complete, I disabled all the Oracle services. Now I'm on another Oracle project and I enabled the services, but when I try to go into imp80, SQL+, or anything else that access the ORCL instance, I get the error ORA-01034.

I also noticed that the OracleTNSListener80 service, although set to start automatically, was not running. When I try to start it, I get the error "Could not start the OracleTNSListener80 service on \\MYMACHINE. Error 1067: The process terminated unexpectedly".

I just went through the steps outlined below and here is the contents of the oradim80.log file:

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

Oradim80: Command Line Mode.

Service(s) and instance being started. Please wait... Startup Database ErrorFailed to startup the database.

Failed to start the instance.
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

Also, the file alrtorcl.log does not exist.

Any ideas?

Thanks!
John Schneider

Sybrand Bakker wrote:

> Do the following:
>
> Stop the OracleServiceOrcl
> This will stop the OracleStartORCL too
> start the service OracleStartORCL.
> Now search for the file oradim80.log
> Most likely it does have errors.
> If it doesn't have errors or only unclear messages
> search for the file alrtorcl.log too.
> Post them both and/or e-mail them to me.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <melita_at_my-deja.com> wrote in message news:8j7nt0$bas$1_at_nnrp1.deja.com...
> > Hi
> >
> > I can't connect to my database yet.
> > The services OracleServicesORCL and OracleStartORCL are running.
> > I need to export theses datas but when I try to use the EXP80 I got the
> > error:
> > EXP-00056: encontrado erro 1034 ORACLE (found error 1034 Oracle)
> > ORA-01034: ORACLE not available
> > EXP-00222:
> > Mensagem 2 de erro de sistema
> > System error message: No such file or directory
> >
> > EXP-00005: todas as tentativas de logon permitidas falharam
> > EXP-00000: Exportação encerrada sem êxito (Exporting failed)
> >
> > And When I try to test my database service with the Net8 Easy config I
> > got the message:
> >
> > The test was not successful.
> > ORA-01034: Oracle not available.
> >
> > Please someone help me, I can't lost these datas and I am a beginner.
> >
> > Thanks,
> >
> > /Melita
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
Received on Tue Jun 27 2000 - 00:00:00 CDT

Original text of this message

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