Re: Oracle Export Error ( 9.2.0.6 on Solaris 2.9)

From: Bala <oratips_at_gmail.com>
Date: Sat, 31 Mar 2007 11:45:18 -0400
Message-ID: <9ea7ad870703310845o7711195cke98cf6bc466d0306@mail.gmail.com>

Thank you very much for the reply.

Errors in Alert Log file
###>

Errors in file /oraadmin/NVUATDB/udump/nvuatdb_ora_8978.trc: ORA-07445: exception encountered: core dump [FFFFFFFF7E6878FC] [SIGBUS] [Invalid address alignment] [0x457863657074696F] [] []

###>

Errors in generated trace file ( has 51000 Lines)

last 10 lines of the trace file
###>

5501CB6B:00000015     9     8 10442   9 Undo Segment 0 Onlined
5501D21B:00000016     9     8 10442   9 Undo Segment 0 Onlined
5501D8AA:00000017     9     8 10442   9 Undo Segment 0 Onlined
5501DF6D:00000018     9     8 10442   9 Undo Segment 0 Onlined
58A53F8A:00000019     9     0 10280   1 0x0000000000000009

KSTDUMP: End of in-memory trace dump
ssexhd: crashing the process...
Shadow_Core_Dump = partial

###

Selecting from DBA_REGISTRY - 4 rows are returned

CATALOG,CATPROC,JAVAVM,CATJAVA -- STATUS for all 4 are VALID

##

On 3/31/07, Stefan Knecht <knecht.stefan_at_gmail.com> wrote:
>
> Bala
>
> Check your alert log - you'll probably find an ORA-7445 in there, along
> with a message pointing to a trace file with the core dump. In that trace
> file you'll find the offending sql statement. That might help you to track
> down the issue.
>
> But it definetely smells like a service request with oracle support.
>
> Steafan
>
> On 3/31/07, Bala <oratips_at_gmail.com > wrote:
> >
> >
> > Export is failing with the following errors after it finishes exporting
> > all tables and before it starts exporting synonyms
> > running export with ROWS=N
> >
> > ####
> > exporting table VOUCHER_AO_TFS
> > . . exporting table VOUCHER_PAT
> > . . exporting table VW_INT_CMGNS
> > . exporting synonyms
> > EXP-00008: ORACLE error 3113 encountered
> > ORA-03113: end-of-file on communication channel
> > EXP-00000: Export terminated unsuccessfully
> > ###
> >
> > Oracle 9.2.0.6 on Solaris 2.9
> > any pointers is greatly appreciated
> >
> > Thanks
> > Bala --
> >
> >
> > --
> > Bala Rao
>
>
>

-- 
Bala Rao

--
http://www.freelists.org/webpage/oracle-l

Received on Sat Mar 31 2007 - 10:45:18 CDT