Re: Oracle hangs on startup (9.2 on Win2000)

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Tue, 2 Nov 2004 11:26:46 +0000
Message-ID: <7765c897041102032637256585@mail.gmail.com>

On Tue, 2 Nov 2004 11:19:55 -0000, Paul Vincent <paul.vincent_at_uce.ac.uk> wrote:
> One other piece of information: when I try using Oracle Enterprise =
> Manager to connect to the database (using SYS as SYSDBA), I go to the =
> "General" tab on Instance/Configuration, and this shows the database in =
> a "down" state (red traffic light). I then try to open the database, =
> click Apply, and the "Starting up the database" step fails with the =
> error:
>
> "ORA-03113: end-of-file on communication channel"
>
> Does this shed any more light on the possible cause of the problem?
>
> Paul

Ok in that case I think I would do the manual startup thing.

at a command window on the server
oradim -edit -sid <your sid> -startmode manual -- try to avoid the service trying to start the instance. then
net start oracleservice<sid>
set oracle_sid=<your sid>
sqlplus /nolog

in sqlplus
connect / as sysdba
startup

you should get the underlying error.

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
--
http://www.freelists.org/webpage/oracle-l

Received on Tue Nov 02 2004 - 05:22:50 CST