Re: Oracle Export Error ( 9.2.0.6 on Solaris 2.9)

  • From: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>
  • To: Bala <oratips@xxxxxxxxx>
  • Date: Sat, 31 Mar 2007 21:08:27 +0200

Bala,

check the start of the tracefile
/oraadmin/NVUATDB/udump/nvuatdb_ora_8978.trc for the current SQL statement.

Stefan

On 3/31/07, Bala <oratips@xxxxxxxxx> wrote:

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@xxxxxxxxx> 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@xxxxxxxxx > 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

Other related posts: