Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: ORA-01034: Oracle not Available
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
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