Re: Oracle hangs on startup (9.2 on Win2000)

On Tue, 2 Nov 2004 12:10:17 -0000, Paul Vincent <paul.vincent_at_uce.ac.uk> wrote:
> > >
> > > "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
>
> OK
>
> > -- 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
>
> Hit a problem here: ORA-01031: insufficient privileges.
> Instead, I tried CONNECT SYS/password AS SYSDBA, and this worked OK.

fair enough.

>
> > startup
> >
> > you should get the underlying error.
> >
>
> This gave the "ORA-03113: end-of-file on communication channel" error.

and still no trace file? it might be in BDUMP rather than UDUMP of course.

a tar would be an excellent idea.

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