| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Innocent SQL causes an imminent process death..
Daniel Morgan wrote:
>
> Jonathan Lewis wrote:
>
> > I don't think I would call it a totally innocent SQL statement,
> > but I created an empty table, executed the query, and got
> > an ORA-03113 on 8.1.7.4.1, and an ORA-00600 on 9.2.0.1
> > with arguments [qctcte1],[0],[],[],[],[],[],[]
> >
> > Pass it on to Oracle support.
[...]
> >
> > Unemployed in the Valley wrote in message
> > <5ec5bf40.0210031003.2f3fd6a6_at_posting.google.com>...
> > >I wonder if anyone ever encountered something like this:
> > >
> > >Environment - Oracle 8.1.6 on Solaris 2.8
> > >Table "relations" defines the node hierarchy.
> > >
> > >SQL> connect username/password_at_server
> > >Connected.
> > >SQL> desc relations;
> > > Name Null? Type
> > > ----------------------------------------- --------
> > >----------------------------
> > > REC_ID NOT NULL NUMBER
> > > PARENT_NODE_ID NOT NULL NUMBER
> > > CHILD_NODE_ID NOT NULL NUMBER
> > > CREATION_DATE NOT NULL DATE
> > >
> > >SQL> select count(*)
> > > 2 from relations
> > > 3 start with parent_node_id=3
> > > 4 connect by prior child_node_id=parent_node_id
> > > 5 and prior child_node_id in (select 3 from dual)
> > > 6 ;
> > > select count(*)
> > >*
> > >ERROR at line 1:
> > >ORA-03113: end-of-file on communication channel
> > >
> > >-----------------
> > >
> > >I tried it on 3 different servers with the same results from Windows &
> > >Solaris clients.
>
> I take back what I said ... crashed my instance like a cheap plane. And I
> know the kernel parameters are correct.
>
> My apology to any and all DBAs and SysAdmins until the next 3113.
>
> Daniel Morgan
Don't be eating crow now - they're taking enough of a beating from the West Nile virus.
 |
 |