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:42:25 CST