Re: ORA-01034: Oracle not Available

As to the startup problem. There should be a strt<sid>.cmd file in orant\database. This has a hardcoded internal password. Check that password. If it's different from the actual one your database won't start.

As to the listener problem: check \orant\net80\log\listener.log. This should come up with more specific messages.

Hth,

Sybrand Bakker, Oracle DBA

"John Schneider" <JohnSchneider_at_bigfoot.com> wrote in message news:395908DA.89A3DFCB_at_bigfoot.com...
> 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 Wed Jun 28 2000 - 00:00:00 CDT