Re: Startup trouble 8i on NT after bsod

I should have been more elaborate:

The listener is flaky as well. I get the following when doing a tnsping to the local BEQ connection:
TNS-12560: TNS:protocol adapter error

When using TCP-LOOPBACK I get
TNS-12541: TNS:no listener

I see no TNSLISTENER process in the task list but the services applet says it is started.So it's presumed dead.

Regards,
Jan Klaverstijn

• Original Message ----- From: "Sybrand Bakker" <oradba_at_sybrandb.demon.nl> Newsgroups: comp.databases.oracle.server Sent: Saturday, December 08, 2001 11:42 PM Subject: Re: Startup trouble 8i on NT after bsod

> On Sat, 8 Dec 2001 22:47:58 +0100, "Jan Klaverstijn"
> <jan_at_klaverstijn.nl> wrote:
>
> >Hi all,
> >
> >I run a small 8i server on my laptop for demo and development on Win2k.
> >Today my system crashed. I had a blue screen and my machine rebooted
> >spontaniously. Now Oracle starts without errors but nothing can connect
to
> >it. Before oracle.exe had a 60MB+ footprint. Now it's only 6MB.
> >
> >I have no clue where to begin trouble shooting. Any logs I can
create/find?
> >The system logs show no alerts related to Oracle. Any tools I could use?
Or
> >am I just stuffed? Can I salvage my data and reinstall oracle? So many
> >questions... Any help would be greatly appreciated.
> >
> >Regards,
> >Jan Klaverstijn
> >
>
> Check -
> alert<SID>.log the instance's bdump directory
> oradim.log in %ORACLE_HOME%\database
>
> Check whether the listener is running (implemented as the service
> OracleTNSlistener)
> Try to explain more precisely what isn't working. Can you connect to
> the database when you are running sqlplus on the laptop. Can you issue
> a connect / as sysdba on the laptop and use show sga or select * from
> v$database. If that's working it must be the listener
>
> Hth
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Sat Dec 08 2001 - 16:54:24 CST