Re: ORA-01034: Oracle not Available

Muralidhar,

Thanks for the response, but how do I set the ORACLE_SID? And, how would this have changed?

Thanks,
John

Muralidhar Prabhakaran wrote:

> Try setting the ORACLE_SID to the right instance name!!
> "John Schneider" <JohnSchneider_at_bigfoot.com> wrote in message
> news:395A657A.ED152795_at_bigfoot.com...
> > 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
> >
> > (c) Copyright 1997 Oracle Corporation. All rights reserved.
> >
> > 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=1
> 521)))
> >
> > 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
> > > > >

> Received on Thu Jul 06 2000 - 00:00:00 CDT