Re: What can cause an ORA-03113 error?

This error means the oracle shadow has died. Most likely your statement caused the oracle kernel to get a SEGV. There should be a core file somewhere on the server, in the directory specified by core_dump_dest, or ?/dbs if that is not defined in your init.ora file (? = $ORACLE_HOME).

Also, there should be a trace file from that process in the trace directory, specified by user_dump_dest (or ?/rdbms/log if not defined in your init.ora file).

Have the trace file ready and call Oracle's World-Wide Support so that they can file a bug report, or if there is already a patch for the problem, they might be able to get it to you (depending on your support contract, etc).

Regards,
Don Beusee, Principal DBA, Oracle HQ Data Center.

aa365_at_FreeNet.Carleton.CA (Kenneth Werk) writes:
> I have two tables which should have a one to one relationship. On occasion
> some records in one of the tables is orphaned. In order to track these
> and correct the situation I can run a simple query like:
>
> select
> t1.resolver_name c1,
> t1.resolution_id c2,
> t1.short_description c3,
> t1.resolution_status c4,
> t1.date_created c5
> from
> solutions_1 t1,
> tickets_1 t2
> where
> t2.ticket_id is null and
> t2.resolution_id(+)=t1.resolution_id
> order by
> 2 asc;
>
> Resolution_id is the primary key of the solutions table.
> This works fine. However if I change the order by to order by 1 asc my
> connection to the database is lost when I receive this error -
> ERROR:
> ORA-03113: end-of-file on communication channel
>
> Column 1 is not indexed so clearly the difference is that Oracle 7 has to
> work much harder to do the order by. Some sort of resource is in short
> supply and my query is aborted.
>
> How can I find out where it is failing??
>
> Any response appreciated.
>
> Thanks,
>
> Ken
Received on Sun Jun 04 1995 - 00:00:00 CEST