Re: Innocent SQL causes an imminent process death..

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.
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminar dates:
> (see http://www.jlcomp.demon.co.uk/seminar.html )
>
> ____USA__________November 7/9 (Detroit)
> ____USA__________November 19/21 (Dallas)
> ____England______November 12/14
>
> The Co-operative Oracle Users' FAQ
> http://www.jlcomp.demon.co.uk/faq/ind_faq.html
>
> 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 Received on Thu Oct 03 2002 - 15:58:24 CDT