EXPDP TTS - ORA-07445 On TRANSPORTABLE_EXPORT/MATERIALIZED_VIEW_LOG (Doc ID 1567922.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

On : 11.2.0.3 version, Data Pump Export

When attempting to run a transport tablespace job in 11.2.0.3 the following errors occur:

expdp "'/ as sysdba'" system/manager DIRECTORY=my_dir DUMPFILE=expdp_tts.dmp LOGFILE=expdp_tts.log FILESIZE=1048576000 TRANSPORT_TABLESPACES=USRS, ...

Export: Release 11.2.0.3.0 - Production on Fri Jul 5 14:41:05 2013
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
...
Processing object type TRANSPORTABLE_EXPORT/POST_TABLE_ACTION
Processing object type TRANSPORTABLE_EXPORT/MATERIALIZED_VIEW_LOG
Job "SYS"."SYS_EXPORT_TRANSPORTABLE_01" stopped due to fatal error at 15:53:47
The Data Pump Worker trace file shows:

Trace file /poa01/oracle/server/diag/rdbms/poro/PORO/trace/PORO_dw00_18875274.trc
...
*** 2013-07-05 15:51:49.927
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x150] [PC:0x9000000348A8050, __as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [flags: 0x0, count: 1]
Incident 52428 created, dump file: /poa01/oracle/server/diag/rdbms/poro/PORO/incident/incdir_52428/PORO_dw00_18875274_i52428.trc
ORA-07445: exception encountered: core dump [__as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [SIGSEGV] [ADDR:0x150] [PC:0x9000000348A8050] [Invalid permissions for mapped object] []

ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/poa01/oracle/server/diag/rdbms/poro/PORO/cdump'
The alert logfile shows:

...
Fri Jul 05 10:53:42 2013
Exception [type: SIGSEGV, Invalid permissions for mapped object] [ADDR:0x150] [PC:0x9000000348A8050, __as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [flags: 0x0, count: 1]
Errors in file /poa01/oracle/server/diag/rdbms/poro/PORO/trace/PORO_dw00_66322482.trc (incident=52427):
ORA-07445: exception encountered: core dump [__as__21TxsOqCountedReferenceXT18TxsOqMdmRootSchema_FP18TxsOqMdmRootSchema()+48] [SIGSEGV] [ADDR:0x150] [PC:0x9000000348A8050] [Invalid permissions for mapped object] []
Incident details in: /poa01/oracle/server/diag/rdbms/poro/PORO/incident/incdir_52427/PORO_dw00_66322482_i52427.trc
...

The database registry shows valid components:

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms