Re: ORA-0600 -> ORA 3114 -> Why?

Nicholas,
hi. Ora 600 means that it is an oracle Internal error. That is Oracle's code did something that it was not supposed to do. You rebooted the machine . (Interesting solution) and you are ok now. I am assuming that something went wrong with your server at the very time of the second statement.

                                        Tapan

Nicolas Bronke wrote:
>
> Today after startup of our database machine we made a really simple query
> using sql-worksheet like
>
> select * from table order by col_a, col_B (everything okay)
> select * from table order by col_a, col_B then it the connection went lost
>
> Inside the Trace-Log we found
>
> Dump file D:\Oracle\admin\TMS\bdump\tmsALRT.LOG
> Fri Sep 24 11:31:39 1999
> ORACLE V8.1.5.0.0 - Production vsnsta=0
> vsnsql=d vsnxtr=3
> Windows NT V4.0, OS V5.101, CPU type 586
> Fri Sep 24 11:31:39 1999
> Errors in file D:\Oracle\admin\TMS\udump\ORA00278.TRC:
> ORA-00600: Interner Fehlercode, Argumente: [17182], [158115224], [], [], [],
> [], [], []
>
> And we could reproduce it but we did not had any explanation. Therefore we
> restarted our nt-station. Now everything works fine. No problem.
>
> But what could the reason for that?
> Problems with NT 4 SP4? It's not a big machine - only for testing.
> Problems with Oracle 8.1.5 and SQL*NET 2.3 (from Ora 7.3)? We did not
> installed any Java tools. We installed the SQL*Net from Ora 7.3 because some
> Application had some problems with the new sql*net. But it runs without
> problems until now.
>
> Any ideas?
> Kindest regards
> Nicolas Bronke

Received on Fri Sep 24 1999 - 09:47:02 CDT