Dropping a User Cascade from the EM Console Fails with ORA-7445 [_memcpy()+976] (Doc ID 1121949.1)

Last updated on FEBRUARY 07, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.3 and later
Information in this document applies to any platform.
***Checked for relevance on 22-Feb-2013***

Symptoms

Dropping a user cascade from the Enterprise Manager console fails with the following error:

ORA-07445: exception encountered: core dump [_memcpy()+976] [SIGSEGV] [Address not mapped to object] [0x000000000] [] []

The call stack contains the following functions:

<- memcpy <- qmtCopySharedStr <- qmtLoadSharedData <- qmtbInit
<- qmtInit <- qm_init_sga_pass1 <- qm_init_uga_helper <- rpiswu2 <- qm_run_as_ksys

Once a drop user cascade fails, any attempts to run utlrp.sql after that will hang.
Although the drop user cascade fails, all of the user's objects are removed. 

Attempting to drop a user without cascade just hangs.

The following error may also be encountered:

ORA-00600: internal error code, arguments: [qmtInit1], [], [], [], [], [], [], []


The LD_LIBRARY_PATH is set correctly on the database server:

ORACLE_HOME =        /oracle/product/10.2.0
LD_LIBRARY_PATH = /oracle/product/10.2.0/lib

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