Re: Startup trouble 8i on NT after bsod

I think your installation is toast. Your best bet is to backup your datafiles, control files, log files, parameter file any any other thing you can think of and reinstall Oracle. (Keep a text file of where these files should go. directory paths etc)

Once you have reinstalled Oracle you can then create a database with the DBCA utility using the same dbname. Stop the database and then copy your backup over these newly created files and startup your database.

HTH
Scott Watson.

Jan Klaverstijn <jan_at_klaverstijn.nl> wrote in message news:9uu5s7$2p6$1_at_scavenger.euro.net...
> 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 - 18:17:22 CST