Re: ORA-01034: Oracle not Available

In a dos box

set oracle_sid=<your sid>
svrmgr30

Or alternatively modify Oracle_SID in the registry.

Hth,

Sybrand Bakker, Oracle DBA

"John Schneider" <JohnSchneider_at_bigfoot.com> wrote in message news:3964CFF2.57409D9E_at_bigfoot.com...
> 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