From oracle-l-bounce@freelists.org Thu Apr 28 08:33:43 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j3SDXhYl007225 for ; Thu, 28 Apr 2005 08:33:43 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j3SDXe4Z007216 for ; Thu, 28 Apr 2005 08:33:41 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 13EDD188AB5; Thu, 28 Apr 2005 07:11:57 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 22008-01; Thu, 28 Apr 2005 07:11:56 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7EF5D188865; Thu, 28 Apr 2005 07:11:56 -0500 (EST) Content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain X-MimeOLE: Produced By Microsoft Exchange V6.5.6944.0 Subject: RE: with complications in banner Date: Thu, 28 Apr 2005 13:10:21 +0100 Message-ID: <3D730671F3FB8C4EA73FD2E94A11F94703AF14@tshuklonmbx02.ERF.THOMSON.COM> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: with complications in banner Thread-Index: AcVL6V6pstazYF1+T6+42A+QHwBqBwAANSMQ From: To: , X-OriginalArrivalTime: 28 Apr 2005 18:15:08.0187 (UTC) FILETIME=[3598E6B0:01C54C1E] Content-Transfer-Encoding: 8bit X-archive-position: 19125 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Peter.Hitchman@thomson.com Precedence: normal Reply-To: Peter.Hitchman@thomson.com X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=0.3 required=5.0 tests=NO_REAL_NAME autolearn=no version=2.63 Hi, This type of trace file is not for use with tkprof. An ORA-00600 is an Oracle internal error. It will show you what SQL statement was running when the error was thrown. Do you have MetaLink access? If so it is possible to search the stack trace that appears in the trace file. I see that your are running 8.1.7.0, if you were to contact Oracle then they would advise you to apply the latest patchset for your platform (probably 8.1.7.4). Lastly please post replies to the list and not to me directly, you will probably get more help that way as more people will see the mail. Thanks Pete -----Original Message----- From: Onkar N Tiwary [mailto:onkarnath.tiwary@gmail.com] Sent: 28 April 2005 12:56 To: Hitchman, Peter (TS UK) Subject: Re: with complications in banner hi peter, I checked alert log and found this entry. ORA-00600: internal error code, arguments: [17182], [207301840], [], [], [], [], [], [] However upon check the same it says error in the trace file which on further investigation gives a lot of information in the coded form which i couldnt read. when used with tkprof the output was something like this: TKPROF: Release 8.1.7.0.0 - Production on Thu Apr 28 17:22:32 2005 (c) Copyright 2000 Oracle Corporation. All rights reserved. Trace file: E:\Oracle\admin\MPAPPDB1\udump\ORA05132.TRC Sort options: default ******************************************************************************** count = number of times OCI procedure was executed cpu = cpu time in seconds executing elapsed = elapsed time in seconds executing disk = number of physical reads of buffers from disk query = number of buffers gotten for consistent read current = number of buffers gotten in current mode (usually for update) rows = number of rows processed by the fetch or execute call ******************************************************************************** Trace file: E:\Oracle\admin\MPAPPDB1\udump\ORA05132.TRC Trace file compatibility: 8.00.04 Sort options: default 1 session in tracefile. 0 user SQL statements in trace file. 0 internal SQL statements in trace file. 0 SQL statements in trace file. 0 unique SQL statements in trace file. 86219 lines in trace file. No error reported in this output file. The command I executed is: tkprof <> <> Am I issuing wrong command ? If yes then wht will the command and if no then how to find where the error is?? shall I put the entire trc file information? On 4/28/05, Peter.Hitchman@thomson.com < Peter.Hitchman@thomson.com > wrote: Hi, I have seen this before when the session has thrown some kind of internal Oracle error, check the alert log. It never had any long term impact. Regards Pete -----Original Message----- From: oracle-l-bounce@freelists.org [mailto: oracle-l-bounce@freelists.org ]On Behalf Of Onkar N Tiwary Sent: 28 April 2005 06:09 To: oracle-l@freelists.org Subject: with complications in banner when i disconnect from the oracle server, sometimes the banner show this: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option *( With complications*) ---- ???? JServer Release 8.1.7.0.0 - Production Can anyone plz. tell me wht does it mean?????? -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@yahoo.com onkarnath.tiwary@gmail.com -- http://www.freelists.org/webpage/oracle-l -- Thanks & Regards, T. Onkar Nath Ph : +91-9826728111(Cell) to_onkar@yahoo.com onkarnath.tiwary@gmail.com -- http://www.freelists.org/webpage/oracle-l