Re: Oracle Export Error ( 9.2.0.6 on Solaris 2.9)

  • From: Bala <oratips@xxxxxxxxx>
  • To: "Stefan Knecht" <knecht.stefan@xxxxxxxxx>, oracle-l <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 31 Mar 2007 11:45:18 -0400

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: