Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Runing logmnr always 3113 and core dump!

Runing logmnr always 3113 and core dump!

From: zhu chao <chaospku_at_163.net>
Date: Wed, 04 Sep 2002 21:38:18 -0800
Message-ID: <F001.004C815F.20020904213818@fatcity.com>


hi, list friends:

	I am trying to analyze the redo log in oracle 8172 64bit on solaris.Whatever i tried , it always core dump after fetching about 60k records from the v$logmnr_contents.
	I tried to analyze the logfile on 8172(64bit), 901 64bit on solairs, but in vain.
	Here is the example output:

04-SEP-02 update "EACHPAY"."UL_USERLOGIN
04-SEP-02 update "ACCOUNT"."USERSTATISIN 04-SEP-02 update "BIDDER"."SHOPCATALOG"
ERROR:
ORA-03113: end-of-file on communication channel 66600 rows selected.

        and in the background trace file, there is alert like: Errors in file /export/home/oracle9i/admin/test9i/udump/test9i_ora_4534.trc: ORA-07445: exception encountered: core dump [FFFFFFFF7F790794] [SIGSEGV] [Address not mapped to object] [0x0000000D8] [] []

	Count(*)from v$logmnr_contents also give out such error.
	I tried to enlarge the shared_pool, shared_pool_reserved to 
SQL> show parameter shared_pool
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_reserved_size            big integer 20000000
shared_pool_size                     big integer 234881024
	Still get that error.
	Is there someone also ever hit similiar error ?







Regards
zhu chao
Eachnet DBA
86-21-32174588-667
chao_ping_at_vip.163.com
กกกกกก

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: zhu chao
  INET: chaospku_at_163.net

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 05 2002 - 00:38:18 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US