My Oracle Support Banner

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

Last updated on JULY 16, 2019

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

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution
References


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.