On Tue, 2 Nov 2004 12:10:17 -0000, Paul Vincent <paul.vincent@(protected) > wrote:
> > >
> > > "ORA-03113 (See ORA-03113.ora-code.com): 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 (See ORA-01031.ora-code.com): 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 (See ORA-03113.ora-code.com): end-of-file on communication channel " error.
and still no trace file? it might be in BDUMP rather than UDUMP of course.