Re: Oracle hangs on startup (9.2 on Win2000)
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: Paul Vincent <paul.vincent@xxxxxxxxx>
- Date: Tue, 2 Nov 2004 13:50:37 +0000
On Tue, 2 Nov 2004 12:10:17 -0000, Paul Vincent <paul.vincent@xxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
