Return-Path: Delivered-To: 2-oracle-l@orafaq.com Received: (qmail 23024 invoked from network); 11 Dec 2007 15:22:58 -0600 Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180) by static-ip-69-64-49-119.inaddr.intergenia.de with SMTP; 11 Dec 2007 15:22:58 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7B25E7D7944; Tue, 11 Dec 2007 16:22:58 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14251-09; Tue, 11 Dec 2007 16:22:58 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E46DC7D78C9; Tue, 11 Dec 2007 16:22:57 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 11 Dec 2007 15:36:01 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 371817D8052 for ; Tue, 11 Dec 2007 15:36:01 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 05022-03 for ; Tue, 11 Dec 2007 15:36:01 -0500 (EST) Received: from cingular.com (extmail11.cingular.com [170.35.225.26]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CAD9C7D806E for ; Tue, 11 Dec 2007 15:35:58 -0500 (EST) Received: from ([10.149.204.36]) by extmail11.cingular.com with ESMTP id KP-VYHG4.135633087; Tue, 11 Dec 2007 15:35:43 -0500 Received: from TBDCEXCH01.US.Cingular.Net ([10.148.7.41]) by td03xsmtp005.US.Cingular.Net with Microsoft SMTPSVC(6.0.3790.1830); Tue, 11 Dec 2007 14:35:43 -0600 X-MimeOLE: Produced By Microsoft Exchange V6.5 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C83C35.66922680" Subject: RE: Logminer failure Date: Tue, 11 Dec 2007 14:35:43 -0600 Message-ID: <6A4102F59ECFA248B81F7D08F031797801F55BBE@TBDCEXCH01.US.Cingular.Net> In-Reply-To: <3c5f7820712111144v7fa222b0u8ad320ff4f2850a9@mail.gmail.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Logminer failure References: <3c5f7820712111127o2689bd9t4bb5af2decc6d67d@mail.gmail.com> <6A4102F59ECFA248B81F7D08F031797801F55BB5@TBDCEXCH01.US.Cingular.Net> <3c5f7820712111144v7fa222b0u8ad320ff4f2850a9@mail.gmail.com> From: "Shamsudeen, Riyaj" To: "Sandra Becker" Cc: "oracle-l" X-OriginalArrivalTime: 11 Dec 2007 20:35:43.0060 (UTC) FILETIME=[667F2140:01C83C35] X-archive-position: 3851 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-to: oracle-l-bounce@freelists.org X-original-sender: RS2273@att.com Precedence: normal Reply-to: RS2273@att.com List-help: List-unsubscribe: List-software: Ecartis version 1.0.0 List-Id: oracle-l X-List-ID: oracle-l List-subscribe: List-owner: List-post: List-archive: X-list: oracle-l X-Virus-Scanned: Debian amavisd-new at localhost.localdomain ------_=_NextPart_001_01C83C35.66922680 Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable Sandra Can you please post call stack from the trace file? or send me the trace file? Do you still get this error, if you select sql_redo alone? Also, you might want to find which segment is causing this issue by querying repeatedly with increasing rownum values, like.. select sql_undo from v$logmnr_contents where rownum <11 , 51 ..etc..That will shed some light in to this issue too. =20 ________________________________ From: Sandra Becker [mailto:sbecker6925@gmail.com]=20 Sent: Tuesday, December 11, 2007 1:45 PM To: Shamsudeen, Riyaj Cc: oracle-l Subject: Re: Logminer failure =20 I'm using a dictionary file that I created from the same database. Here are the messages from the alert log. =20 Errors in file /u01/app/oracle/admin/prdruby/udump/prdruby_ora_6094.trc: ORA-00603: ORACLE server session terminated by fatal error ORA-00600: internal error code, arguments: [2662], [1], [2146717602], [6773], [2522054752], [16], [], []=20 =20 Sandy ------_=_NextPart_001_01C83C35.66922680 Content-Type: text/html; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable

Sandra

  &n= bsp;         Can you please post call stack from the trace file? or send me the trace = file?

  &n= bsp;         Do you still get this error, if you select sql_redo = alone?

  &n= bsp;         Also, you might want to find which segment is causing this issue by querying repeatedly with increasing rownum values, like.. select sql_undo from v$logmnr_contents where rownum <11 , 51 ..etc..That will shed some = light in to this issue too.

 

From: = Sandra Becker [mailto:sbecker6925@gmail.com]
Sent: Tuesday, December = 11, 2007 1:45 PM
To: Shamsudeen, Riyaj
Cc: oracle-l
Subject: Re: Logminer = failure

 

I'm using a dictionary file that I created from the same database.  Here are the messages from the alert = log.

 

Errors in file /u01/app/oracle/admin/prdruby/udump/prdruby_ora_6094.trc:
ORA-00603: ORACLE server session terminated by fatal error
ORA-00600: internal error code, arguments: [2662], [1], [2146717602], = [6773], [2522054752], [16], [], []

 


Sandy

------_=_NextPart_001_01C83C35.66922680-- -- http://www.freelists.org/webpage/oracle-l