Re: Server crash!

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Thu, 31 Mar 2005 20:08:11 +0200
Message-ID: <3teo41h6ns5i6607sop9gmpr0i4svj5o86@4ax.com>

On 31 Mar 2005 07:57:14 -0800, "Zachary Ainsworth" <zakainsworth_at_gmail.com> wrote:

>Windows Server 2003 SE
>Oracle 10g 10.1.0.1 ( i think )
>Error Message:"iSQL*Plus Application Server
>> Service encountered a problem and needed to close.

IIRC, good old DOS sqlplus is still available, so as of yet your assertion 'nothing works' is unconfirmed. I*sqlplus is not the only access mechanism!

First of all, verify the service OracleService<SID> is running. Then start a cmd window, and issue
sqlplus /nolog
connect / as sysdba

If the database is *NOT* running, sqlplus will respond connected to an idle instance

Don't do anything. First verify the alert<SID>.log located in the directory pointed to by the parameter background_dump_dest. The default is c:\oracle\admin\<SID>\bdump.

If it contains any error messages at the end, post them here.

--
Sybrand Bakker, Senior Oracle DBA

Received on Thu Mar 31 2005 - 12:08:11 CST