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
> > > >
> > > > <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 Thu Jun 29 2000 - 00:00:00 CDT
