Re: ORA-01034: Oracle not Available

From: John Schneider <JohnSchneider_at_bigfoot.com>
Date: 2000/06/28
Message-ID: <395A657A.ED152795@bigfoot.com>#1/1

Sybrand,

Thanks for the response! I checked the strtorcl.cmd file and it has not changed in over a year. The last time I used Oracle was just a few months ago, and everything was working fine then.

As to the listener.log file, here's the latest entry:

vvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvvv

TNSLSNR80 for 32-bit Windows: Version 8.0.4.0.0 - Production on 28-JUN-00 15:04:30

System parameter file is D:\orant\NET80\admin\listener.ora Log messages written to D:\orant\NET80\log\listener.log

Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\oracle.worldipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc))
Listening on: (ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))
Listening on: (ADDRESS=(PROTOCOL=nmp)(PIPENAME=\\JOHNNY\pipe\ORAPIPE))

Attempted to listen on:
(DESCRIPTION=(CONNECT_TIMEOUT=10)(ADDRESS=(PROTOCOL=TCP)(HOST=johnny)(PORT=1521)))

TNS-12545: Connect failed because target host or object does not exist TNS-12560: TNS:protocol adapter error
TNS-00515: Connect failed because target host or object does not exist

   32-bit Windows Error: 49: Unknown system error
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^

I can't find any reference to the TNS-12545 error in any of the Oracle documentation. The only other thing I can think of is that the last time I was successfully in Oracle, I was in the office connected to our internal network. Lately, I've been working out of my home and not connected to the network. But, I can't understand what difference that would make?

Any other ideas?

Thanks again,
John

Sybrand Bakker wrote:

> 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