Re: Help with odd ORA 3113 Error

This look like a known bug, same bug also produces ORA-08103 errors in some circumstances. A fix is available for almost all platforms.

As a work-around, drop your indexes and re-create them - this usually works.

Get in touch with oracle support ASAP.

Steve

Joe Kaczor wrote in message <6i7cqi$n6l$1_at_metro.atlanta.com>...
>Hello All,
>
> We are currently running across an odd Oracle error/bug.
>We are attempting a simple SQL query, and are being
>disconnect from the database every time we attempt it.
>
>The code is as follows:
>
>select count(*)
> from table_a
> where usercode4 = 'DX'
> and usercode1 = 'ACTV'
>/
>
>From UNIX we get kicked back to the $ prompt, from SQL*Plus
>client side (Win 95) we get ORA-3113 enc of communication
>channel (which makes sense, since it is automatically disconnecting
>from the database)
>
>But if we try this :
>
>select count(*)
> from table_a
> where usercode4 = 'DM'
> and usercode1 = 'ACTV'
>/
>
>We get our results back OK. (DX and DM are both values
>in the usercode4 column).
>
>Has anyone ever seen this happen before? Any help
>is greatly appreciated.
>
>DB version 7.3.2.3
>DG Platform
>
>TIA,
>Joe
>
>
Received on Wed Apr 29 1998 - 00:00:00 CDT