Re: Oracle Export Error ( 9.2.0.6 on Solaris 2.9)

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_at_gmail.com> 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_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